Exam 1: Access: Creating Reports and Forms

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

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

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

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.

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

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.

On a custom form, such as that shown in the accompanying figure, you could add a field by clicking the ____________________ button on the DESIGN tab.

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

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

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

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

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

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.

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

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

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

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

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

Once you decide on a general report style or theme, you should stick with it throughout your database.

When you view a report in Print Preview, you can make changes to the report.