Exam 5: Creating Reports and Forms

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

To create labels using the Label Wizard, click the _____ button on the Create tab.

To filter records in a report, use the filter buttons in the Sort & Filter group on the ___________________ tab.

The contents of the Page Header section print once at the top of each page and typically contain the column headings.

A control layout consists of a selection of colors and fonts for the various sections in a report or form.

The _____ section appears at the top of the form and usually contains the form title.

The ____ aggregate function finds the smallest value.

Modified Multiple Choice The three types of controls that can appear on a report are _____.

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

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

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 indicate whether Access is to attempt to keep portions of a group together on a page.

You cannot use the Report Wizard to create a report on multiple tables.

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

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

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. If the controls were arranged horizontally with the labels across the top, the form would have a(n) ____________________ layout.

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 the length of the value on which to group.

Critical Thinking Questions Case 4-2 An employee at Camashaly Design created the form shown in the accompanying figure. The form needs to be in a control layout and Camashaly would like to add a date to the form. How can the employee add the date to the form?

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

To create a report in Layout view, click the ___________________ button in the Reports group on the Create tab.