Exam 6: Creating Reports and Forms

To clear a current filter, tap or click ____ on the Advanced menu.

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

A control layout is a guide that aligns the controls to give the form a uniform appearance.

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

You can emphasize values in a column that satisfy some criterion by formatting them differently from other values. This emphasis is called ___________________.

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

The ____ aggregate function finds the largest value.

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 add the date to the form?

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?

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

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 Detail section print once for each record in the table.

The body of the form is in the ____ section.

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

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

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?

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