Exam 8: Access

In Report Layout view, you can edit data but not labels.

How can you change the shape of a button from a rounded rectangle to an oval?

To create a banded rows effect in a report, you _____.

The lower pane of a split form displays a(n) datasheet view.

You can set a startup option to show or hide the Navigation Pane itself.

Which data type stores only one of two values?

Which of the following keystrokes can you use to navigate only through fields and records when editing a datasheet? Select all the options that apply.

A(n) _____ is a common control to place within an option group.

Joe adds the ClientName and ProjectID fields to the query grid.To find records without values in the ProjectID field, he can use Is Null as the criterion for the ProjectID field.

_____ modules are displayed as module objects in the Navigation Pane.

In a macro, a Group component lets you sort macro arguments.

You use conditional formatting to highlight important data in a report.

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

When you add a field with an Attachment data type to a form, it appears as a(n) Photo control.

A Make-Table query is a type of _____.

The Name property for a form determines the text to display in the form's tab.

When you add fields to a table in Table Design view, the _____ is optional.

To delete the Discount column from the query grid in Query Design view, click the Discount field in the field list and then press DEL.

Sam created a self join between two copies of the Employees table and then renamed one copy Managers.When he adds the LastName field from the Managers table and the LastName field from the Employees table to the query grid, which of the following statements describes the results?

One way to _____ a macro is to single step through the macro.