Question 1

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

Accepted Answer

A) True 
 B)False

Question 2

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

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

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 6

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 7

-In the accompanying figure, text boxes are positioned in the ____________________ section.

Accepted Answer

The answer of  
-In the accompanying figure, text boxes...

Question 8

Which report section is most commonly used for titles, dates, and page numbers?

Accepted Answer

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

Question 9

-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 10

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

How are lines used in a typical Access report?

Accepted Answer

Lines are used to visually sep

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

-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 14

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

Accepted Answer

A) True 
 B)False

Question 15

You enter parameter criteria in Query Design View inside of ____.

Accepted Answer

A)  [square brackets] 
B)  {curly brackets} 
C)  (parentheses) 
D)  "quotation marks" 
A)  [square brackets] 
B)  {curly brackets} 
C)  (parentheses) 
D)  "quotation marks"

Question 16

You modify the Set New Page property of a section to force each section to start printing at the top of a new page. _________________________

Accepted Answer

A) True 
 B)False

Question 17

Themes can include font, color, and alignment choices.

Accepted Answer

A) True 
 B)False

Question 18

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

Accepted Answer

A) True 
 B)False

Question 19

Discuss two reasons you might want to modify section properties in a report.

Accepted Answer

You might want a Group Header

Question 20

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.

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

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

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

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

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

Which of the following is NOT changed with a theme?

-In the accompanying figure, text boxes are positioned in the ____________________ section.

Which report section is most commonly used for titles, dates, and page numbers?

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

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

How are lines used in a typical Access report?

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

-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(n) theme displays a report within another report. _________________________

You enter parameter criteria in Query Design View inside of ____.

You modify the Set New Page property of a section to force each section to start printing at the top of a new page. _________________________

Themes can include font, color, and alignment choices.

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

Discuss two reasons you might want to modify section properties in a report.

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

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 can use the Format Painter to format lines, labels, and text boxes.

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

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

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

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

Which of the following is NOT changed with a theme?

-In the accompanying figure, text boxes are positioned in the ____________________ section.

Which report section is most commonly used for titles, dates, and page numbers?

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

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

How are lines used in a typical Access report?

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

-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(n) theme displays a report within another report. _________________________

You enter parameter criteria in Query Design View inside of ____.

You modify the Set New Page property of a section to force each section to start printing at the top of a new page. _________________________

Themes can include font, color, and alignment choices.

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

Discuss two reasons you might want to modify section properties in a report.

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

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