Question 1

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

Accepted Answer

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

Question 2

Match between columns
                        Premises: Replaces the switchboard manager.

Accepted Answer

The Answer of navigation form and pop-up form and Column is...

Question 3

To remove drop areas from a PivotChart to give the chart a cleaner look, click the ____________________ button on the Design tab.

Accepted Answer

The answer of To remove drop areas from a PivotChart...

Question 4

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.

Accepted Answer

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

Question 5

The accompanying figure displays the Report Options group with six option buttons. To instruct Access to perform different actions based on which option button is selected, the macro for the option group will contain a(n) ____________________ statement.

Accepted Answer

The answer of   
 The accompanying figure displays...

Question 6

The various steps in a macro are called ____________________.

Accepted Answer

The answer of The various steps in a macro are...

Question 7

Data macros are similar to SQL triggers.

Accepted Answer

A) True 
 B)False

Question 8

Macros created for an option group are data macros.

Accepted Answer

A) True 
 B)False

Question 9

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

Accepted Answer

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

Question 10

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

Accepted Answer

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

Question 11

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

Accepted Answer

A) True 
 B)False

Question 12

Critical Thinking Questions Case 9-2 An employee at Camashaly Design has created an initial PivotTable for the Camashaly Design database but is having trouble determining how to perform some of the tasks associated with creating a PivotTable. The PivotTable Field List currently does not display. The employee needs to add a filter to the PivotTable. How can he display the PivotTable Field List?

Accepted Answer

Click the

Question 13

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

Accepted Answer

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

Question 14

Match between columns
                        Premises: Data from fields in this area will appear as data series.

Accepted Answer

The Answer of navigation form and Series and Column and is...

Question 15

Many actions require additional information called arguments.

Accepted Answer

A) True 
 B)False

Question 16

The _____ lists macro actions organized by type.

Accepted Answer

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

Question 17

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

Accepted Answer

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

Question 18

Critical Thinking Questions Case 9-1 
   
 An employee at Camashaly Design needs to modify the macro shown in the accompanying figure. How can the employee collapse the OpenForm action?

Accepted Answer

Click the

Question 19

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.

Accepted Answer

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

Question 20

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

Accepted Answer

A) True 
 B)False

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

To remove drop areas from a PivotChart to give the chart a cleaner look, click the ____________________ button on the Design tab.

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.

The accompanying figure displays the Report Options group with six option buttons. To instruct Access to perform different actions based on which option button is selected, the macro for the option group will contain a(n) ____________________ statement.

The various steps in a macro are called ____________________.

Data macros are similar to SQL triggers.

Macros created for an option group are data macros.

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

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

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

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

Many actions require additional information called arguments.

The _____ lists macro actions organized by type.

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

Critical Thinking Questions Case 9-1 An employee at Camashaly Design needs to modify the macro shown in the accompanying figure. How can the employee collapse the OpenForm action?

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.

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

Office 2010 and Windows 7 Essential Concepts and Skills

Databases and Database Objects: an Introduction

Querying a Database

Maintaining a Database

Creating Reports and Forms

Multitable Forms

Advanced Report Techniques

Using SQL

Advanced Form Techniques

Administering a Database Syste

Database Design

Filters

Exam 10: Macros, Navigation Forms, Pivot

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

To remove drop areas from a PivotChart to give the chart a cleaner look, click the ____________________ button on the Design tab.

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.

The accompanying figure displays the Report Options group with six option buttons. To instruct Access to perform different actions based on which option button is selected, the macro for the option group will contain a(n) ____________________ statement.

The various steps in a macro are called ____________________.

Data macros are similar to SQL triggers.

Macros created for an option group are data macros.

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

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

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

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

Many actions require additional information called arguments.

The _____ lists macro actions organized by type.

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

Critical Thinking Questions Case 9-1 An employee at Camashaly Design needs to modify the macro shown in the accompanying figure. How can the employee collapse the OpenForm action?

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.

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

Office 2010 and Windows 7 Essential Concepts and Skills

Databases and Database Objects: an Introduction

Querying a Database

Maintaining a Database

Creating Reports and Forms

Multitable Forms

Advanced Report Techniques

Using SQL

Advanced Form Techniques

Administering a Database Syste

Database Design

Filters