Question 1

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

Accepted Answer

A) True 
 B)False

Question 2

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

Accepted Answer

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

Question 3

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.

Accepted Answer

A) True 
 B)False

Question 4

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

Accepted Answer

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

Question 5

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

Accepted Answer

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

Question 6

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

Accepted Answer

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

Question 7

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

Accepted Answer

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

Question 8

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

Accepted Answer

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

Question 9

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

Accepted Answer

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

Question 10

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

Accepted Answer

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

Question 11

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.

Accepted Answer

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

Question 12

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

Accepted Answer

A) True 
 B)False

Question 13

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

Accepted Answer

A) True 
 B)False

Question 14

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

Accepted Answer

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

Question 15

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 _____.

Accepted Answer

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

Question 16

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

Accepted Answer

A) True 
 B)False

Question 17

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

Accepted Answer

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

Question 18

The accompanying figure displays the Report Options group with six option buttons. To attach a macro to the option group, you first must display a property sheet for the group and click the ____________________ property for the option group.

Accepted Answer

The answer of   
 The accompanying figure displays...

Question 19

PivotTables and PivotCharts must be based on queries.

Accepted Answer

A) True 
 B)False

Question 20

The white space in a chart is called the ____________________.

Accepted Answer

The answer of The white space in a chart is...

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

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

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.

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

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

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

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

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

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

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.

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

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

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

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 PivotTable differs from a crosstab because a PivotTable is dynamic.

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

The accompanying figure displays the Report Options group with six option buttons. To attach a macro to the option group, you first must display a property sheet for the group and click the ____________________ property for the option group.

PivotTables and PivotCharts must be based on queries.

The white space in a chart is called the ____________________.

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

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

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

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.

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

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

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

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

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

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

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.

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

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

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

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 PivotTable differs from a crosstab because a PivotTable is dynamic.

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

The accompanying figure displays the Report Options group with six option buttons. To attach a macro to the option group, you first must display a property sheet for the group and click the ____________________ property for the option group.

PivotTables and PivotCharts must be based on queries.

The white space in a chart is called the ____________________.

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