Question 1

A treelike structure of records in a database. Select the best fit for answer

Accepted Answer

A) Hierarchical database structure 
B) Relational database structure 
C) Multidimensional database structure 
D) Sequential database access 
A) Hierarchical database structure 
B) Relational database structure 
C) Multidimensional database structure 
D) Sequential database access A

Question 2

What's the best Access object for an invoice you'll mail to customers?

Accepted Answer

A) A report 
B) A form 
C) A table 
D) All of the above 
A) A report 
B) A form 
C) A table 
D) All of the above A

Question 3

All of the following terms are related to computerized databases except which one?

Accepted Answer

A) Search 
B) Sort 
C) Field names 
D) Record grab 
A) Search 
B) Sort 
C) Field names 
D) Record grab A

Question 4

DBMS is

Accepted Answer

A) Collection of data 
B) Set of programs to access those data 
C) Set of programs to update those data 
D) All of the above 
A) Collection of data 
B) Set of programs to access those data 
C) Set of programs to update those data 
D) All of the above

Question 5

What is the primary difference between a pivot table report and a cross tab query?

Accepted Answer

A) A pivot table report can contain sums, counts, and averages while a cross tab query cannot. 
B) You can't pivot a cross tab query 
C) A cross tab query lets you group similar items. A pitot table report does not 
D) None of above 
A) A pivot table report can contain sums, counts, and averages while a cross tab query cannot. 
B) You can't pivot a cross tab query 
C) A cross tab query lets you group similar items. A pitot table report does not 
D) None of above

Question 6

COPY STRUCTURE command is used to

Accepted Answer

A) Copy contents of an active database to a new file 
B) Copy all records of an active database to disk 
C) Copy contents of an active database to disk 
D) Copy structure of an active database to a new file 
A) Copy contents of an active database to a new file 
B) Copy all records of an active database to disk 
C) Copy contents of an active database to disk 
D) Copy structure of an active database to a new file

Question 7

This set of related data items is known as a

Accepted Answer

A) File 
B) Record 
C) Table 
D) None of the above 
A) File 
B) Record 
C) Table 
D) None of the above

Question 8

The framework for storing records in database is a

Accepted Answer

A) Form 
B) Report 
C) Query 
D) Table 
A) Form 
B) Report 
C) Query 
D) Table

Question 9

The purpose of the Add-in Manager is to

Accepted Answer

A) Create macros and automate data processing 
B) Add or remove data in an existing database 
C) Add or remove templates, macros, and wizards 
D) All of above 
A) Create macros and automate data processing 
B) Add or remove data in an existing database 
C) Add or remove templates, macros, and wizards 
D) All of above

Question 10

The following language used by most of the DBMSs for helping their users to access data

Accepted Answer

A) High level language 
B) Query language 
C) SQL 
D) 4GL 
A) High level language 
B) Query language 
C) SQL 
D) 4GL

Question 11

Sub-schema can be used to

Accepted Answer

A) Create very different, personalized views of the same data 
B) Present information in different formats 
C) Hide sensitive information by omitting fields from the subschema's description 
D) All of the above 
A) Create very different, personalized views of the same data 
B) Present information in different formats 
C) Hide sensitive information by omitting fields from the subschema's description 
D) All of the above

Question 12

If you are entering data in a form, a quick way to cpy a value from the previous record is to press

Accepted Answer

A) Ctrl+' 
B) F6 
C) Ctrl+D 
D) None of the above 
A) Ctrl+' 
B) F6 
C) Ctrl+D 
D) None of the above

Question 13

The following command is used to search the record that satisfies the specified criteria

Accepted Answer

A) FOUND 
B) SEARCH 
C) GET 
D) LOCATE 
A) FOUND 
B) SEARCH 
C) GET 
D) LOCATE

Question 14

What is a largest collection of data stored in a computer? You might use this type of program to keep a record of all the friends in your address book.

Accepted Answer

A) Information Processing 
B) Spreadsheet 
C) Operating system 
D) Database 
A) Information Processing 
B) Spreadsheet 
C) Operating system 
D) Database

Question 15

What did the first Table Analyzer do?

Accepted Answer

A) Analyze the data in a set of flat files and automatically create a relational database system from that information 
B) Provide a graphic way to design relational databases 
C) Automate process of connecting tables to SQL Server 
D) None 
A) Analyze the data in a set of flat files and automatically create a relational database system from that information 
B) Provide a graphic way to design relational databases 
C) Automate process of connecting tables to SQL Server 
D) None

Question 16

What is a Grouped Report?

Accepted Answer

A) A type of report that can be generated by the Report Wizard 
B) A report that displays data that has been sorted in ascending or descending order 
C) A report that displays data grouped by fields you specify 
D) None 
A) A type of report that can be generated by the Report Wizard 
B) A report that displays data that has been sorted in ascending or descending order 
C) A report that displays data grouped by fields you specify 
D) None

Question 17

Pivot Table reports are good for

Accepted Answer

A) Analyzing large amounts of data 
B) Turning tables upside down 
C) Breaking spreadsheet data into multiple worksheet 
D) None of above 
A) Analyzing large amounts of data 
B) Turning tables upside down 
C) Breaking spreadsheet data into multiple worksheet 
D) None of above

Question 18

Need to see all the information from two tables on one form. Insert

Accepted Answer

A) A page break 
B) A subform 
C) A linked command button 
D) None of the above 
A) A page break 
B) A subform 
C) A linked command button 
D) None of the above

Question 19

Which field allow to select items from drop down list?

Accepted Answer

A) An OLE field 
B) A Memo Field 
C) A lookup Field 
D) A hyperlink field 
A) An OLE field 
B) A Memo Field 
C) A lookup Field 
D) A hyperlink field

Question 20

Which of the following are common ways to enforce data validation when entering data into an Access form?

Accepted Answer

A) Create an input mask to restrict the kind of value that can be entered in positions across the field. 
B) Define a validation rule for that field 
C) A and B 
D) none of the above 
A) Create an input mask to restrict the kind of value that can be entered in positions across the field. 
B) Define a validation rule for that field 
C) A and B 
D) none of the above

A treelike structure of records in a database. Select the best fit for answer

What's the best Access object for an invoice you'll mail to customers?

All of the following terms are related to computerized databases except which one?

DBMS is

What is the primary difference between a pivot table report and a cross tab query?

COPY STRUCTURE command is used to

This set of related data items is known as a

The framework for storing records in database is a

The purpose of the Add-in Manager is to

The following language used by most of the DBMSs for helping their users to access data

Sub-schema can be used to

If you are entering data in a form, a quick way to cpy a value from the previous record is to press

The following command is used to search the record that satisfies the specified criteria

What is a largest collection of data stored in a computer? You might use this type of program to keep a record of all the friends in your address book.

What did the first Table Analyzer do?

What is a Grouped Report?

Pivot Table reports are good for

Need to see all the information from two tables on one form. Insert

Which field allow to select items from drop down list?

Which of the following are common ways to enforce data validation when entering data into an Access form?

Database Management and Terminology

Database Management System

Database Management and Usage

Database Management and Access

Database Management System DBMS

Microsoft Access and Database Management: Tips and Techniques

Filters

Exam 1: Database Fundamentals and Management

A treelike structure of records in a database. Select the best fit for answer

What's the best Access object for an invoice you'll mail to customers?

All of the following terms are related to computerized databases except which one?

DBMS is

What is the primary difference between a pivot table report and a cross tab query?

COPY STRUCTURE command is used to

This set of related data items is known as a

The framework for storing records in database is a

The purpose of the Add-in Manager is to

The following language used by most of the DBMSs for helping their users to access data

Sub-schema can be used to

If you are entering data in a form, a quick way to cpy a value from the previous record is to press

The following command is used to search the record that satisfies the specified criteria

What is a largest collection of data stored in a computer? You might use this type of program to keep a record of all the friends in your address book.

What did the first Table Analyzer do?

What is a Grouped Report?

Pivot Table reports are good for

Need to see all the information from two tables on one form. Insert

Which field allow to select items from drop down list?

Which of the following are common ways to enforce data validation when entering data into an Access form?

Database Management and Terminology

Database Management System

Database Management and Usage

Database Management and Access

Database Management System DBMS

Microsoft Access and Database Management: Tips and Techniques

Filters