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?

Free

(Essay)

4.8/5

(75)

Question 1

Correct Answer:

Verified

You only can include forms and reports on the tabs.

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.

Free

(Short Answer)

4.9/5

(68)

Question 2

Correct Answer:

Verified

user interface

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

Free

(Multiple Choice)

4.8/5

(73)

Question 3

Correct Answer:

Verified

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

Premises:

Data from fields in this area will appear as rows in the PivotTable.

Responses:

navigation form

Series

Filter

Correct Answer:

Verified

Data from fields in this area will appear as rows in the PivotTable.

(Matching)

5.0/5

(83)

Question 4

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

(True/False)

4.9/5

(85)

Question 5

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

(Multiple Choice)

4.9/5

(87)

Question 6

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

(Short Answer)

4.8/5

(88)

Question 7

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

Premises:

Data from fields in this area will be summarized within the chart.

Responses:

pop-up form

Filter

Data

Correct Answer:

Verified

Data from fields in this area will be summarized within the chart.

(Matching)

4.9/5

(95)

Question 8

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

(Short Answer)

4.9/5

(80)

Question 9

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

(Multiple Choice)

5.0/5

(79)

Question 10

There is only one chart type available for PivotCharts.

(True/False)

4.9/5

(85)

Question 11

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

(Short Answer)

4.9/5

(82)

Question 12

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.

(Short Answer)

4.9/5

(89)

Question 13

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?

(Essay)

4.7/5

(87)

Question 14

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

(True/False)

4.9/5

(80)

Question 15

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

(True/False)

4.9/5

(81)

Question 16

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

(True/False)

4.9/5

(79)

Question 17

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

Premises:

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

Responses:

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

(Multiple Choice)

5.0/5

(81)

Question 19

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

(True/False)

4.9/5

(78)

Question 20

Showing 1 - 20 of 112

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.

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.

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.

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.

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