Question 1

Match the report problems with the probable solution.
-An expression wasn't entered correctly in a text box in Design View

Accepted Answer

A) The report contains no title or page numbers 
B) An #Error message appears where a calculation should appear in Print Preview 
C) Numbers do not appear with $ 
D) Names appear in two columns with big gaps of white space between the first and last names 
A) The report contains no title or page numbers 
B) An #Error message appears where a calculation should appear in Print Preview 
C) Numbers do not appear with $ 
D) Names appear in two columns with big gaps of white space between the first and last names

Question 2

-The chart shown in the figure above is being edited.

Accepted Answer

A) True 
 B)False

Question 3

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 4

Match each kind of chart with the best example.
-Each section represents monthly sales by representative, stacked to show cumulative total sales.

Accepted Answer

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

Question 5

A date formatted as 19-Apr-16 has a Short Date format. _________________________

Accepted Answer

A) True 
 B)False

Question 6

Match each kind of chart with the best example.
-Each wedge represents total quarterly sales for a company.

Accepted Answer

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

Question 7

-In the figure above, item 3 refers to the datasheet.

Accepted Answer

A) True 
 B)False

Question 8

Match each kind of chart with the best example.
-Each point represents monthly sales over 12 months.

Accepted Answer

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

Question 9

Each type of control on a report has formatting properties.

Accepted Answer

A) True 
 B)False

Question 10

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 11

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 12

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

Accepted Answer

A) True 
 B)False

Question 13

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 14

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 15

The ____ layout positions labels across the top in the Page Header section forming columns of data with text boxes positioned in the Detail section.

Accepted Answer

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

Question 16

Which of the following is NOT a common Access chart type?

Accepted Answer

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

Question 17

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 18

-In the figure above, which chart would you most likely use to show trends over time?

Accepted Answer

A)  Surface 
B)  Pie 
C)  Radar 
D)  Line 
A)  Surface 
B)  Pie 
C)  Radar 
D)  Line

Question 19

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

Accepted Answer

A) True 
 B)False

Question 20

If a chart only has one set of values that represent 100% of something, it is a good candidate for a pie chart.

Accepted Answer

A) True 
 B)False

Match the report problems with the probable solution. -An expression wasn't entered correctly in a text box in Design View

-The chart shown in the figure above is being edited.

What is the third optional argument for a domain function?

Match each kind of chart with the best example. -Each section represents monthly sales by representative, stacked to show cumulative total sales.

A date formatted as 19-Apr-16 has a Short Date format. _________________________

Match each kind of chart with the best example. -Each wedge represents total quarterly sales for a company.

-In the figure above, item 3 refers to the datasheet.

Match each kind of chart with the best example. -Each point represents monthly sales over 12 months.

Each type of control on a report has formatting properties.

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

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 Remove Layout button is provided for a report only in Report Design View. _________________________

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

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.

The ____ layout positions labels across the top in the Page Header section forming columns of data with text boxes positioned in the Detail section.

Which of the following is NOT a common Access chart type?

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

-In the figure above, which chart would you most likely use to show trends over time?

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

If a chart only has one set of values that represent 100% of something, it is a good candidate for a pie chart.

Getting Started With Microsoft Office 2013

Getting Started With Chapter 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 Modules and Vba

Administering the Database

Chapter Access and the Web

Filters

Exam 13: Creating Advanced Reports

Match the report problems with the probable solution. -An expression wasn't entered correctly in a text box in Design View

-The chart shown in the figure above is being edited.

What is the third optional argument for a domain function?

Match each kind of chart with the best example. -Each section represents monthly sales by representative, stacked to show cumulative total sales.

A date formatted as 19-Apr-16 has a Short Date format. _________________________

Match each kind of chart with the best example. -Each wedge represents total quarterly sales for a company.

-In the figure above, item 3 refers to the datasheet.

Match each kind of chart with the best example. -Each point represents monthly sales over 12 months.

Each type of control on a report has formatting properties.

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

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 Remove Layout button is provided for a report only in Report Design View. _________________________

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

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.

The ____ layout positions labels across the top in the Page Header section forming columns of data with text boxes positioned in the Detail section.

Which of the following is NOT a common Access chart type?

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

-In the figure above, which chart would you most likely use to show trends over time?

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

If a chart only has one set of values that represent 100% of something, it is a good candidate for a pie chart.

Getting Started With Microsoft Office 2013

Getting Started With Chapter 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 Modules and Vba

Administering the Database

Chapter Access and the Web

Filters