Question 1

The x-axis is also called the ____ axis.

Accepted Answer

A)  y- 
B)  vertical 
C)  horizontal 
D)  legend 
A)  y- 
B)  vertical 
C)  horizontal 
D)  legend

Question 2

The text in a form or report tab is determined by the form or report's Title property. _________________________

Accepted Answer

A) True 
 B)False

Question 3

The chart in the figure above is an example of a 3-D chart.

Accepted Answer

A) True 
 B)False

Question 4

The chart in the figure above is a(n) ____ chart.

Accepted Answer

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

Question 5

To change the color of the bars on a chart you must work in Report View. _________________________

Accepted Answer

A) True 
 B)False

Question 6

Charts can be added to forms or queries . _________________________

Accepted Answer

A) True 
 B)False

Question 7

Ben works at the local animal shelter. His boss wants him to use the shelter's database of animals to graph the monthly adoptions of cats vs. dogs for the past 12 months. What kind of graph would be the best choice? Why?

Accepted Answer

Column graph/chart

Question 8

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 9

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 10

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

Accepted Answer

A) True 
 B)False

Question 11

In a report, the Narrow margin option sets all four margins to 0.25". _________________________

Accepted Answer

A) True 
 B)False

Question 12

In the figure above, which chart would you most likely use to show comparisons of values, such as annual sales for a different product for several sales representatives?

Accepted Answer

A)  Column 
B)  Pie 
C)  Doughnut 
D)  Scatter 
A)  Column 
B)  Pie 
C)  Doughnut 
D)  Scatter

Question 13

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 14

The chart in the figure above is an example of a bar chart.

Accepted Answer

A) True 
 B)False

Question 15

Which chart type would use horizontal 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 16

Access provides a(n) ____________________ Wizard that steps you through the process of creating charts within forms and reports.

Accepted Answer

The answer of Access provides a(n) ____________________ Wizard that steps...

Question 17

In the figure above, which property is being modified?

Accepted Answer

A)  Force New Page 
B)  New Row or Col 
C)  Department Header 
D)  DeptSummary 
A)  Force New Page 
B)  New Row or Col 
C)  Department Header 
D)  DeptSummary

Question 18

Which of the following is NOT a formatting property available for many report controls?

Accepted Answer

A)  Text Align 
B)  Width 
C)  Format 
D)  Data Type 
A)  Text Align 
B)  Width 
C)  Format 
D)  Data Type

Question 19

Which chart type would best show cumulative sales by several representatives over time?

Accepted Answer

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

Question 20

Match between columns
                        Premises: Each wedge represents total quarterly sales for a company.
Switch to Report Design View to open more report sections and add controls.
An expression wasn't entered correctly in a text box in Design View
Each section represents monthly sales by representative, stacked to show cumulative total sales.
Numbers should be formatted with a Currency format.
Create an expression in a text box to combine the first and last names, needs to be entered in one text box.
Each point represents monthly sales over 12 months.
Each bar represents annual sales for a different product over 12 months.

Accepted Answer

The Answer of Bar and The report contains no title is...

The x-axis is also called the ____ axis.

The text in a form or report tab is determined by the form or report's Title property. _________________________

The chart in the figure above is an example of a 3-D chart.

The chart in the figure above is a(n) ____ chart.

To change the color of the bars on a chart you must work in Report View. _________________________

Charts can be added to forms or queries . _________________________

Ben works at the local animal shelter. His boss wants him to use the shelter's database of animals to graph the monthly adoptions of cats vs. dogs for the past 12 months. What kind of graph would be the best choice? Why?

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

What is the third optional argument for a domain function?

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

In a report, the Narrow margin option sets all four margins to 0.25". _________________________

In the figure above, which chart would you most likely use to show comparisons of values, such as annual sales for a different product for several sales representatives?

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

The chart in the figure above is an example of a bar chart.

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

Access provides a(n) ____________________ Wizard that steps you through the process of creating charts within forms and reports.

In the figure above, which property is being modified?

Which of the following is NOT a formatting property available for many report controls?

Which chart type would best show cumulative sales by several representatives over time?

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

The x-axis is also called the ____ axis.

The text in a form or report tab is determined by the form or report's Title property. _________________________

The chart in the figure above is an example of a 3-D chart.

The chart in the figure above is a(n) ____ chart.

To change the color of the bars on a chart you must work in Report View. _________________________

Charts can be added to forms or queries . _________________________

Ben works at the local animal shelter. His boss wants him to use the shelter's database of animals to graph the monthly adoptions of cats vs. dogs for the past 12 months. What kind of graph would be the best choice? Why?

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

What is the third optional argument for a domain function?

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

In a report, the Narrow margin option sets all four margins to 0.25". _________________________

In the figure above, which chart would you most likely use to show comparisons of values, such as annual sales for a different product for several sales representatives?

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

The chart in the figure above is an example of a bar chart.

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

Access provides a(n) ____________________ Wizard that steps you through the process of creating charts within forms and reports.

In the figure above, which property is being modified?

Which of the following is NOT a formatting property available for many report controls?

Which chart type would best show cumulative sales by several representatives over time?

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