Question 1

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 2

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

Accepted Answer

A) True 
 B)False

Question 3

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 4

You can add ____ conditional format(s) for any combination of selected controls.

Accepted Answer

A)  One 
B)  Two 
C)  Multiple 
D)  Currency 
A)  One 
B)  Two 
C)  Multiple 
D)  Currency

Question 5

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 6

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

Accepted Answer

A) True 
 B)False

Question 7

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]

Question 8

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 9

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

Accepted Answer

You might want a Group Header

Question 10

Compared to forms and datasheets, ____ give you more control over how data is printed and greater flexibility in presenting summary information.

Accepted Answer

A)  Macros 
B)  Modules 
C)  Queries 
D)  Reports 
A)  Macros 
B)  Modules 
C)  Queries 
D)  Reports

Question 11

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 12

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 13

In the accompanying figure, the expression =Sum( Revenue ) is contained in a text box in both the Category Footer as well as Report Footer sections. Explain the difference between these two controls.

Accepted Answer

The controls and expressions within them

Question 14

Doug builds the report shown in the accompanying figure. How did Doug group the records and why might he have the TourName Footer section open even though there are no controls in that section?

Accepted Answer

Doug grouped the records by To

Question 15

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 16

In the accompanying figure, what field is used as the grouping field?

Accepted Answer

A)  Category 
B)  TourName 
C)  CustNo 
D)  SaleDate 
A)  Category 
B)  TourName 
C)  CustNo 
D)  SaleDate

Question 17

Why might you want to use a subreport control?

Accepted Answer

You use the subreport control

Question 18

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 19

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

Accepted Answer

A) True 
 B)False

Question 20

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

Which of the following is NOT changed with a theme?

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

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

You can add ____ conditional format(s) for any combination of selected controls.

Summary reports typically have no controls in which section?

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

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

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

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

Compared to forms and datasheets, ____ give you more control over how data is printed and greater flexibility in presenting summary information.

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

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

In the accompanying figure, the expression =Sum( Revenue ) is contained in a text box in both the Category Footer as well as Report Footer sections. Explain the difference between these two controls.

Doug builds the report shown in the accompanying figure. How did Doug group the records and why might he have the TourName Footer section open even though there are no controls in that section?

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

In the accompanying figure, what field is used as the grouping field?

Why might you want to use a subreport control?

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

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

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

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

Which of the following is NOT changed with a theme?

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

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

You can add ____ conditional format(s) for any combination of selected controls.

Summary reports typically have no controls in which section?

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

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

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

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

Compared to forms and datasheets, ____ give you more control over how data is printed and greater flexibility in presenting summary information.

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

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

In the accompanying figure, the expression =Sum( Revenue ) is contained in a text box in both the Category Footer as well as Report Footer sections. Explain the difference between these two controls.

Doug builds the report shown in the accompanying figure. How did Doug group the records and why might he have the TourName Footer section open even though there are no controls in that section?

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

In the accompanying figure, what field is used as the grouping field?

Why might you want to use a subreport control?

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

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

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

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