Question 1

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 2

Match between columns
                        Premises: Each bar represents annual sales for a different product over 12 months.
Each section represents monthly sales by representative, stacked to show cumulative total sales.
Each wedge represents total quarterly sales for a company.
Each point represents monthly sales over 12 months.

Accepted Answer

The Answer of Line and Bar and Pie and Area is...

Question 3

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 4

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

Question 5

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 6

The domain in a domain aggregate function is the ____ that contains the field used in the calculation.

Accepted Answer

A)  table or query 
B)  form or report 
C)  text box or label 
D)  property or control 
A)  table or query 
B)  form or report 
C)  text box or label 
D)  property or control

Question 7

The chart type that shows trends over time by connecting points is a(n) ____________________ Chart.

Accepted Answer

The answer of The chart type that shows trends over...

Question 8

You can view margins on a report in Print Preview.

Accepted Answer

A) True 
 B)False

Question 9

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 10

Explain the purpose of grouping controls together in a report table layout.

Accepted Answer

You group controls together in

Question 11

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

Accepted Answer

A) True 
 B)False

Question 12

Numbers on a report can be displayed in Currency, Percent, or Standard formats.

Accepted Answer

A) True 
 B)False

Question 13

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 14

The chart type that shows comparisons of values in horizontal bars is a(n) ____ chart.

Accepted Answer

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

Question 15

What are the two required arguments for a domain function?

Accepted Answer

A)  Criteria and calculation 
B)  Criteria and domain name 
C)  Field used in the calculation and domain name 
D)  Field used in the calculation and criteria 
A)  Criteria and calculation 
B)  Criteria and domain name 
C)  Field used in the calculation and domain name 
D)  Field used in the calculation and criteria

Question 16

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 17

Sara works at the local animal shelter. Her boss wants her to use the shelter's database of animals to graph the number of dogs adopted per month for the past 12 months and emphasize whether the trend is increasing or decreasing. What kind of graph would be the best choice? Why?

Accepted Answer

A line gra

Question 18

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

Question 19

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 20

The first step in creating a chart is to ____.

Accepted Answer

A)  select the data that the chart will graph 
B)  format the chart 
C)  resize the chart to fit the page 
D)  test different 3D chart options 
A)  select the data that the chart will graph 
B)  format the chart 
C)  resize the chart to fit the page 
D)  test different 3D chart options

Which chart would you most likely use to show trends over time?

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

The ____ layout is most often used in forms.

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

The domain in a domain aggregate function is the ____ that contains the field used in the calculation.

The chart type that shows trends over time by connecting points is a(n) ____________________ Chart.

You can view margins on a report in Print Preview.

What is the second argument in the DLookup function?

Explain the purpose of grouping controls together in a report table layout.

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

Numbers on a report can be displayed in Currency, Percent, or Standard formats.

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

The chart type that shows comparisons of values in horizontal bars is a(n) ____ chart.

What are the two required arguments for a domain function?

Which chart would you most likely use to show comparisons of values, such as annual sales for a different product for several sales representatives?

Sara works at the local animal shelter. Her boss wants her to use the shelter's database of animals to graph the number of dogs adopted per month for the past 12 months and emphasize whether the trend is increasing or decreasing. What kind of graph would be the best choice? Why?

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

The first step in creating a chart is to ____.

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 would you most likely use to show trends over time?

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

The ____ layout is most often used in forms.

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

The domain in a domain aggregate function is the ____ that contains the field used in the calculation.

The chart type that shows trends over time by connecting points is a(n) ____________________ Chart.

You can view margins on a report in Print Preview.

What is the second argument in the DLookup function?

Explain the purpose of grouping controls together in a report table layout.

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

Numbers on a report can be displayed in Currency, Percent, or Standard formats.

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

The chart type that shows comparisons of values in horizontal bars is a(n) ____ chart.

What are the two required arguments for a domain function?

Which chart would you most likely use to show comparisons of values, such as annual sales for a different product for several sales representatives?

Sara works at the local animal shelter. Her boss wants her to use the shelter's database of animals to graph the number of dogs adopted per month for the past 12 months and emphasize whether the trend is increasing or decreasing. What kind of graph would be the best choice? Why?

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

The first step in creating a chart is to ____.

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