Exam 10: Macros, Navigation Forms, Pivot

The accompanying figure displays a PivotChart. To change the chart type, use the _____ button, and then select the desired chart type.

The effects are different when a macro is run from a form versus when a macro is run from the Navigation Pane.

To add a field to the filter area of a PivotTable, click the field in the PivotTable Field List, click Filter Area from the list of available areas, and then click the _____ button.

The accompanying figure displays a navigation form for the Camashaly Design database. How do you add tabs to the navigation form?

Many macro actions require additional information, called the ____________________ of the action.

To create a PivotTable view of a query, click the ___________________ button arrow and then click PivotTable View.

To add an If statement to a submacro, double-click the If element from the ____________________ section of the Action Catalog.

To create a PivotChart based on a query, open the query, click the _____ button arrow, and then click PivotChart View.

To create a datasheet form, select the appropriate table, display the Create tab, click the More Forms button to display the More Forms menu and then click ____________________.

To add command buttons to a form, use the _____ tool in the Controls group on the Design tab.

To use a PivotChart based on a query, you first must open the query.

You cannot create a PivotChart from scratch.

A(n) ___________________ group is a rectangle containing a collection of option buttons.

To display the Action Catalog in the Macro Builder window, click the _____________________ button on the Design tab.

A menu control is a control that can display a variety of forms and reports.

In ____________________ mode, users can view data but cannot change it.

Data from fields in the _____ PivotChart drop area will appear as related groups of data.

A pop-up form is a form that stays on top of other open objects, even when another object is active.

Data mining is a technique that is used to analyze past data and predict future patterns and trends.