Question 1

The part of an If statement that is evaluated as either true or false is called a(n)  _____.

Accepted Answer

A)   procedure
B)   conditional expression
C)   event
D)   Else clause

Question 2

To move a field in Table Datasheet view, you select the column and then _____.

Accepted Answer

A)   copy and paste it at the end of the table
B)   drag it to a new location
C)   click the Move button on the Fields tab
D)   right-click the field and select a new location

Question 3

A parameter query displays a dialog box that prompts you for field criteria.

Accepted Answer

A) True 
 B)False

Question 4

Use Query Design view to display the results of a query.

Accepted Answer

A) True 
 B)False

Question 5

If you are creating a query using fields from two related tables, the join line Identifies which fields establish a relationship between the tables.

Accepted Answer

A) True 
 B)False

Question 6

To share form data among two or more programs, export the form as a(n)  _____ file.

Accepted Answer

A)   another Access database
B)   Excel
C)   XML
D)   PDF

Question 7

A new blank desktop database includes one table named Table1.

Accepted Answer

A) True 
 B)False

Question 8

Enter _____ criteria on different Criteria rows in the query design grid.

Accepted Answer

A)   AND
B)   Date/Time
C)   null
D)   OR

Question 9

In the Relationships window, which symbol identifies the field on the "many" side of the relationship?

Accepted Answer

A)   key symbol
B)   linking symbol
C)   infinity symbol
D)   expand symbol

Question 10

If you change data in its original location and it is linked to an Access database, you must also update the data in the Access database.

Accepted Answer

A) True 
 B)False

Question 11

What should you do if you want to make a copy of a database in a secure location?

Accepted Answer

A)   Back up the database.
B)   Compact and repair the database.
C)   Convert the database.
D)   Split the database.

Question 12

Which data type stores only one of two values?

Accepted Answer

A)   Hyperlink
B)   Date/Time
C)   Yes/No
D)   AutoNumber

Question 13

If you select a(n)  _____ control on a form in Form view, it means "yes" or "true".

Accepted Answer

A)   check box
B)   option button
C)   command button
D)   option group

Question 14

A form control with its Focus Stop property set to Yes will receive the focus in Form view.

Accepted Answer

A) True 
 B)False

Question 15

In a Date/Time field named HireDate, the validation rule expression >#7/1/21# means _____.

Accepted Answer

A)   the date must be after 7/1/21
B)   the date must be before 7/1/21
C)   the date must be in July of 2021
D)   the date must be 7/1/21

Question 16

The _____ property controls how many characters can be entered into the field.

Accepted Answer

A)   Format
B)   Required
C)   Input Mask
D)   Field Size

Question 17

When you use the _____, Access asks you for the information it needs to create a query.

Accepted Answer

A)   Create Query Wizard
B)   Form Wizard
C)   Query Design command
D)   Simple Query Wizard

Question 18

At what point does Access save the data in a database?

Accepted Answer

A)   when you close the database
B)   when you finish entering or editing a record
C)   when you click the Save button
D)   when you close a table

Question 19

When you delete a record containing an AutoNumber field, Access discards the value in the AutoNumber field and _____.

Accepted Answer

A)   reuses the same value in the next new record
B)   does not reuse the value
C)   changes the AutoNumber values in all other records
D)   prompts you for the value of the next new record

Question 20

You can create a mail merge in Word using name and address data stored in Access.

Accepted Answer

A) True 
 B)False

Exam 9: Access

At what point does Access save the data in a database?

Correct AnswerverifiedShow Answer

A form control with its Focus Stop property set to Yes will receive the focus in Form view.

Correct AnswerverifiedShow Answer

If you select a(n) _____ control on a form in Form view, it means "yes" or "true".

Correct AnswerverifiedShow Answer

What should you do if you want to make a copy of a database in a secure location?

Correct AnswerverifiedShow Answer

The _____ property controls how many characters can be entered into the field.

Correct AnswerverifiedShow Answer

If you change data in its original location and it is linked to an Access database, you must also update the data in the Access database.

Correct AnswerverifiedShow Answer

Enter _____ criteria on different Criteria rows in the query design grid.

Correct AnswerverifiedShow Answer

When you delete a record containing an AutoNumber field, Access discards the value in the AutoNumber field and _____.

Correct AnswerverifiedShow Answer

A parameter query displays a dialog box that prompts you for field criteria.

Correct AnswerverifiedShow Answer

In the Relationships window, which symbol identifies the field on the "many" side of the relationship?

Correct AnswerverifiedShow Answer

To share form data among two or more programs, export the form as a(n) _____ file.

Correct AnswerverifiedShow Answer

You can create a mail merge in Word using name and address data stored in Access.

Correct AnswerverifiedShow Answer

Which data type stores only one of two values?

Correct AnswerverifiedShow Answer

If you are creating a query using fields from two related tables, the join line Identifies which fields establish a relationship between the tables.

Correct AnswerverifiedShow Answer

In a Date/Time field named HireDate, the validation rule expression >#7/1/21# means _____.

Correct AnswerverifiedShow Answer

To move a field in Table Datasheet view, you select the column and then _____.

Correct AnswerverifiedShow Answer

The part of an If statement that is evaluated as either true or false is called a(n) _____.

Correct AnswerverifiedShow Answer

When you use the _____, Access asks you for the information it needs to create a query.

Correct AnswerverifiedShow Answer

Use Query Design view to display the results of a query.

Correct AnswerverifiedShow Answer

A new blank desktop database includes one table named Table1.

Correct AnswerverifiedShow Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified