Question 1

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

Accepted Answer

A) True 
 B)False

Question 2

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

Accepted Answer

A) True 
 B)False

Question 3

In a report, label controls display data from underlying fields.

Accepted Answer

A) True 
 B)False

Question 4

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 5

In Report Design View, lines can be difficult to find when they are against the edge of a section or the edge of another control.

Accepted Answer

A) True 
 B)False

Question 6

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 7

Kelsey uses Access to track the sales by category for each tour. Referring to the accompanying figure, what is the name of the field she should use in an expression to total the sales?

Accepted Answer

The answer of   Kelsey uses Access to track...

Question 8

The Group, Sort, and Total pane allows you to open group header and footer sections.

Accepted Answer

A) True 
 B)False

Question 9

You create a parameter report based on a parameter query by setting the report's ____ property.

Accepted Answer

A)  Recordset 
B)  Group Controls 
C)  Record Source 
D)  None of the above. 
A)  Recordset 
B)  Group Controls 
C)  Record Source 
D)  None of the above.

Question 10

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 11

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

Accepted Answer

A) True 
 B)False

Question 12

Conditional formatting allows you to compare the values of one column to another with small data bars.

Accepted Answer

A) True 
 B)False

Question 13

Which of the following is NOT changed with a theme?

Accepted Answer

A)  fonts 
B)  colors 
C)  field values 
D)  control alignment 
A)  fonts 
B)  colors 
C)  field values 
D)  control alignment

Question 14

Identify at least two major ways you can improve report formatting productivity.

Accepted Answer

1. Use conditional formatting to highlig

Question 15

A(n) theme displays a report within another report. _________________________

Accepted Answer

A) True 
 B)False

Question 16

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 17

In the accompanying figure, how many controls are in the Category Header section?

Accepted Answer

A)  1 
B)  2 
C)  7 
D)  8 
A)  1 
B)  2 
C)  7 
D)  8

Question 18

The Theme Painter is a tool you use to copy multiple formatting properties from one control to another. _________________________

Accepted Answer

A) True 
 B)False

Question 19

Aaron builds the report shown in the accompanying figure.  What will happen to the controls that are shown in the Page Header section if the TourName Footer section properties specify that a new report page should start at the top of each page?

Accepted Answer

The controls in the Page Heade

Question 20

A report that contains a subreport is called the ____ report.

Accepted Answer

A)  control 
B)  main 
C)  parent 
D)  property 
A)  control 
B)  main 
C)  parent 
D)  property

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

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

In a report, label controls display data from underlying fields.

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

In Report Design View, lines can be difficult to find when they are against the edge of a section or the edge of another control.

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

Kelsey uses Access to track the sales by category for each tour. Referring to the accompanying figure, what is the name of the field she should use in an expression to total the sales?

The Group, Sort, and Total pane allows you to open group header and footer sections.

You create a parameter report based on a parameter query by setting the report's ____ property.

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

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

Conditional formatting allows you to compare the values of one column to another with small data bars.

Which of the following is NOT changed with a theme?

Identify at least two major ways you can improve report formatting productivity.

A(n) theme displays a report within another report. _________________________

In the accompanying figure, item 2 helps you ____.

In the accompanying figure, how many controls are in the Category Header section?

The Theme Painter is a tool you use to copy multiple formatting properties from one control to another. _________________________

Aaron builds the report shown in the accompanying figure. What will happen to the controls that are shown in the Page Header section if the TourName Footer section properties specify that a new report page should start at the top of each page?

A report that contains a subreport is called the ____ report.

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

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

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

In a report, label controls display data from underlying fields.

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

In Report Design View, lines can be difficult to find when they are against the edge of a section or the edge of another control.

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

Kelsey uses Access to track the sales by category for each tour. Referring to the accompanying figure, what is the name of the field she should use in an expression to total the sales?

The Group, Sort, and Total pane allows you to open group header and footer sections.

You create a parameter report based on a parameter query by setting the report's ____ property.

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

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

Conditional formatting allows you to compare the values of one column to another with small data bars.

Which of the following is NOT changed with a theme?

Identify at least two major ways you can improve report formatting productivity.

A(n) theme displays a report within another report. _________________________

In the accompanying figure, item 2 helps you ____.

In the accompanying figure, how many controls are in the Category Header section?

The Theme Painter is a tool you use to copy multiple formatting properties from one control to another. _________________________

Aaron builds the report shown in the accompanying figure. What will happen to the controls that are shown in the Page Header section if the TourName Footer section properties specify that a new report page should start at the top of each page?

A report that contains a subreport is called the ____ report.

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