Exam 7: Advanced Report Techniques

To calculate the total of a field, such as Amount Paid, use the _____ aggregate function.

The Business Analyst Master List shown in the accompanying figure includes an unbound control. The process of converting an unbound control to a bound control is called ____________________.

To remove the Group, Sort, and Total pane when working on a report in Design view, click the _____ button on the Design tab.

To reverse the most recent change to a report, click the _____ button on the Quick Access Toolbar.

The row source for a report is the table or query that will furnish the data for the report.

Explain the difference between the Control Source property and the Record Source property.

The process of converting an unbound control to a bound control is called binding.

To display the Group, Sort, and Total pane, click the Group Report button.

The SubReport Wizard displays in the accompanying figure. To ensure that the wizard guides you through the process of adding a subreport, make sure the _____ button is selected.

The Business Analyst Master List shown in the accompanying figure is organized by sections. The contents of the ____________________ section are printed before the records in a particular group.