Question 1

You enter criteria in the Enter Parameter Value box for a parameter report. _________________________

Accepted Answer

A) True 
 B)False

Question 2

To create a parameter report, you base it on a parameter table. _________________________

Accepted Answer

A) True 
 B)False

Question 3

You use conditional formatting to highlight important data in a report.

Accepted Answer

A) True 
 B)False

Question 4

The report's ____ property determines what table or query provides the fields and records for a report.

Accepted Answer

A)  Parameter 
B)  Record Source 
C)  Conditional Formatting 
D)  Group and Sort 
A)  Parameter 
B)  Record Source 
C)  Conditional Formatting 
D)  Group and Sort

Question 5

Report ____________________ View allows you to work with a complete range of report, section, and control properties.

Accepted Answer

The answer of Report ____________________ View allows you to work...

Question 6

-In the accompanying figure, which section does not contain any controls?

Accepted Answer

A)  Report Header 
B)  Category Header 
C)  TourName Footer 
D)  Report Footer 
A)  Report Header 
B)  Category Header 
C)  TourName Footer 
D)  Report Footer

Question 7

A ____ prompts you for criteria to determine the records to use for the report.

Accepted Answer

A)  Subreport 
B)  Parameter report 
C)  Main report 
D)  Query 
A)  Subreport 
B)  Parameter report 
C)  Main report 
D)  Query

Question 8

Which report section would be the most logical choice to display the grouping field value?

Accepted Answer

A)  Report Header 
B)  Page Header 
C)  Detail Header 
D)  Group Header 
A)  Report Header 
B)  Page Header 
C)  Detail Header 
D)  Group Header

Question 9

-Doug builds the report shown in the accompanying figure. How did Doug group the records and why might he have the TourName Footer section open even though there are no controls in that section?

Accepted Answer

Doug grouped the records by To

Question 10

Compared to forms and datasheets, ____ give you more control over how data is printed and greater flexibility in presenting summary information.

Accepted Answer

A)  Macros 
B)  Modules 
C)  Queries 
D)  Reports 
A)  Macros 
B)  Modules 
C)  Queries 
D)  Reports

Question 11

-In the accompanying figure, item 2 helps you ____.

Accepted Answer

A)  open Group Header and Footer sections 
B)  add grouping fields 
C)  set sort orders 
D)  All of the above 
A)  open Group Header and Footer sections 
B)  add grouping fields 
C)  set sort orders 
D)  All of the above

Question 12

-In the accompanying figure, what is the grouping field?

Accepted Answer

A)  Category 
B)  TourNo 
C)  TourName 
D)  Cost 
A)  Category 
B)  TourNo 
C)  TourName 
D)  Cost

Question 13

It is necessary for every report to have Report Header and Report Footer sections.

Accepted Answer

A) True 
 B)False

Question 14

Match each term with its correct description.
-Predefined format that you can apply to all objects in the database

Accepted Answer

A) Summary report 
B) Parameter report 
C) Conditional formatting 
D) Format Painter 
E) Theme 
A) Summary report 
B) Parameter report 
C) Conditional formatting 
D) Format Painter 
E) Theme

Question 15

Report section properties cannot be modified to improve report printouts. _________________________

Accepted Answer

A) True 
 B)False

Question 16

To create a report that shows only group summary information, delete all of the controls in the ____________________ section.

Accepted Answer

The answer of To create a report that shows only...

Question 17

Why might you want to use a subreport control?

Accepted Answer

You use the subreport control

Question 18

Match each term with its correct description.
-Copies formatting properties from one control to another

Accepted Answer

A) Summary report 
B) Parameter report 
C) Conditional formatting 
D) Format Painter 
E) Theme 
A) Summary report 
B) Parameter report 
C) Conditional formatting 
D) Format Painter 
E) Theme

Question 19

Match each term with its correct description.
-Changes the way a control looks on a form or report based on criteria you specify

Accepted Answer

A) Summary report 
B) Parameter report 
C) Conditional formatting 
D) Format Painter 
E) Theme 
A) Summary report 
B) Parameter report 
C) Conditional formatting 
D) Format Painter 
E) Theme

Question 20

What type of line under a value indicates grand totals?

Accepted Answer

A)  A bold line of any color. 
B)  A thick red line. 
C)  A thick blue line. 
D)  Double lines. 
A)  A bold line of any color. 
B)  A thick red line. 
C)  A thick blue line. 
D)  Double lines.

You enter criteria in the Enter Parameter Value box for a parameter report. _________________________

To create a parameter report, you base it on a parameter table. _________________________

You use conditional formatting to highlight important data in a report.

The report's ____ property determines what table or query provides the fields and records for a report.

Report ____________________ View allows you to work with a complete range of report, section, and control properties.

-In the accompanying figure, which section does not contain any controls?

A ____ prompts you for criteria to determine the records to use for the report.

Which report section would be the most logical choice to display the grouping field value?

-Doug builds the report shown in the accompanying figure. How did Doug group the records and why might he have the TourName Footer section open even though there are no controls in that section?

Compared to forms and datasheets, ____ give you more control over how data is printed and greater flexibility in presenting summary information.

-In the accompanying figure, item 2 helps you ____.

-In the accompanying figure, what is the grouping field?

It is necessary for every report to have Report Header and Report Footer sections.

Match each term with its correct description. -Predefined format that you can apply to all objects in the database

Report section properties cannot be modified to improve report printouts. _________________________

To create a report that shows only group summary information, delete all of the controls in the ____________________ section.

Why might you want to use a subreport control?

Match each term with its correct description. -Copies formatting properties from one control to another

Match each term with its correct description. -Changes the way a control looks on a form or report based on criteria you specify

What type of line under a value indicates grand totals?

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

Importing and Exporting Data

Analyzing Database Design Using Northwind

Creating Advanced Queries

Creating Advanced Reports

Creating Macros

Creating Modules and Vba

Administering the Database

Chapter Access and the Web

Filters

Exam 9: Analyzing Data With Reports

You enter criteria in the Enter Parameter Value box for a parameter report. _________________________

To create a parameter report, you base it on a parameter table. _________________________

You use conditional formatting to highlight important data in a report.

The report's ____ property determines what table or query provides the fields and records for a report.

Report ____________________ View allows you to work with a complete range of report, section, and control properties.

-In the accompanying figure, which section does not contain any controls?

A ____ prompts you for criteria to determine the records to use for the report.

Which report section would be the most logical choice to display the grouping field value?

-Doug builds the report shown in the accompanying figure. How did Doug group the records and why might he have the TourName Footer section open even though there are no controls in that section?

Compared to forms and datasheets, ____ give you more control over how data is printed and greater flexibility in presenting summary information.

-In the accompanying figure, item 2 helps you ____.

-In the accompanying figure, what is the grouping field?

It is necessary for every report to have Report Header and Report Footer sections.

Match each term with its correct description. -Predefined format that you can apply to all objects in the database

Report section properties cannot be modified to improve report printouts. _________________________

To create a report that shows only group summary information, delete all of the controls in the ____________________ section.

Why might you want to use a subreport control?

Match each term with its correct description. -Copies formatting properties from one control to another

Match each term with its correct description. -Changes the way a control looks on a form or report based on criteria you specify

What type of line under a value indicates grand totals?

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

Importing and Exporting Data

Analyzing Database Design Using Northwind

Creating Advanced Queries

Creating Advanced Reports

Creating Macros

Creating Modules and Vba

Administering the Database

Chapter Access and the Web

Filters