Question 1

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  False

Question 2

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

Accepted Answer

Force

Question 3

Which key do you press and hold to create a perfectly horizontal line?

Accepted Answer

A)  [Alt] 
B)  [Ctrl] 
C)  [Shift] 
D)  [Caps Lock] 
A)  [Alt] 
B)  [Ctrl] 
C)  [Shift] 
D)  [Caps Lock] C

Question 4

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

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 6

It is necessary for each report to have at least one control in the Detail section.

Accepted Answer

A) True 
 B)False

Question 7

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 8

The report that contains the subreport control is called the main report. _________________________

Accepted Answer

A) True 
 B)False

Question 9

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

Accepted Answer

A) True 
 B)False

Question 10

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

Accepted Answer

A) True 
 B)False

Question 11

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

Question 12

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 13

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

Which section prints at the top of the first page of the report?

Accepted Answer

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

Question 15

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

Question 16

-In Access parameter reports, you can shorten date criteria by entering only two digits for the year instead of four.

Accepted Answer

A) True 
 B)False

Question 17

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

Question 18

A(n) ____________________ gives you more control over how data is printed than forms and datasheets.

Accepted Answer

The answer of A(n) ____________________ gives you more control over...

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

Which report section would be the most logical choice to use for the report title or logo?

Accepted Answer

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

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

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

Which key do you press and hold to create a perfectly horizontal line?

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

Which report section prints once for every record?

It is necessary for each report to have at least one control in the Detail section.

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

The report that contains the subreport control is called the main report. _________________________

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

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

Summary reports typically have no controls in which section?

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

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

Which section prints at the top of the first page of the report?

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

-In Access parameter reports, you can shorten date criteria by entering only two digits for the year instead of four.

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

A(n) ____________________ gives you more control over how data is printed than forms and datasheets.

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

Which report section would be the most logical choice to use for the report title or logo?

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

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

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

Which key do you press and hold to create a perfectly horizontal line?

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

Which report section prints once for every record?

It is necessary for each report to have at least one control in the Detail section.

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

The report that contains the subreport control is called the main report. _________________________

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

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

Summary reports typically have no controls in which section?

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

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

Which section prints at the top of the first page of the report?

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

-In Access parameter reports, you can shorten date criteria by entering only two digits for the year instead of four.

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

A(n) ____________________ gives you more control over how data is printed than forms and datasheets.

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

Which report section would be the most logical choice to use for the report title or logo?

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