Question 1

This chart area determines the x-axis on the chart.

Accepted Answer

A)  Axis 
B)  Series 
C)  Legend 
D)  Data 
A)  Axis 
B)  Series 
C)  Legend 
D)  Data

Question 2

The Stacked layout positions labels to the left of their respective text boxes.

Accepted Answer

A) True 
 B)False

Question 3

This property makes sure that controls in the page section repeat at the top of every page.

Accepted Answer

A)  Force New Page 
B)  Repeat Section 
C)  Force Every Page 
D)  Repeat Every Page 
A)  Force New Page 
B)  Repeat Section 
C)  Force Every Page 
D)  Repeat Every Page

Question 4

What is the first argument in the DLookup function?

Accepted Answer

A)  the domain 
B)  the criteria 
C)  true or false 
D)  the field that is used for the calculation 
A)  the domain 
B)  the criteria 
C)  true or false 
D)  the field that is used for the calculation

Question 5

What is the third optional argument for a domain function?

Accepted Answer

A)  Criteria to select given records in the calculation 
B)  Domain name 
C)  Field used in the calculation 
D)  Standard disclaimer 
A)  Criteria to select given records in the calculation 
B)  Domain name 
C)  Field used in the calculation 
D)  Standard disclaimer

Question 6

Which chart would you most likely use to show parts of a whole, such as the contribution of three sales divisions to the entire company's profits for the year?

Accepted Answer

A)  Column 
B)  Line 
C)  Pie 
D)  Area 
A)  Column 
B)  Line 
C)  Pie 
D)  Area

Question 7

This chart area determines what field the bars on the chart represent.

Accepted Answer

A)  Axis 
B)  Series 
C)  Legend 
D)  Data 
A)  Axis 
B)  Series 
C)  Legend 
D)  Data

Question 8

Which chart type would best show sales trends by connecting several points over time?

Accepted Answer

A)  Column 
B)  Bar 
C)  Line 
D)  Area 
A)  Column 
B)  Bar 
C)  Line 
D)  Area

Question 9

You can open and close the Group Header and Group Footer sections in the Group, Sort, and Total pane. _________________________

Accepted Answer

A) True 
 B)False

This chart area determines the x-axis on the chart.

The Stacked layout positions labels to the left of their respective text boxes.

This property makes sure that controls in the page section repeat at the top of every page.

What is the first argument in the DLookup function?

What is the third optional argument for a domain function?

Which chart would you most likely use to show parts of a whole, such as the contribution of three sales divisions to the entire company's profits for the year?

This chart area determines what field the bars on the chart represent.

Which chart type would best show sales trends by connecting several points over time?

You can open and close the Group Header and Group Footer sections in the Group, Sort, and Total pane. _________________________

Getting Started With Access

Building and Using Queries

Using Forms

Using Reports

Modifying the Database Structure

Improving Queries

Enhancing Forms

Analyizng Data With Reports

Importing and Exporting Data

Creating Advanced Queries

Creating Macros

Creating Modules and Vba

Administering the Database

Using Acess and the Web

Completing a Database Application

Filters

Exam 11: Creating Advanced Reports

This chart area determines the x-axis on the chart.

The Stacked layout positions labels to the left of their respective text boxes.

This property makes sure that controls in the page section repeat at the top of every page.

What is the first argument in the DLookup function?

What is the third optional argument for a domain function?

Which chart would you most likely use to show parts of a whole, such as the contribution of three sales divisions to the entire company's profits for the year?

This chart area determines what field the bars on the chart represent.

Which chart type would best show sales trends by connecting several points over time?

You can open and close the Group Header and Group Footer sections in the Group, Sort, and Total pane. _________________________

Getting Started With Access

Building and Using Queries

Using Forms

Using Reports

Modifying the Database Structure

Improving Queries

Enhancing Forms

Analyizng Data With Reports

Importing and Exporting Data

Creating Advanced Queries

Creating Macros

Creating Modules and Vba

Administering the Database

Using Acess and the Web

Completing a Database Application

Filters