Exam 8: Access

In Query Design view, you enter parameter criteria within curly brackets, as in {Enter department:}.

To filter for comparative data, use the _____ feature.

In Form Design view, you can align controls and their contents.

When a module is embedded in a form or report, it is called a(n) _____.

Which of the following options can you set for a text box in a control layout? Select all the options that apply.

Use a(n) If statement to document a macro with explanatory text.

Access displays your user account information in the Navigation Pane.

When a record from one table is related to several records in another table, the tables have a one-to-many relationship.

You modify the Set New Page property of a section to force each section to start printing at the top of a new page.

Suppose you rename a field in Table Design view.What must you do before you can view the data in the table?

To view all the indexes in a table at the same time, use the Indexes button in Table Design view.

The report source is the table or query that contains the fields and records displayed in the report.

To remove filter criteria from the Filter by Form grid, you _____.

Each row in a table datasheet displays a _____.

Which of the following are good candidates for a primary key field for a Customer table? Select all the options that apply.

_____ data is scrambled so that it is indecipherable when opened by another program.

When you split an Access database, how many copies of the back-end database do you have?

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

To move a field in the query design grid, click its_____, and then drag it left or right.

When Molly inserts a label control on a form in Form Design view, the label displays Text12.Which property can she change for the label so it displays the text Listing Date?