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

FIGURE AC 2-1 Which record is displayed on the simple form shown in Figure AC 2-1?

When you ____________________ a query, you perform the query with the most recent data, and give instructions to display the records and fields in your original query design.

To see how a report will look when printed, you can display it in the ____________________ window to make sure it looks the way you want.

A simple report created using the Report button includes ____.

Case AC 2-1 Anita prepared a report containing information about new products now available from her company. Now she wants to modify it before she prints it. If Anita wants to use the Format and Arrange contextual tabs to modify her report, she should display it in which view?

If you create a query using the Query Wizard, it is automatically ____ when you complete the wizard.

To sort text from Z to A, numbers from 9 to 0, or dates from latest to earliest, click the Descending button in the Sort & Filter group.

Reports can be printed from any view or even while closed.

The commands to sort and filter data are located on the ____ tab in the Sort & Filter group.

If you want to select which fields are included on a form and also choose the form layout and style, then you can use ____.

You can delete a form by right-clicking it in the Navigation Pane and clicking Delete on the shortcut menu.

When you choose to sort in ____________________ order, text is sorted from A to Z, numbers are sorted from 0 to 9, and dates are sorted from earliest to latest.

You can use the Form tool to create a simple form that includes all the fields from the selected record source.

Case AC 2-1 Anita prepared a report containing information about new products now available from her company. Now she wants to modify it before she prints it. If Anita accidentally deletes a field from the report, what can she do?

Which view allows you to make design changes to a form while it is displaying data?

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. If Rahim wanted to know which apartment would be available on a specific date, he would create a ____.

To run a query at any time, double-click it in the ____.

What is the purpose of a filter? Give examples of when a filter would be useful. When would you want to use a filter to display certain records instead of a query? When might you need to use a type of filter other than an AutoFilter? Give an example.

The navigation buttons located ____ can be used to move among records in a form.