Exam 10: Macros, Navigation Forms, Pivot

You can include forms, reports, tables, and queries on the tabs of a navigation form.

A(n) _____ is a named location in computer memory.

The Submacro element is in the _____ category of the Action Catalog.

The OpenForm action is in the _____ category of the Action Catalog.

To add a submacro element to a macro, double-click the Submacro element from the Program Flow section on the Action Catalog.

The accompanying figure shows the macro for an option group. The RemoveTempVar action is in the _____ category of the Action Catalog.

You can save a macro as a VBA module using the Save Object As command in the Backstage view.

Explain the difference between a crosstab query and a PivotTable.

Titles cannot be assigned to an axis in a PivotChart.

To assign a macro to a command button, click ____________________ in the Categories box and then click Run Macro in the Actions box in the Command Wizard dialog box.

To begin creating a macro, click the _____ button on the Create tab.

A(n) ____________________ is a form that includes tabs to display forms and reports.