Question 1

Which of the following are form views? Select all the options that apply.

Accepted Answer

A)   Layout
B)   Record
C)   Design
D)   Form

Question 2

The _____ property renames a field list in Query Design view.

Accepted Answer

A)   Caption
B)   Alias
C)   Field List
D)   Recordset

Question 3

You can convert a form's embedded macros to VBA by opening the form in Design View, and then clicking the Convert Form's Macros to Visual Basic button.

Accepted Answer

A) True 
 B)False

Question 4

You enter _____ criteria on the same row of the query design grid.

Accepted Answer

A)   NOT
B)   AND
C)   TEXT
D)   OR

Question 5

To display the VBA code for a form, click the Build button in one of the form's event properties.

Accepted Answer

A) True 
 B)False

Question 6

For a table, the _____ produces a report listing the field names, property values for each field, and table relationships.

Accepted Answer

A)   Linked Table Manager
B)   Database Documenter
C)   Performance Analyzer
D)   Object Dependencies pane

Question 7

Which of the following options for creating a form can you access on the Create tab? Select all the options that apply.

Accepted Answer

A)   Form Design
B)   Switchboard Form
C)   Split Form
D)   Form Wizard

Question 8

A subdatasheet shows the records on the "one" side of a one-to-many relationship.

Accepted Answer

A) True 
 B)False

Question 9

You can add a line to a report to indicate a subtotal.

Accepted Answer

A) True 
 B)False

Question 10

Which of the following text colors have meaning in VBA? Select all the options that apply.

Accepted Answer

A)   Red
B)   Blue
C)   Black
D)   Yellow

Question 11

Which of the following are true about action queries? Select all the options that apply.

Accepted Answer

A)   Every action query starts as a Select query.
B)   You run an action query by clicking the View button in Query Design View.
C)   An action query changes data.
D)   In the Navigation Pane, the icon for an action query includes an exclamation point.

Question 12

What happens if you delete a field from a table that contains data?

Accepted Answer

A)   Access stores the deleted data in a new table.
B)   Access stores the deleted data in a new field in the same table.
C)   You can append the deleted data to an existing table.
D)   You delete all the data in the field.

Question 13

Which of the following views provides the most options for creating and modifying a report?

Accepted Answer

A)   Report view
B)   Print Preview
C)   Report Design view
D)   Report Layout view

Question 14

To set the validation text for a table in Table Datasheet view, you use the _____ button on the Table Tools Fields tab.

Accepted Answer

A)   Validation
B)   Property Sheet
C)   Message
D)   Required

Question 15

In what part of the Access window do you rename a form?

Accepted Answer

A)   Navigation Pane
B)   Form view of the form
C)   Print preview of the form
D)   Backstage view

Question 16

Which of the following are Access objects?

Accepted Answer

A)   forms
B)   spreadsheets
C)   reports
D)   queries

Question 17

When you enter a record in a table, you are working in navigation mode.

Accepted Answer

A) True 
 B)False

Question 18

What can you do to hide the actions in a macro?

Accepted Answer

A)   Collapse all the actions in the macro.
B)   Single step through the macro.
C)   Set the macro's Visible property to No.
D)   Add a Group program flow to the macro.

Question 19

The Database Documenter provides step-by-step help for using an Access database.

Accepted Answer

A) True 
 B)False

Question 20

Which Access tool guides you through the steps of creating a report?

Accepted Answer

A)   Report Design view
B)   Control Wizard
C)   Report Wizard
D)   Report Previewer

Exam 9: Access

What happens if you delete a field from a table that contains data?

Correct AnswerverifiedShow Answer

You can convert a form's embedded macros to VBA by opening the form in Design View, and then clicking the Convert Form's Macros to Visual Basic button.

Correct AnswerverifiedShow Answer

For a table, the _____ produces a report listing the field names, property values for each field, and table relationships.

Correct AnswerverifiedShow Answer

You enter _____ criteria on the same row of the query design grid.

Correct AnswerverifiedShow Answer

Which of the following options for creating a form can you access on the Create tab? Select all the options that apply.

Correct AnswerverifiedShow Answer

The Database Documenter provides step-by-step help for using an Access database.

Correct AnswerverifiedShow Answer

To set the validation text for a table in Table Datasheet view, you use the _____ button on the Table Tools Fields tab.

Correct AnswerverifiedShow Answer

Which of the following are form views? Select all the options that apply.

Correct AnswerverifiedShow Answer

The _____ property renames a field list in Query Design view.

Correct AnswerverifiedShow Answer

You can add a line to a report to indicate a subtotal.

Correct AnswerverifiedShow Answer

To display the VBA code for a form, click the Build button in one of the form's event properties.

Correct AnswerverifiedShow Answer

Which of the following are Access objects?

Correct AnswerverifiedShow Answer

A subdatasheet shows the records on the "one" side of a one-to-many relationship.

Correct AnswerverifiedShow Answer

Which of the following are true about action queries? Select all the options that apply.

Correct AnswerverifiedShow Answer

Which of the following views provides the most options for creating and modifying a report?

Correct AnswerverifiedShow Answer

Which of the following text colors have meaning in VBA? Select all the options that apply.

Correct AnswerverifiedShow Answer

When you enter a record in a table, you are working in navigation mode.

Correct AnswerverifiedShow Answer

Which Access tool guides you through the steps of creating a report?

Correct AnswerverifiedShow Answer

In what part of the Access window do you rename a form?

Correct AnswerverifiedShow Answer

What can you do to hide the actions in a macro?

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