Exam 5: Creating Reports and Forms

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 summary report.

To add an additional field to a form, click the _____ button to display a field list.

To clear a filter, click the ____________________ command on the Advanced menu.

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 customize the group title.

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

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

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

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

To add totals or other statistics to a report, use the _____ button on the Design tab.

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

The contents of the Detail section print once for each record in the table.

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

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 place the controls in a stacked control layout?

If you want to specify subtotals or other calculations within the Report Wizard, you use the Summary Options button.

To use a field list to add a field to a report in Layout view, click the _____ button on the Design tab to display a field list.

When you create an initial report using the Report Wizard, you can customize the report using either Layout view or Design view.