Question 1

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 2

Identify four common chart types and what they are most commonly used for.

Accepted Answer

1.  Column - comparisons of va

Question 3

A hashed border of a chart placeholder control indicates that the chart is displaying the most current data.

Accepted Answer

A) True 
 B)False

Question 4

The chart type that shows cumulative totals using stacked sections is a(n) ____________________ Chart.

Accepted Answer

The answer of The chart type that shows cumulative totals...

Question 5

Where do you specify the number of columns for a report?

Accepted Answer

A)  Print Preview toolbar 
B)  Page Setup dialog box 
C)  Form Design property sheet 
D)  Tab Set properties 
A)  Print Preview toolbar 
B)  Page Setup dialog box 
C)  Form Design property sheet 
D)  Tab Set properties

Question 6

Which function would help you return a value from a specified table or query?

Accepted Answer

A)  Seek 
B)  Disclaimer 
C)  DLookup 
D)  Domain 
A)  Seek 
B)  Disclaimer 
C)  DLookup 
D)  Domain

Question 7

To format a number with a $ such as $50.99, use the Standard format. _________________________

Accepted Answer

A) True 
 B)False

Question 8

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 9

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 10

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 11

Three-dimensional charts are always more effective than two-dimensional charts.

Accepted Answer

A) True 
 B)False

Question 12

Match between columns
                        Premises: Switch to Report Design View to open more report sections and add controls.
Numbers should be formatted with a Currency format.
An expression wasn't entered correctly in a text box in Design View
Create an expression in a text box to combine the first and last names, needs to be entered in one text box.

Accepted Answer

The Answer of Names appear in two columns with big is...

Question 13

When charts are displayed in Layout View, you will see which of the following?

Accepted Answer

A)  Actual data 
B)  A chart placeholder 
C)  A pie chart 
D)  A data table 
A)  Actual data 
B)  A chart placeholder 
C)  A pie chart 
D)  A data table

Question 14

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

All charts are modified in the ____________________ View of the form or report where the chart exists.

Accepted Answer

The answer of All charts are modified in the ____________________...

Question 17

A date formatted as 19-Jun-17 has a Short Date format. _________________________

Accepted Answer

A) True 
 B)False

Question 18

The Page Numbers button is found on the View  tab of the ribbon. _________________________

Accepted Answer

A) True 
 B)False

Question 19

Which chart would you most likely use to show cumulative totals in a stacked arrangement?

Accepted Answer

A)  Scatter 
B)  Area 
C)  Bubble 
D)  Stock 
A)  Scatter 
B)  Area 
C)  Bubble 
D)  Stock

Question 20

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

Accepted Answer

A) True 
 B)False

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

Identify four common chart types and what they are most commonly used for.

A hashed border of a chart placeholder control indicates that the chart is displaying the most current data.

The chart type that shows cumulative totals using stacked sections is a(n) ____________________ Chart.

Where do you specify the number of columns for a report?

Which function would help you return a value from a specified table or query?

To format a number with a $ such as $50.99, use the Standard format. _________________________

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?

This chart area determines the legend on the chart.

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

Three-dimensional charts are always more effective than two-dimensional charts.

When charts are displayed in Layout View, you will see which of the following?

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?

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

All charts are modified in the ____________________ View of the form or report where the chart exists.

A date formatted as 19-Jun-17 has a Short Date format. _________________________

The Page Numbers button is found on the View tab of the ribbon. _________________________

Which chart would you most likely use to show cumulative totals in a stacked arrangement?

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

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

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

Identify four common chart types and what they are most commonly used for.

A hashed border of a chart placeholder control indicates that the chart is displaying the most current data.

The chart type that shows cumulative totals using stacked sections is a(n) ____________________ Chart.

Where do you specify the number of columns for a report?

Which function would help you return a value from a specified table or query?

To format a number with a $ such as $50.99, use the Standard format. _________________________

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?

This chart area determines the legend on the chart.

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

Three-dimensional charts are always more effective than two-dimensional charts.

When charts are displayed in Layout View, you will see which of the following?

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?

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

All charts are modified in the ____________________ View of the form or report where the chart exists.

A date formatted as 19-Jun-17 has a Short Date format. _________________________

The Page Numbers button is found on the View tab of the ribbon. _________________________

Which chart would you most likely use to show cumulative totals in a stacked arrangement?

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

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