Question 1

Short double lines under the calculations in the Report Footer section indicate ____.

Accepted Answer

A)  changed data 
B)  grand totals 
C)  exceptional conditions 
D)  conditional formatting 
A)  changed data 
B)  grand totals 
C)  exceptional conditions 
D)  conditional formatting

Question 2

To move a control from one report section to another, use cut and paste.

Accepted Answer

A) True 
 B)False

Question 3

Which report section is most commonly used to calculate a summary statistic on a group of records?

Accepted Answer

A)  Detail 
B)  Group Footer 
C)  Page Footer 
D)  Calculation Footer 
A)  Detail 
B)  Group Footer 
C)  Page Footer 
D)  Calculation Footer

Question 4

____________________ formatting allows you to change the appearance of a control on a form or report based on criteria you specify.

Accepted Answer

The answer of ____________________ formatting allows you to change the...

Question 5

The expression =Sum([Price]) is contained in a text box in both the Category Footer as well as Report Footer sections.  Explain the difference between these two controls.

Accepted Answer

The controls and expressions within them

Question 6

Report sections have properties.

Accepted Answer

A) True 
 B)False

Question 7

Parameters are predefined formats that you apply to the database to set all of the formatting enhancements. _________________________

Accepted Answer

A) True 
 B)False

Question 8

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

Accepted Answer

A) True 
 B)False

Question 9

Why might you want to use a subreport control?

Accepted Answer

You use the subreport control

Question 10

You can use a(n) subreport control to change the order in which information prints. _________________________

Accepted Answer

A) True 
 B)False

Question 11

Which control is used to add a report to another report?

Accepted Answer

A)  text box 
B)  combo box 
C)  subreport 
D)  group section 
A)  text box 
B)  combo box 
C)  subreport 
D)  group section

Question 12

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.

Question 13

Report Design View gives you full control of all aspects of a report.

Accepted Answer

A) True 
 B)False

Question 14

Which of the following is NOT an option in the Conditional Formatting Rules Manager dialog box?

Accepted Answer

A)  Defining the rules. 
B)  Defining the formats. 
C)  Determining which control to conditionally format. 
D)  Changing the value of the control. 
A)  Defining the rules. 
B)  Defining the formats. 
C)  Determining which control to conditionally format. 
D)  Changing the value of the control.

Question 15

Which of the following is not a category tab in the Property Sheet?

Accepted Answer

A)  Print 
B)  Format 
C)  Data 
D)  All 
A)  Print 
B)  Format 
C)  Data 
D)  All

Question 16

____________________ reports are reports that show statistics on groups of records rather than detailed information.

Accepted Answer

The answer of ____________________ reports are reports that show statistics...

Question 17

____________________ are predefined formats that you apply to the database to set all of the formatting enhancements such as font, color, and alignment.

Accepted Answer

The answer of ____________________ are predefined formats that you apply...

Question 18

To create a summary report, you should delete all of the controls in the ____ section of the report.

Accepted Answer

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

Question 19

Which of the following reports would be the most logical choice for a Vice President who is interested in high level, aggregated totals and not individual details?

Accepted Answer

A)  parameter report 
B)  subreport 
C)  main report 
D)  summary report 
A)  parameter report 
B)  subreport 
C)  main report 
D)  summary report

Question 20

How are lines used in a typical Access report?

Accepted Answer

Lines are used to visually sep

Short double lines under the calculations in the Report Footer section indicate ____.

To move a control from one report section to another, use cut and paste.

Which report section is most commonly used to calculate a summary statistic on a group of records?

____________________ formatting allows you to change the appearance of a control on a form or report based on criteria you specify.

The expression =Sum([Price]) is contained in a text box in both the Category Footer as well as Report Footer sections. Explain the difference between these two controls.

Report sections have properties.

Parameters are predefined formats that you apply to the database to set all of the formatting enhancements. _________________________

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

Why might you want to use a subreport control?

You can use a(n) subreport control to change the order in which information prints. _________________________

Which control is used to add a report to another report?

What type of line under a value indicates grand totals?

Report Design View gives you full control of all aspects of a report.

Which of the following is NOT an option in the Conditional Formatting Rules Manager dialog box?

Which of the following is not a category tab in the Property Sheet?

____________________ reports are reports that show statistics on groups of records rather than detailed information.

____________________ are predefined formats that you apply to the database to set all of the formatting enhancements such as font, color, and alignment.

To create a summary report, you should delete all of the controls in the ____ section of the report.

Which of the following reports would be the most logical choice for a Vice President who is interested in high level, aggregated totals and not individual details?

How are lines used in a typical Access report?

Getting Started With Access

Building and Using Queries

Using Forms

Using Reports

Modifying the Database Structure

Improving Queries

Enhancing Forms

Importing and Exporting Data

Creating Advanced Queries

Creating Advanced Reports

Creating Macros

Creating Modules and Vba

Administering the Database

Using Acess and the Web

Completing a Database Application

Filters

Exam 8: Analyizng Data With Reports

Short double lines under the calculations in the Report Footer section indicate ____.

To move a control from one report section to another, use cut and paste.

Which report section is most commonly used to calculate a summary statistic on a group of records?

____________________ formatting allows you to change the appearance of a control on a form or report based on criteria you specify.

The expression =Sum([Price]) is contained in a text box in both the Category Footer as well as Report Footer sections. Explain the difference between these two controls.

Report sections have properties.

Parameters are predefined formats that you apply to the database to set all of the formatting enhancements. _________________________

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

Why might you want to use a subreport control?

You can use a(n) subreport control to change the order in which information prints. _________________________

Which control is used to add a report to another report?

What type of line under a value indicates grand totals?

Report Design View gives you full control of all aspects of a report.

Which of the following is NOT an option in the Conditional Formatting Rules Manager dialog box?

Which of the following is not a category tab in the Property Sheet?

____________________ reports are reports that show statistics on groups of records rather than detailed information.

____________________ are predefined formats that you apply to the database to set all of the formatting enhancements such as font, color, and alignment.

To create a summary report, you should delete all of the controls in the ____ section of the report.

Which of the following reports would be the most logical choice for a Vice President who is interested in high level, aggregated totals and not individual details?

How are lines used in a typical Access report?

Getting Started With Access

Building and Using Queries

Using Forms

Using Reports

Modifying the Database Structure

Improving Queries

Enhancing Forms

Importing and Exporting Data

Creating Advanced Queries

Creating Advanced Reports

Creating Macros

Creating Modules and Vba

Administering the Database

Using Acess and the Web

Completing a Database Application

Filters