Question 1

A validation rule is entered as a(n) ____ in the Expression Builder.

Accepted Answer

A)  formula 
B)  expression 
C)  operation 
D)  lookup 
A)  formula 
B)  expression 
C)  operation 
D)  lookup

Question 2

You can also use a Quick Start selection to add commonly used fields to an existing table. In the Add & Delete group on the ____ tab, click the More Fields button, scroll down to the Quick Start section, and then click a Quick Start selection to add fields to the table.

Accepted Answer

A)  Tables 
B)  Records 
C)  Fields 
D)  Data 
A)  Tables 
B)  Records 
C)  Fields 
D)  Data

Question 3

A(n) ____________________ organizes data based on one or more fields.

Accepted Answer

The answer of A(n) ____________________ organizes data based on one...

Question 4

When you use ____, you select a field value (or part of a field value) in a datasheet, and then click the Selection button in the Sort & Filter group on the Home tab.

Accepted Answer

A)  Filter By Selection 
B)  Filter By Form 
C)  Filter by Query 
D)  Filter by Value 
A)  Filter By Selection 
B)  Filter By Form 
C)  Filter by Query 
D)  Filter by Value

Question 5

You use a query to ask Access a question.

Accepted Answer

A) True 
 B)False

Question 6

You add names to the parts of a(n) ____ so that you can use these names in the procedure.

Accepted Answer

A)  unbound function 
B)  record 
C)  label 
D)  control 
A)  unbound function 
B)  record 
C)  label 
D)  control

Question 7

When you create a table in Datasheet view, clicking the Click to Add field selector opens the list of data queries .

Accepted Answer

A) True 
 B)False

Question 8

Match between columns
                        Premises: If you click the Address block link in the Mail Merge task pane, the ____ Address Block dialog box opens and shows a preview of the address information.

Accepted Answer

The Answer of Insert and Mailings and Address and Edit is...

Question 9

After applying any filter to a field, clicking the ____ button in the Sort & Filter group on the Home tab removes it and displays all records again.

Accepted Answer

A)  Move Filter 
B)  Toggle Filter 
C)  Query Filter 
D)  Select Filter 
A)  Move Filter 
B)  Toggle Filter 
C)  Query Filter 
D)  Select Filter

Question 10

Parameter queries provide a single query that you may use many times .

Accepted Answer

A) True 
 B)False

Question 11

When using a report based on a parameter query, you need to create several reports.

Accepted Answer

A) True 
 B)False

Question 12

In a CSV file, ____ separate the field values of each record in the data source.

Accepted Answer

A)  commas 
B)  cells 
C)  colons 
D)  semi-colons 
A)  commas 
B)  cells 
C)  colons 
D)  semi-colons

Question 13

Which statement is true of hierarchal forms?

Accepted Answer

A)  They make database maintenance more difficult. 
B)  They make database security more difficult. 
C)  They help users select various database objects easily. 
D)  They help programmers select various database controls easily. 
A)  They make database maintenance more difficult. 
B)  They make database security more difficult. 
C)  They help users select various database objects easily. 
D)  They help programmers select various database controls easily.

Question 14

You can move a field in the design grid by clicking the bar above the field, and then dragging the field to the new location.

Accepted Answer

A) True 
 B)False

Question 15

To run a macro using the Database Tools tab, click the Run Macro button in the Macro group, select the macro in the Run Macro dialog box, and then click the ____ button.

Accepted Answer

A)  Execute 
B)  Query 
C)  OK 
D)  Run 
A)  Execute 
B)  Query 
C)  OK 
D)  Run

Question 16

When you use a template to create a database, the template creates the database and one or more table, query, form, and report themes that you use to enter and view data.

Accepted Answer

A) True 
 B)False

Question 17

Consistency in form design will ____.

Accepted Answer

A)  reduce the chance of errors 
B)  increase data accuracy 
C)  simplify the data entry 
D)  all of the above 
A)  reduce the chance of errors 
B)  increase data accuracy 
C)  simplify the data entry 
D)  all of the above

Question 18

A social security number is considered sensitive information.

Accepted Answer

A) True 
 B)False

Question 19

A form letter is a document that you create using Microsoft Word and that contains codes to tell Word where to insert the record from the data source. The codes are the same as the field names used in the data source.

Accepted Answer

A) True 
 B)False

Question 20

A good rule of thumb is to schedule a database backup ____.

Accepted Answer

A)  at the end of each day 
B)  after every record update 
C)  once a year 
D)  whenever the database owner requests it 
A)  at the end of each day 
B)  after every record update 
C)  once a year 
D)  whenever the database owner requests it

A validation rule is entered as a(n) ____ in the Expression Builder.

You can also use a Quick Start selection to add commonly used fields to an existing table. In the Add & Delete group on the ____ tab, click the More Fields button, scroll down to the Quick Start section, and then click a Quick Start selection to add fields to the table.

A(n) ____________________ organizes data based on one or more fields.

When you use ____, you select a field value (or part of a field value) in a datasheet, and then click the Selection button in the Sort & Filter group on the Home tab.

You use a query to ask Access a question.

You add names to the parts of a(n) ____ so that you can use these names in the procedure.

When you create a table in Datasheet view, clicking the Click to Add field selector opens the list of data queries .

After applying any filter to a field, clicking the ____ button in the Sort & Filter group on the Home tab removes it and displays all records again.

Parameter queries provide a single query that you may use many times .

When using a report based on a parameter query, you need to create several reports.

In a CSV file, ____ separate the field values of each record in the data source.

Which statement is true of hierarchal forms?

You can move a field in the design grid by clicking the bar above the field, and then dragging the field to the new location.

To run a macro using the Database Tools tab, click the Run Macro button in the Macro group, select the macro in the Run Macro dialog box, and then click the ____ button.

When you use a template to create a database, the template creates the database and one or more table, query, form, and report themes that you use to enter and view data.

Consistency in form design will ____.

A social security number is considered sensitive information.

A form letter is a document that you create using Microsoft Word and that contains codes to tell Word where to insert the record from the data source. The codes are the same as the field names used in the data source.

A good rule of thumb is to schedule a database backup ____.

Microsoft Excel Basics

Microsoft Office 2010 and the Internet

Microsoft Powerpoint Basics

Microsoft Word Basics

Filters

Exam 1: Microsoft Access Basics

A validation rule is entered as a(n) ____ in the Expression Builder.

You can also use a Quick Start selection to add commonly used fields to an existing table. In the Add & Delete group on the ____ tab, click the More Fields button, scroll down to the Quick Start section, and then click a Quick Start selection to add fields to the table.

A(n) ____________________ organizes data based on one or more fields.

When you use ____, you select a field value (or part of a field value) in a datasheet, and then click the Selection button in the Sort & Filter group on the Home tab.

You use a query to ask Access a question.

You add names to the parts of a(n) ____ so that you can use these names in the procedure.

When you create a table in Datasheet view, clicking the Click to Add field selector opens the list of data queries .

After applying any filter to a field, clicking the ____ button in the Sort & Filter group on the Home tab removes it and displays all records again.

Parameter queries provide a single query that you may use many times .

When using a report based on a parameter query, you need to create several reports.

In a CSV file, ____ separate the field values of each record in the data source.

Which statement is true of hierarchal forms?

You can move a field in the design grid by clicking the bar above the field, and then dragging the field to the new location.

To run a macro using the Database Tools tab, click the Run Macro button in the Macro group, select the macro in the Run Macro dialog box, and then click the ____ button.

When you use a template to create a database, the template creates the database and one or more table, query, form, and report themes that you use to enter and view data.

Consistency in form design will ____.

A social security number is considered sensitive information.

A form letter is a document that you create using Microsoft Word and that contains codes to tell Word where to insert the record from the data source. The codes are the same as the field names used in the data source.

A good rule of thumb is to schedule a database backup ____.

Microsoft Excel Basics

Microsoft Office 2010 and the Internet

Microsoft Powerpoint Basics

Microsoft Word Basics

Filters