Question 1

You can use the Format property to display dates in a report using a Short Date format.

Accepted Answer

A) True 
 B)False

Question 2

To insert a page break in a report in Report Design view, click a section, and then press the CTRL+ENTER keys.

Accepted Answer

A) True 
 B)False

Question 3

To back up a database, you use the _____ command.

Accepted Answer

A)   Make a Backup
B)   Back Up Database
C)   Package and Sign
D)   Compact & RepairE) None of the above
F) A) and B)

Question 4

A group of related fields, such as all the demographic information for one customer, is called a _____.

Accepted Answer

A)   table
B)   record
C)   query
D)   fieldE) A) and B)
F) A) and D)

Question 5

A field with the Currency data type contains values such as quantities, measurements, and scores.

Accepted Answer

A) True 
 B)False

Question 6

A common place to use the Input Mask property is for a FirstName field.

Accepted Answer

A) True 
 B)False

Question 7

You can create a comment by starting the statement with _____.

Accepted Answer

A)   dim
B)   com
C)   rem
D)   ignoreE) All of the above
F) C) and D)

Question 8

Before you can edit actions in Macro Design View, you might need to click the Expand All button on the Macro Tools Design tab to display all the actions.

Accepted Answer

A) True 
 B)False

Question 9

To set a validation rule in the Employees table specifying that the DateHired field value must be greater than the DateBorn field value, you set the Validation Rule property for the _____.

Accepted Answer

A)   DateHired field
B)   Employees table
C)   DateBorn field
D)   databaseE) None of the above
F) C) and D)

Question 10

When you apply the Currency format to a field, Access displays a currency symbol and two values after the decimal point, but it does not change the field's data type.

Accepted Answer

A) True 
 B)False

Question 11

A _____ is a grid that displays fields as columns and records as rows.

Accepted Answer

A)   query
B)   datasheet
C)   logical table
D)   reportE) None of the above
F) All of the above

Question 12

To delete an action from a macro, point to the action in Macro Design View, and then click the Delete button.
​

Accepted Answer

A) True 
 B)False

Question 13

What are you doing when you enter data into a subdatasheet?

Accepted Answer

A)   You are entering properties for the fields.
B)   You are creating an alternate view of the data.
C)   You are enforcing referential integrity.
D)   You are entering records in the related table.E) A) and D)
F) B) and D)

Question 14

You cannot set the Field Size property for Short Text fields in Table Datasheet view.

Accepted Answer

A) True 
 B)False

Question 15

If the Navigation Pane is not open, click the _____ to open it and view the database objects.

Accepted Answer

A)   Shutter Bar Open/Close button
B)   Expand button
C)   View tab
D)   Navigation barE) C) and D)
F) A) and B)

Question 16

Which Short Text field property should you use to indicate users must enter a value in the field?

Accepted Answer

A)   Default
B)   Required
C)   Validation Rule
D)   Yes/NoE) A) and B)
F) B) and C)

Question 17

Access adds @ signs around date criteria in Date/Time fields.

Accepted Answer

A) True 
 B)False

Question 18

When you resize a label in Form Design view, _____.

Accepted Answer

A)   you do not see the changes until you switch to Form view
B)   you disconnect the label from its text box
C)   you resize the label in all the other views
D)   you do not have to save the design changeE) B) and C)
F) A) and D)

Question 19

Use the New (blank) record button to move the focus to the first record in a table.

Accepted Answer

A) True 
 B)False

Question 20

Which of the following are properties you can set for a Short Text field in Table Datasheet view? Select all the options that apply.

Accepted Answer

A)   Name
B)   Append Only
C)   Required
D)   Field SizeE) None of the above
F) A) and B)

Exam 9: Access

To insert a page break in a report in Report Design view, click a section, and then press the CTRL+ENTER keys.

Correct AnswerverifiedShow Answer

Which Short Text field property should you use to indicate users must enter a value in the field?

Correct AnswerverifiedShow Answer

Which of the following are properties you can set for a Short Text field in Table Datasheet view? Select all the options that apply.

Correct AnswerverifiedShow Answer

When you resize a label in Form Design view, _____.

Correct AnswerverifiedShow Answer

You can create a comment by starting the statement with _____.

Correct AnswerverifiedShow Answer

To back up a database, you use the _____ command.

Correct AnswerverifiedShow Answer

Before you can edit actions in Macro Design View, you might need to click the Expand All button on the Macro Tools Design tab to display all the actions.

Correct AnswerverifiedShow Answer

Access adds @ signs around date criteria in Date/Time fields.

Correct AnswerverifiedShow Answer

When you apply the Currency format to a field, Access displays a currency symbol and two values after the decimal point, but it does not change the field's data type.

Correct AnswerverifiedShow Answer

A field with the Currency data type contains values such as quantities, measurements, and scores.

Correct AnswerverifiedShow Answer

To set a validation rule in the Employees table specifying that the DateHired field value must be greater than the DateBorn field value, you set the Validation Rule property for the _____.

Correct AnswerverifiedShow Answer

A common place to use the Input Mask property is for a FirstName field.

Correct AnswerverifiedShow Answer

You can use the Format property to display dates in a report using a Short Date format.

Correct AnswerverifiedShow Answer

Use the New (blank) record button to move the focus to the first record in a table.

Correct AnswerverifiedShow Answer

What are you doing when you enter data into a subdatasheet?

Correct AnswerverifiedShow Answer

A group of related fields, such as all the demographic information for one customer, is called a _____.

Correct AnswerverifiedShow Answer

You cannot set the Field Size property for Short Text fields in Table Datasheet view.

Correct AnswerverifiedShow Answer

To delete an action from a macro, point to the action in Macro Design View, and then click the Delete button. ​

Correct AnswerverifiedShow Answer

A _____ is a grid that displays fields as columns and records as rows.

Correct AnswerverifiedShow Answer

If the Navigation Pane is not open, click the _____ to open it and view the database objects.

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

To delete an action from a macro, point to the action in Macro Design View, and then click the Delete button.

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified