Exam 6: Creating Reports and Forms

You use the ____ button in the Report Wizard dialog box to specify subtotals or other calculations within the wizard.

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

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

When you click the Group & Sort button on the FORMAT tab, Access displays a Group, Sort, and Total pane at the top of the screen.

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

To create labels using the Label Wizard, tap or click the ____________________ button in the Reports group on the CREATE tab.

Modified Multiple Choice When working on a report in Layout view, you can make additional layout changes by using the ____ tab(s).

Critical Thinking Questions Case 4-1 An employee at Bavant Publishing has created the report shown in the accompanying figure but needs some assistance in adding subtotals and grand totals. Bavant also would like some way to identify customers easily who have a current due amount of zero. How can the employee add subtotals and totals for the Amount Paid column?

When the data in a report is grouped, there are four additional sections.

To calculate the total of amount paid values, click the Totals button on the Format tab and then click Totals on the list of available calculations.

A report that includes the group calculations such as subtotals, but does not include the individual detail lines, is called a(n) ____ report.

The ____ section appears at the bottom of the form and often is empty.

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

A(n) ____ layout arranges controls horizontally with the labels across the top, typically in the Form Header section.

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

In ____ you cannot update the data, but you can make changes to the layout of the form.

To find themes that are not listed in Access but are available for download, tap or click the ____ command.

To add a date to a form, tap or click the ____ button on the DESIGN tab.

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

To use the Form Wizard to create a form for a table, select the table for the form in the Navigation Pane, tap or click the CREATE tab, and then tap or click the ____ button.