Exam 7: Advanced Report Techniques

To ensure that a calculated control displays as currency, change the _____ property.

The SubReport Wizard displays in the accompanying figure. To add a subreport to a report, you use the _____ tool on the Design tab.

You can create new Access tables in either Datasheet view or Design view.

To change the report margins, click the Margins button on the _____ tab.

If a name is too long to fit in the available space, change the Can Grow property to Yes so that the name will extend to additional lines.

To display a Report Footer section, right-click any open area of the report and click _____ on the shortcut menu.

To cause the contents of the Group Header section to appear at the top of each page, change the Repeat Section property to Yes.

To select more than one control, click one of the controls and then hold the SHIFT key down while selecting the others.

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

To include a name for a calculated field in a query, type the name in the ____________________ property box in the property sheet.

If you move, rename, or modify linked tables, you can use the Linked Table Manager within the ____________________ tab to update the links.

You can align controls in the Report Design window using the Align button on the _____ tab.

To create a table in Design view, click the _____ button on the Create tab.

To create a report from scratch, click the Create tab, and then click the _____ button.

To select a smaller font size for a control, use the ____________________ property.

To display the Group, Sort, and Total pane, click the _____ button on the Design tab.

To add a date to a report, click the _____ button on the Design tab.