Question 1

Report section ____________________ are the characteristics that define each section.

Accepted Answer

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

Question 2

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 3

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 4

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 5

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

Accepted Answer

A) True 
 B)False

Question 6

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 7

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

Accepted Answer

A) True 
 B)False

Question 8

In the accompanying figure, item 5 helps you ____.

Accepted Answer

A)  add fields 
B)  set the database theme 
C)  add controls 
D)  add lines 
A)  add fields 
B)  set the database theme 
C)  add controls 
D)  add lines

Question 9

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 10

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

Accepted Answer

A) True 
 B)False

Question 11

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

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

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

Accepted Answer

A) True 
 B)False

Question 14

The ____________________ New Page property helps you start printing a section at the top of a new page.

Accepted Answer

The answer of The ____________________ New Page property helps you...

Question 15

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

Accepted Answer

A) True 
 B)False

Question 16

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 17

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 18

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 19

In the accompanying figure, click item 5 to add a _____ to a report.

Accepted Answer

A)  label 
B)  text box 
C)  sort order 
D)  subreport 
A)  label 
B)  text box 
C)  sort order 
D)  subreport

Question 20

You can use the Format Painter to format lines, labels, and text boxes.

Accepted Answer

A) True 
 B)False

Report section ____________________ are the characteristics that define each section.

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

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

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

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

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

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

In the accompanying figure, item 5 helps you ____.

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?

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

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

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

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

The ____________________ New Page property helps you start printing a section at the top of a new page.

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

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

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

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?

In the accompanying figure, click item 5 to add a _____ to a report.

You can use the Format Painter to format lines, labels, and text boxes.

Getting Started With Microsoft Office 2013

Getting Started With Access 2013

Building and Using Queries

Using Forms

Using Reports

Modifying the Database Structure

Improving Queries

Analyzing Data With Reports

Filters

Exam 8: Enhancing Forms

Report section ____________________ are the characteristics that define each section.

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

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

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

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

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

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

In the accompanying figure, item 5 helps you ____.

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?

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

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

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

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

The ____________________ New Page property helps you start printing a section at the top of a new page.

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

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

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

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?

In the accompanying figure, click item 5 to add a _____ to a report.

You can use the Format Painter to format lines, labels, and text boxes.

Getting Started With Microsoft Office 2013

Getting Started With Access 2013

Building and Using Queries

Using Forms

Using Reports

Modifying the Database Structure

Improving Queries

Analyzing Data With Reports

Filters