Exam 6: Creating Reports and Forms

____ are used to display data that is calculated from other data, such as a total.

In the accompanying figure, you can tap or click the More button in the Group, Sort, and Total pane to specify additional options. The ____ option allows you to choose the length of the value on which to group.

To filter records in a report, use the filter buttons on the ____ tab.

To display the Conditional Formatting Rules Manager dialog box, tap or click the ____ button on the FORMAT tab.

The various objects on a report are called tools.

On a custom form, such as that shown in the accompanying figure, ____________________ controls have attached labels that typically display the name of the field that supplies the data for the control.

In the accompanying figure, you can tap or click the More button in the Group, Sort, and Total pane to specify additional options. The ____ option allows you to choose values to be totaled and where they are to appear.

When you create reports and forms, you should follow some general guidelines for report and form design. What are these eight guidelines?

The PAGE SETUP tab is available for both forms and reports.

In Access, mailing labels are a special type of form.

The Form Footer section appears at the bottom of the form and usually contains a date.

The ____ command on the Advanced menu allows you to sort records and enter criteria to restrict retrieval.

Modified Multiple Choice Available aggregate functions for use in a report include ____.

To adjust the margins or change the page orientation of a report, open the report in Layout view and then tap or click the ____ tab.

To specify grouping and sorting for a report, tap or click the ____ button on the DESIGN tab in Layout view.

Design view is most useful when the changes you need to make to a report are complex.

____ shows the form on the screen and allows you to use the form to update data.

____ are not associated with data from the database and are used to display such things as the report's title.

The ____ aggregate function finds the smallest value.

You can print all the records, a range of pages, or a selected record of a form by selecting the appropriate print range.