Exam 6: Creating Reports and Forms

In Layout view of a report, you can specify both grouping and sorting.

In the accompanying figure, ____ are used to display data that comes for the database, such as the customer number and name.

To use a field list to add a field to a report in Layout view, tap or click the ____ button on the DESIGN tab to display a field list.

The data in a report can come from one or more tables but the data in a form only can come from one table.

To add totals to the Amount Paid column in a report, tap or click the Aggregate button on the DESIGN tab.

To filter records on a form, tap or click the Advanced button on the ____ tab to display the Advanced menu.

____ shows the report as it will appear when printed.

To change the page setup and page layout options, such as adjusting margins and changing the orientation for a form, use the ____________________ window.

The contents of the Report Header section print once at the beginning of the report.

You can use the filter buttons in the Sort & Filter group on the Home tab to filter records in a report.

On a custom form, such as that shown in the accompanying figure, the controls for the fields are arranged vertically with labels to the left of the control. This is a(n) ____________________ layout.

To add more space between groups, enlarge the group header or group footer.

To create a report in Layout view, tap or click the ____ button on the CREATE tab.

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

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

To add a title to a report, tap or click CREATE on the ribbon and then tap or click the ____ button on the DESIGN tab.

To add an additional field to a form, tap or click the ____ button to display a field list.

___________________ are objects that display data and perform actions. They allow you to work with labels and images to improve the user interface.