Question 1

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 2

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 3

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

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 5

Which chart type would be used to best compare the annual sales for a different products for a given year?

Accepted Answer

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

Question 6

-In the figure above, item 4 is the ____.

Accepted Answer

A)  Title 
B)  Legend 
C)  Chart Standard toolbar 
D)  Placeholder 
A)  Title 
B)  Legend 
C)  Chart Standard toolbar 
D)  Placeholder

Question 7

What is the first 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 8

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

Accepted Answer

A) True 
 B)False

Question 9

Match each kind of chart with the best example.
-Each bar represents annual sales for a different product over 12 months.

Accepted Answer

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

Question 10

____________________, also called graphs, are visual representations of numeric data that help users see comparisons, patterns, and trends in data.

Accepted Answer

The answer of ____________________, also called graphs, are visual representations...

Question 11

Suzy has created a report that tracks the animals going in and out of the animal shelter where she works. Each animal's ID number is shown in the AnimalID Footer section. She wants to print each animal's record as a separate document so it can be used in the animal's file. How would she do this?

Accepted Answer

In Design View, open the property sheet

Question 12

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

Accepted Answer

A) True 
 B)False

Question 13

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 14

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 15

Before using the Chart Wizard, it's a good idea to plan what specific fields you want the chart to display.

Accepted Answer

A) True 
 B)False

Question 16

The chart type that shows comparisons of values in vertical bars is a(n) ____________________ Chart.

Accepted Answer

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

Question 17

____________________ 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

Domain
Dom

Question 18

-In the figure above, which chart would you most likely use to show parts of a whole, such as the contribution of three sales divisions to the entire company's profits for the year?

Accepted Answer

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

Question 19

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 20

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

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

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

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

Which chart type would be used to best compare the annual sales for a different products for a given year?

-In the figure above, item 4 is the ____.

What is the first argument in the DLookup function?

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

Match each kind of chart with the best example. -Each bar represents annual sales for a different product over 12 months.

____________________, also called graphs, are visual representations of numeric data that help users see comparisons, patterns, and trends in data.

Suzy has created a report that tracks the animals going in and out of the animal shelter where she works. Each animal's ID number is shown in the AnimalID Footer section. She wants to print each animal's record as a separate document so it can be used in the animal's file. How would she do this?

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

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

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

Before using the Chart Wizard, it's a good idea to plan what specific fields you want the chart to display.

The chart type that shows comparisons of values in vertical bars is a(n) ____________________ Chart.

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

-In the figure above, which chart would you most likely use to show parts of a whole, such as the contribution of three sales divisions to the entire company's profits for the year?

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

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

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

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

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

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

Which chart type would be used to best compare the annual sales for a different products for a given year?

-In the figure above, item 4 is the ____.

What is the first argument in the DLookup function?

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

Match each kind of chart with the best example. -Each bar represents annual sales for a different product over 12 months.

____________________, also called graphs, are visual representations of numeric data that help users see comparisons, patterns, and trends in data.

Suzy has created a report that tracks the animals going in and out of the animal shelter where she works. Each animal's ID number is shown in the AnimalID Footer section. She wants to print each animal's record as a separate document so it can be used in the animal's file. How would she do this?

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

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

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

Before using the Chart Wizard, it's a good idea to plan what specific fields you want the chart to display.

The chart type that shows comparisons of values in vertical bars is a(n) ____________________ Chart.

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

-In the figure above, which chart would you most likely use to show parts of a whole, such as the contribution of three sales divisions to the entire company's profits for the year?

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

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

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