Exam 2: Access Lesson 2: Creating Queries, Forms, and Reports

AutoFilter options are specific to the type of data in that field.

You can sort data in Form view of a form, in Layout view of a report, or in Datasheet view of a query or table.

You can start the Query Wizard by clicking the Query Wizard button in the ____ group on the Create tab.

A selected field on a form is indicated by a(n) ____ border.

Forms are powerful tools that can extract data from one or more tables.

To make changes to a report, switch to Report view.

To be guided through the process of creating a query, click the Simple Query button.

A pencil icon is displayed in the upper-left corner of the form when a record is being edited.

Case AC 2-2 Rahim is the manager of a large apartment complex. Information about all of the apartments is stored in a database on the computer in the main office so he can access it easily. To control what types of information can be viewed, changed, or entered by other people in the office, Rahim would create a ____.

To view the entire gallery of themes, click the ____ button in the Themes group on the Form Layout Tools Design tab.

To move a field, use the Move Up or Move Down buttons in the Move group on the Form Layout Tools ____ tab.

Which of the following can be used as a record source?

Because a database is continually being updated, if you want to see the query results with the latest data, you must run the query.

The Report button guides you through the process of creating a report.

Using ____________________ view, you can view, enter, or edit data, but cannot change the layout or design of the form.

A select query ____.

To remove a filter, click the ____ button in the Sort & Filter group.

Which of the following actions can you perform on a report in the Print Preview window?

FIGURE AC 2-1 The newly created simple form shown in Figure AC 2-1 is displayed in ____ view?

When generated from a query, a ____ can enable you to create mailing labels of clients from a specific ZIP code.