Question 1

The accompanying figure displays a navigation form for the Camashaly Design database. What type of database objects can be included on the tabs of a navigation form?

Accepted Answer

You only can include forms and reports on the tabs.

Question 2

A(n) ____________________ macro is a macro that is attached to an object such as a command button, an option group, or a control on a form.

Accepted Answer

user interface

Question 3

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

Accepted Answer

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

Question 4

Match between columns
                        Premises: Data from fields in this area will appear as rows in the PivotTable.

Accepted Answer

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

Question 5

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

Accepted Answer

A) True 
 B)False

Question 6

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

Accepted Answer

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

Question 7

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

Accepted Answer

The answer of If a field list appears when you...

Question 8

Match between columns
                        Premises: Data from fields in this area will be summarized within the chart.

Accepted Answer

The Answer of pop-up form and Filter and Data and is...

Question 9

To add a command button to a form, click the ____________________ tool in the Controls group on the Design tab.

Accepted Answer

The answer of To add a command button to a...

Question 10

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

Accepted Answer

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

Question 11

There is only one chart type available for PivotCharts.

Accepted Answer

A) True 
 B)False

Question 12

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

Accepted Answer

The answer of ____________________ are collections of actions designed to...

Question 13

To make a correction to a macro that contains an error, click the ____________________ button in the Macro Single Step dialog box and then modify the design of the macro.

Accepted Answer

The answer of To make a correction to a macro...

Question 14

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 employee needs to change a caption for one of the column headings on the PivotTable. How should he accomplish this task?

Accepted Answer

The answer of Critical Thinking Questions Case 9-2 An employee...

Question 15

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

Accepted Answer

A) True 
 B)False

Question 16

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

Accepted Answer

A) True 
 B)False

Question 17

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

Accepted Answer

A) True 
 B)False

Question 18

Match between columns
                        Premises: Data from fields in this area will not appear in the PivotTable but can be used to restrict the data that appears.

Accepted Answer

The Answer of Category and Series and Column and variable is...

Question 19

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

Accepted Answer

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

Question 20

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

Accepted Answer

A) True 
 B)False

Exam 10: Macros, Navigation Forms, Pivot

The accompanying figure displays a navigation form for the Camashaly Design database. What type of database objects can be included on the tabs of a navigation form?

A(n) ____________________ macro is a macro that is attached to an object such as a command button, an option group, or a control on a form.

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

Identify the letter of the choice that best matches the phrase or definition.

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

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

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

Identify the letter of the choice that best matches the phrase or definition.

To add a command button to a form, click the ____________________ tool in the Controls group on the Design tab.

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

There is only one chart type available for PivotCharts.

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

To make a correction to a macro that contains an error, click the ____________________ button in the Macro Single Step dialog box and then modify the design of the macro.

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

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

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

Identify the letter of the choice that best matches the phrase or definition.

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

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