Access: Module 4 Test Review

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

• Bound controls

• Unbound controls

• Title controls

• Calculated controls

____ shows the report on the screen but also allows you to make changes to the report.

• Print preview

• Layout view

• Report view

• Design view

____ shows the report as it will appear when printed.

• Report view

• Layout view

• Design view

• Print preview

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

• Group

• Sort

• Organize by Group

• Group & Sort

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

• Unbound controls

• Bound controls

• Calculated controls

• Aggregate controls

The ____ aggregate function finds the smallest value.

• Smallest

• Min

• TinyInt

• Least

The ____ aggregate function finds the largest value.

• Most

• Largest

• Max

• Grand

To add totals or other statistics to a report, use the ____ button on the DESIGN tab.

• Aggregate

• Statistics

• Sum

• Totals

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

• IF

• Conditional formatting

• Format

• Condition

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

• FORMAT

• CREATE

• DATABASE TOOLS

• HOME