Exam 5: Creating Reports and Forms

When working with a form, such as that shown in the accompanying figure, there are three different ways to view the form. They are Layout view, Form view, and  ____________________ view.

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

To add a title to a report, click Create on the Ribbon and then click the _____ button on the Design tab.

In the accompanying figure, you can 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.

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.

The contents of the Report Footer section print once at the bottom of each page and often contain a date and a page number.

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

When working with a form in Access, there are three ways you can view a form. What are these three ways and what does each view allow you to do?

Modified Multiple Choice For both grouping and sorting, there is a More button that you can click if you need to specify additional options. The options you then could select include _____.

Themes are standardized across all Office applications.

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

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

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

To add a date to a form, click the _____ button on the Design tab.

When the data in a report is grouped, the contents of the ___________________ section are printed after the group.

A(n) _____ layout arranges controls vertically with the labels to the left of the control.

The contents of the ___________________ section print once at the end of the report.

The body of the form is in the _____ section.

If you open a field list and the tables do not appear in the field list, click _____.