Deck 10: Macros, Navigation Forms, Pivot

Question 1

To create a blank form to use as a menu form, click the Create tab, and then click the _____ button.

A) Blank Form
B) Form Design
C) Design View
D) Menu Form

Answer 1

B

Question 2

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

A) Option Button
B) Bound Object Frame
C) Button
D) Command Button

Answer 2

C

Question 3

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

A) Option Group
B) Radio Group
C) Button Group
D) Command Group

Answer 3

A

Question 4

If a Security Warning appears when you open a database, click the ____ option button.

A) Access Options
B) Enable Content
C) Security
D) Warning

Question 5

To display a pop-up form for a control, such as Client Number in a datasheet form, create a user interface (UI) macro and set the value of the Window Mode argument to _____.

A) Pop Up
B) Window
C) Dialog
D) Read Only

Question 6

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

A) Database Objects
B) Macro Commands
C) System Commands
D) Program Flow

Question 7

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

A) Object
B) Macro
C) New
D) Design

Question 8

To proceed through a macro one step at a time, open the macro in Design view, and then click the _____ button on the Design tab.

A) Debug
B) One Step
C) Single Step
D) Step By Step

Question 9

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

A) Database Objects
B) Macro Commands
C) System Commands
D) Program Flow

Question 10

To run a macro, right-click the macro in the Navigation Pane and then click _____ on the shortcut menu.

A) Execute
B) Perform
C) Activate
D) Run

Question 11

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

A) Database Objects
B) Macro Commands
C) System Commands
D) Program Flow

Question 12

If you want to terminate the process of executing a macro one step at a time, click the _____ button in the Macro Single Step dialog box.

A) Cancel
B) Abort
C) End
D) Stop All Macros

Question 13

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

A) Database Objects
B) Macro Commands
C) System Commands
D) Program Flow

Question 14

PivotTables and PivotCharts are normally associated with _____.

A) Microsoft Word
B) Microsoft PowerPoint
C) Microsoft InfoPath
D) Microsoft Excel

Question 15

To make adjustments to Access security settings, click Options in the Backstage view and then click _____.

A) Security Options
B) Customize
C) Warnings
D) Trust Center

Question 16

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

A) Database Objects
B) Macro Commands
C) System Commands
D) Program Flow

Question 17

If you want to execute the next step in a macro, click the _____ button in the Macro Single Step dialog box.

A) Next
B) Single
C) Step
D) Run

Question 18

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

A) argument
B) option
C) action
D) variable

Question 19

The _____ lists macro actions organized by type.

A) Macro Catalog
B) Action Catalog
C) Arguments Column
D) Submacro Catalog

Question 20

To display a pop-up form for a control, such as Client Number in a datasheet form, create a user interface (UI) macro that is associated with the _____ event for the control.

A) Before Update
B) On Click
C) Open
D) Current

Question 21

If the PivotTable Field List does not appear, click the _____ button on the PivotTable tab to display the field list.

A) Add Fields
B) Field List
C) View Fields
D) List

Question 22

Data from fields in the _____ PivotChart drop area will be summarized within the chart.

A) Series
B) Category
C) Filter
D) Data

Question 23

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.

A) Show
B) Insert to
C) Add to
D) Place on

Question 24

The accompanying figure displays a PivotChart. To assign a title to an axis, click the Axis Title box for the axis you want to change, click the Property Sheet button on the Design tab, and then change the _____ property.

A) Title
B) Axis
C) Heading
D) Caption

Question 25

A(n) ____ macro is a special type of macro that is associated with specific table-related events.

A) action
B) table
C) event
D) data

Question 26

The accompanying figure displays a PivotChart. To change the chart orientation (fields that appear on the horizontal and vertical axis), click the _____ button.

A) Page Orientation
B) Chart Orientation
C) Switch Row/Column
D) Switch Horizontal/Vertical

Question 27

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

A) Chart Type
B) Chart View
C) Change Chart
D) Format

Question 28

To add a title to a PivotChart, click the _____ button in the property sheet for the chart.

A) Chart Header
B) Add Title
C) Chart Title
D) Header

Question 29

To create a navigation form, click the Create tab and then click the _____ button to display the menu of available navigation forms.

A) Menu
B) Control
C) More Forms
D) Navigation

Question 30

Data from fields in the _____ PivotChart drop area will not appear in the chart but can be used to restrict the data that appears.

A) Series
B) Category
C) Data
D) Filter

Question 31

If a field list appears when you create a navigation form, click the _____ button on the Design tab to remove the field list.

A) Add Existing Fields
B) Remove Fields
C) Field List
D) Remove List

Question 32

The accompanying figure displays a PivotChart. To add a legend to a PivotChart, click the _____ button on the Design tab.

A) Add Legend
B) Legend
C) Chart Legend
D) View Legend

Question 33

Data from fields in the _____ PivotTable drop area will not appear in the table but can be used to restrict the data that appears.

A) Row
B) Column
C) Filter
D) Data

Question 34

To change the heading for a column in a PivotTable, right-click the column heading, click the Property Sheet button on the Design tab, and then click the _____ tab on the property sheet.

A) Captions
B) Names
C) Headings
D) Format

Question 35

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

A) Row
B) Category
C) Column
D) Filter

Question 36

To remove fields from drop areas, click the field name and then press the _____ key(s).

A) CTRL+D
B) DELETE
C) ALT+N
D) CTRL+N

Question 37

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

A) View
B) Open
C) Table
D) Field List

Question 38

The accompanying figure displays a PivotChart. To remove the drop areas from the PivotChart, use the _____ button on the Design tab.

A) Remove
B) Clear
C) Drop Zones
D) Edit PivotChart

Question 39

To create a PivotTable from a query, open the query, click the _____ button arrow and then click PivotTable View.

A) Field List
B) View
C) Table
D) Open

Question 40

To open a query, right-click the query in the Navigation Pane and click _____ on the shortcut menu.

A) Datasheet view
B) Open
C) Run
D) Query View

Question 41

A navigation form contains a navigation control and a subform control.

Question 42

Modified Multiple Choice A data macro can be associated with _____ events.

A) Before Change
B) Before Delete
C) After Insert
D) After Update

Question 43

It is not possible for an action to have more than one argument.

Question 44

An option group is a rectangle containing a collection of option buttons.

Question 45

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

Question 46

Modified Multiple Choice The Database Objects category in the Action Catalog includes _____ actions.

A) OpenForm
B) OpenReport
C) ExportWithFormatting
D) Submacros

Question 47

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

Question 48

A PivotTable differs from a crosstab because a PivotTable is dynamic.

Question 49

Modified Multiple Choice You can view data in _____.

A) Datasheet view
B) Form view
C) PivotChart view
D) PivotTable view

Question 50

If the Action Catalog does not appear in the Macro window, click the Show Actions button on the Design tab.

Question 51

You can create navigation forms with horizontal tabs or vertical tabs.

Question 52

Modified Multiple Choice The drop areas available in PivotChart view are _____.

A) Series
B) Category
C) Filter
D) Data

Question 53

Many actions require additional information called arguments.

Question 54

Macros created for an option group are data macros.

Question 55

To instruct Access to perform different actions based on certain conditions, use a macro that contains a WhereCondition statement.

Question 56

To view VBA code that is attached to a form or report, open the form or report in Design view and click the VBA View button on the Design tab.

Question 57

Modified Multiple Choice You can include _____ on a navigation control.

A) forms
B) datasheets
C) reports
D) macros

Question 58

A user interface (UI) macro is a special type of macro associated with specific table-related events.

Question 59

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

Question 60

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

Question 61

Titles cannot be assigned to an axis in a PivotChart.

Question 62

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

Question 63

You cannot create a PivotChart from scratch.

Question 64

The various steps in a macro are called ____________________.

Question 65

PivotTables and PivotCharts can be used to analyze past data and predict future patterns and trends, a technique known as data detection .

Question 66

PivotTables and PivotCharts must be based on queries.

Question 67

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

Question 68

____________________ are collections of actions designed to carry out specific tasks.

Question 69

To give a chart a cleaner look, remove the drop areas from the PivotChart.

Question 70

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

Question 71

To create a PivotTable, you place fields in predefined areas of the table called drop areas.

Question 72

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

Question 73

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

Question 74

A data macro is a special type of macro that is associated with specific table-related events.

Question 75

To display the PivotTable Field List, click the Add Existing Fields button on the Design tab.

Question 76

There is only one chart type available for PivotCharts.

Question 77

Data macros are similar to SQL triggers.

Question 78

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

Question 79

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

Question 80

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