Match between columns Premises: Named location in computer memory.

The Answer of Series and Row and pop-up form and is...

Match between columns Premises: Form that stays on top of other open objects.

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

Exam 10: Macros, Navigation Forms, Pivot

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.

(Multiple Choice)

5.0/5

(68)

Question 81

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

(Multiple Choice)

4.8/5

(75)

Question 82

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

Premises:

Named location in computer memory.

Responses:

Series

Row

pop-up form

Correct Answer:

Verified

Named location in computer memory.

(Matching)

4.7/5

(86)

Question 83

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

(Multiple Choice)

4.8/5

(90)

Question 84

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

Premises:

Data from fields in this area will appear as related groups of data.

Responses:

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

(True/False)

4.8/5

(96)

Question 86

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

(Multiple Choice)

4.9/5

(69)

Question 87

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

(True/False)

4.9/5

(92)

Question 88

Critical Thinking Questions Case 9-1 An employee at Camashaly Design needs to modify the macro shown in the accompanying figure. The employee is nervous about the change she just made to the macro and would like to test it. What can she do to be certain the macro will perform as she expects?

(Essay)

4.8/5

(72)

Question 89

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

(True/False)

4.9/5

(81)

Question 90

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

(Multiple Choice)

4.8/5

(78)

Question 91

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

(Multiple Choice)

4.8/5

(81)

Question 92

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

Premises:

Form that stays on top of other open objects.

Responses:

Series

Row

navigation form

Correct Answer:

Verified

Form that stays on top of other open objects.

(Matching)

4.7/5

(75)

Question 93

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.

(Multiple Choice)

4.9/5

(79)

Question 94

Modified Multiple Choice You can view data in _____.

(Multiple Choice)

4.9/5

(77)

Question 95

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

(Multiple Choice)

4.7/5

(81)

Question 96

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

(Multiple Choice)

4.8/5

(87)

Question 97

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

(Multiple Choice)

5.0/5

(79)

Question 98

To save the changes to a PivotTable, click the ____________________ button on the Quick Access toolbar.

(Short Answer)

4.7/5

(78)

Question 99

PivotTables and PivotCharts are normally associated with _____.

(Multiple Choice)

4.9/5

(81)

Question 100

Showing 81 - 100 of 112

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.

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

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

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

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

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

Critical Thinking Questions Case 9-1 An employee at Camashaly Design needs to modify the macro shown in the accompanying figure. The employee is nervous about the change she just made to the macro and would like to test it. What can she do to be certain the macro will perform as she expects?

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

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

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

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.

Modified Multiple Choice You can view data in _____.

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

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

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

To save the changes to a PivotTable, click the ____________________ button on the Quick Access toolbar.

PivotTables and PivotCharts are normally associated with _____.

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