Question 1

Explain how the Page N of M option in the Page Numbers dialog box will present in the first three pages of a ten page report.

Accepted Answer

The Page N of M option means t

Question 2

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 3

Which chart type would use vertical bars to show annual sales for different sales representatives?

Accepted Answer

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

Question 4

A(n) ____________________ report repeats information in more than one column on the page.

Accepted Answer

The answer of A(n) ____________________ report repeats information in more...

Question 5

____________________ functions are used in an expression to calculate a value based on a field that is not included in the Record Source property for the form or report.

Accepted Answer

The answer of ____________________ functions are used in an expression...

Question 6

The chart type that shows parts of a whole with slices is a(n) ____________________ Chart.

Accepted Answer

The answer of The chart type that shows parts of...

Question 7

Jennifer works at the local animal shelter.  Her boss wants her to use the shelter's database of animals to categorize the total number of cats, dogs, and other types of animals brought into the shelter this year. Her boss wants these categories: cats, dogs, and other. What kind of graph would be the best choice? Why?

Accepted Answer

A pie chart/graph, because it

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

Which chart type would best illustrate the contribution of three products to total company sales for a given year?

Accepted Answer

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

Question 10

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 11

The Remove Layout button is provided for a report only in Report Design View. _________________________

Accepted Answer

A) True 
 B)False

Question 12

Each type of control on a report has formatting properties.

Accepted Answer

A) True 
 B)False

Question 13

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

Accepted Answer

A) True 
 B)False

Question 14

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 15

What is the second 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 16

This chart area determines the legend on the chart.

Accepted Answer

A)  X-Axis 
B)  Series 
C)  Datasheet 
D)  Y-Axis 
A)  X-Axis 
B)  Series 
C)  Datasheet 
D)  Y-Axis

Question 17

You can view margins on a report in Print Preview.

Accepted Answer

A) True 
 B)False

Question 18

In the figure above, item 4 refers to the legend.

Accepted Answer

A) True 
 B)False

Question 19

Aaron has created a report that tracks the animals going in and out of the animal shelter where he works.  Each animal's record has been set up to print on a separate page.  He wants to print the records for just the first 10 animals in the report. How would he do this?

Accepted Answer

In the Print dialog box, enter

Question 20

The ____ layout is most often used in forms.

Accepted Answer

A)  Formula 
B)  Stacked 
C)  Tabular 
D)  Datasheet 
A)  Formula 
B)  Stacked 
C)  Tabular 
D)  Datasheet

Explain how the Page N of M option in the Page Numbers dialog box will present in the first three pages of a ten page report.

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

Which chart type would use vertical bars to show annual sales for different sales representatives?

A(n) ____________________ report repeats information in more than one column on the page.

____________________ functions are used in an expression to calculate a value based on a field that is not included in the Record Source property for the form or report.

The chart type that shows parts of a whole with slices is a(n) ____________________ Chart.

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

Which chart type would best illustrate the contribution of three products to total company sales for a given year?

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

The Remove Layout button is provided for a report only in Report Design View. _________________________

Each type of control on a report has formatting properties.

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 second argument in the DLookup function?

This chart area determines the legend on the chart.

You can view margins on a report in Print Preview.

In the figure above, item 4 refers to the legend.

Aaron has created a report that tracks the animals going in and out of the animal shelter where he works. Each animal's record has been set up to print on a separate page. He wants to print the records for just the first 10 animals in the report. How would he do this?

The ____ layout is most often used in forms.

Getting Started With Access 2013

Building and Using Queries

Using Forms

Using Reports

Modifying the Database Structure

Improving Queries

Enhancing Forms

Analyzing Data With Reports

Importing and Exporting Data

Analyzing Database Design Using Northwind

Creating Advanced Queries

Creating Macros

Creating Macros

Administering the Database

Access and the Web

Getting Started With Microsoft Office 2013

Filters

Exam 12: Creating Advanced Reports

Explain how the Page N of M option in the Page Numbers dialog box will present in the first three pages of a ten page report.

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

Which chart type would use vertical bars to show annual sales for different sales representatives?

A(n) ____________________ report repeats information in more than one column on the page.

____________________ functions are used in an expression to calculate a value based on a field that is not included in the Record Source property for the form or report.

The chart type that shows parts of a whole with slices is a(n) ____________________ Chart.

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

Which chart type would best illustrate the contribution of three products to total company sales for a given year?

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

The Remove Layout button is provided for a report only in Report Design View. _________________________

Each type of control on a report has formatting properties.

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 second argument in the DLookup function?

This chart area determines the legend on the chart.

You can view margins on a report in Print Preview.

In the figure above, item 4 refers to the legend.

Aaron has created a report that tracks the animals going in and out of the animal shelter where he works. Each animal's record has been set up to print on a separate page. He wants to print the records for just the first 10 animals in the report. How would he do this?

The ____ layout is most often used in forms.

Getting Started With Access 2013

Building and Using Queries

Using Forms

Using Reports

Modifying the Database Structure

Improving Queries

Enhancing Forms

Analyzing Data With Reports

Importing and Exporting Data

Analyzing Database Design Using Northwind

Creating Advanced Queries

Creating Macros

Creating Macros

Administering the Database

Access and the Web

Getting Started With Microsoft Office 2013

Filters