Question 1

In the accompanying figure, why might the controls in the Report Header section be selected?

Accepted Answer

A)  to create a calculated field 
B)  to add a subform 
C)  to add a text box 
D)  to remove a report layout 
A)  to create a calculated field 
B)  to add a subform 
C)  to add a text box 
D)  to remove a report layout

Question 2

Report section ____________________ are the characteristics that define each section.

Accepted Answer

The answer of Report section ____________________ are the characteristics that...

Question 3

It is necessary to keep all of the report sections the same height in order for the report to display properly.

Accepted Answer

A) True 
 B)False

Question 4

In the accompanying figure, what type of control is NOT found in the Page Header section?

Accepted Answer

A)  Label 
B)  Combo box 
C)  All of these controls are found in the Page Header section 
D)  Text box 
A)  Label 
B)  Combo box 
C)  All of these controls are found in the Page Header section 
D)  Text box

Question 5

Default margins are often 0.25 inches in Report Design View.  For a report printed in portrait orientation on 8.5x11" paper, this means that the report can be no wider than ____.

Accepted Answer

A)  10.5 inches 
B)  8 inches 
C)  11 inches 
D)  the paper 
A)  10.5 inches 
B)  8 inches 
C)  11 inches 
D)  the paper

Question 6

The Format ____________________ is a tool used to copy formatting properties from one control to another.

Accepted Answer

The answer of The Format ____________________ is a tool used...

Question 7

In the accompanying figure, item 5 helps you ____.

Accepted Answer

A)  add controls to the report that are not currently visible 
B)  set the tab order for the report 
C)  set sorting and grouping fields 
D)  enter expressions for calculations 
A)  add controls to the report that are not currently visible 
B)  set the tab order for the report 
C)  set sorting and grouping fields 
D)  enter expressions for calculations

Question 8

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

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 10

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

Accepted Answer

A) True 
 B)False

Question 11

Report sections have properties.

Accepted Answer

A) True 
 B)False

Question 12

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 13

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

Accepted Answer

A) True 
 B)False

Question 14

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

Accepted Answer

A) True 
 B)False

Question 15

In the accompanying figure, click the button identified as item 1 to change the Force New Page property.

Accepted Answer

A) True 
 B)False

Question 16

Why might you want to use a subreport control?

Accepted Answer

You use the subreport control

Question 17

Double-clicking the Format Painter button formats all controls in that section with the formatting characteristics of the currently selected control.

Accepted Answer

A) True 
 B)False

Question 18

Which report section prints once for every record?

Accepted Answer

A)  Record 
B)  Group 
C)  Detail 
D)  Page 
A)  Record 
B)  Group 
C)  Detail 
D)  Page

Question 19

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 20

Summary reports typically have no controls in which section?

Accepted Answer

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

In the accompanying figure, why might the controls in the Report Header section be selected?

Report section ____________________ are the characteristics that define each section.

It is necessary to keep all of the report sections the same height in order for the report to display properly.

In the accompanying figure, what type of control is NOT found in the Page Header section?

Default margins are often 0.25 inches in Report Design View. For a report printed in portrait orientation on 8.5x11" paper, this means that the report can be no wider than ____.

The Format ____________________ is a tool used to copy formatting properties from one control to another.

In the accompanying figure, item 5 helps you ____.

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

In the accompanying figure, what is the grouping field?

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

Report sections have properties.

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

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

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

In the accompanying figure, click the button identified as item 1 to change the Force New Page property.

Why might you want to use a subreport control?

Double-clicking the Format Painter button formats all controls in that section with the formatting characteristics of the currently selected control.

Which report section prints once for every record?

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

Summary reports typically have no controls in which section?

Getting Started With 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 Macros

Administering the Database

Access and the Web

Getting Started With Microsoft Office 2013

Filters

Exam 8: Analyzing Data With Reports

In the accompanying figure, why might the controls in the Report Header section be selected?

Report section ____________________ are the characteristics that define each section.

It is necessary to keep all of the report sections the same height in order for the report to display properly.

In the accompanying figure, what type of control is NOT found in the Page Header section?

Default margins are often 0.25 inches in Report Design View. For a report printed in portrait orientation on 8.5x11" paper, this means that the report can be no wider than ____.

The Format ____________________ is a tool used to copy formatting properties from one control to another.

In the accompanying figure, item 5 helps you ____.

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

In the accompanying figure, what is the grouping field?

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

Report sections have properties.

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

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

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

In the accompanying figure, click the button identified as item 1 to change the Force New Page property.

Why might you want to use a subreport control?

Double-clicking the Format Painter button formats all controls in that section with the formatting characteristics of the currently selected control.

Which report section prints once for every record?

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

Summary reports typically have no controls in which section?

Getting Started With 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 Macros

Administering the Database

Access and the Web

Getting Started With Microsoft Office 2013

Filters