Exam 3: Access: Advanced Report Techniques

To create a report from scratch, tap or click the CREATE tab, and then tap or click the ____ button.

To group controls, select the controls to group, and tap or click the Size/Space button on the REPORT DESIGN TOOLS ____________________ tab.

To use a wizard to add a subreport, the ____________________ button must be selected when you tap or click the Subform/Subreport tool on the REPORT DESIGN TOOLS DESIGN tab.

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

To add totals or other statistics to a footer, add a text box control.

The ____ aggregate function finds the largest value.

The contents of the ____ section are printed after the records in a particular group.

To assign a conditional value, use the ____ function.

To remove the field list when working on a report in Design view, tap or click the ____ button on the REPORT DESIGN TOOLS DESIGN tab.

The Book Rep 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.

To cause the contents of the Group Header section to appear at the top of each page, change the value of the ____ property.

To change the report margins, use the Margins button on the REPORT DESIGN TOOLS PAGE SETUP tab.

To assign a conditional value, use the ____________________ function.

To specify a primary key consisting of more than one field, tap or click the row selector for the first field, hold down the ____________________ key while tapping or clicking the row selector for the second field, and then tap or click the Primary Key button.

Modified Multiple Choice The Sizing & Ordering group on the Arrange tab includes the _____ buttons relevant to aligning and adjusting controls.

To add a page number to a report, use the Report Footer button.

To create a new query, tap or click the Query Design button on the CREATE tab.

You can align controls in the Report Design window using the Align button on the REPORT DESIGN TOOLS ____ tab.

In the accompanying figure, the Seminar Offerings table was added to the query by selecting the table and tapping or clicking the Add button in the ____ dialog box.

The Book Rep Master List shown in the accompanying figure displays in Design view. To view the report in Print Preview, tap or click the ____________________ button arrow and then click Print Preview on the menu.