Question 1

If a report is too wide, you will see a green error indicator in the ____ corner of the report.

Accepted Answer

A)  upper-right 
B)  lower-left 
C)  lower-right 
D)  upper-left 
A)  upper-right 
B)  lower-left 
C)  lower-right 
D)  upper-left

Question 2

____ refers to enhancing the appearance of the information.

Accepted Answer

A)  Laying out 
B)  Coloring 
C)  Formatting 
D)  Reshaping 
A)  Laying out 
B)  Coloring 
C)  Formatting 
D)  Reshaping

Question 3

The ____________________ source is the table or query that defines the fields and records displayed on a report.

Accepted Answer

The answer of The ____________________ source is the table or...

Question 4

The same expression in different sections of a report produces different calculations.

Accepted Answer

A) True 
 B)False

Question 5

You can click in the horizontal or vertical ____ to select all controls that intersect the selection line.

Accepted Answer

A)  ruler 
B)  section header 
C)  launcher 
D)  command line 
A)  ruler 
B)  section header 
C)  launcher 
D)  command line

Question 6

What are the steps to add a label to a report?

Accepted Answer

In Report Design View, click the Label b

Question 7

Match each numbered item in the accompanying figure with its button name.
-Align Right

Accepted Answer

A) Item 1 
B) Item 2 
C) Item 3 
D) Item 4 
E) Item 5
F)Item 6
G)Item 7
H)Item 8 
A) Item 1 
B) Item 2 
C) Item 3 
D) Item 4 
E) Item 5
F)Item 6
G)Item 7
H)Item 8

Question 8

The Group Header section prints ____.

Accepted Answer

A)  at the top of the first page of the report 
B)  at the top of every page 
C)  once for every record 
D)  before every group of records 
A)  at the top of the first page of the report 
B)  at the top of every page 
C)  once for every record 
D)  before every group of records

Question 9

The Page Footer section prints ____.

Accepted Answer

A)  at the bottom of every page 
B)  at the end of the entire report 
C)  at the end of the first and last pages in the report 
D)  once for every group of records 
A)  at the bottom of every page 
B)  at the end of the entire report 
C)  at the end of the first and last pages in the report 
D)  once for every group of records

Question 10

-In the accompanying figure, item 2 points to the ____ section.

Accepted Answer

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

Question 11

You can rename labels in Report Layout View.

Accepted Answer

A) True 
 B)False

Question 12

Which section prints once for every record?

Accepted Answer

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

Question 13

The report section before a group of records is called the Group ____________________ section.

Accepted Answer

The answer of The report section before a group of...

Question 14

-In the accompanying figure, item 1 points to the ____ section.

Accepted Answer

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

Question 15

A(n) ____________________ is a built-in formula, such as Sum or Count.

Accepted Answer

The answer of A(n) ____________________ is a built-in formula, such...

Question 16

The Report Header section prints ____.

Accepted Answer

A)  at the top of every page 
B)  at the top of the first page 
C)  before every group of records 
D)  once for every record 
A)  at the top of every page 
B)  at the top of the first page 
C)  before every group of records 
D)  once for every record

Question 17

Bradley plans to generate reports from an Access database that a colleague of his built. As he works with the reports, he decides to familiarize himself with each of the views that is available to him.
-Bradley is just getting started with one of the reports and he needs to quickly review it to see what it contains. He does not want his view to contain any page breaks. Which view should he use?

Accepted Answer

A)  Report View 
B)  Layout View 
C)  Print Preview 
D)  Design View 
A)  Report View 
B)  Layout View 
C)  Print Preview 
D)  Design View

Question 18

The Alternate Row Color command changes the background color of alternate records in a selected section. _________________________

Accepted Answer

A) True 
 B)False

Question 19

You can add a field as a grouping field in which pane?

Accepted Answer

A)  Properties 
B)  Field List 
C)  Toolbox 
D)  Group, Sort, and Total 
A)  Properties 
B)  Field List 
C)  Toolbox 
D)  Group, Sort, and Total

Question 20

You can both group and sort records on the same report.

Accepted Answer

A) True 
 B)False

If a report is too wide, you will see a green error indicator in the ____ corner of the report.

____ refers to enhancing the appearance of the information.

The ____________________ source is the table or query that defines the fields and records displayed on a report.

The same expression in different sections of a report produces different calculations.

You can click in the horizontal or vertical ____ to select all controls that intersect the selection line.

What are the steps to add a label to a report?

Match each numbered item in the accompanying figure with its button name. -Align Right

The Group Header section prints ____.

The Page Footer section prints ____.

-In the accompanying figure, item 2 points to the ____ section.

You can rename labels in Report Layout View.

Which section prints once for every record?

The report section before a group of records is called the Group ____________________ section.

-In the accompanying figure, item 1 points to the ____ section.

A(n) ____________________ is a built-in formula, such as Sum or Count.

The Report Header section prints ____.

The Alternate Row Color command changes the background color of alternate records in a selected section. _________________________

You can add a field as a grouping field in which pane?

You can both group and sort records on the same report.

Getting Started With Microsoft Office 2013

Getting Started With Chapter Access 2013

Building and Using Queries

Using Forms

Modifying the Database Structure

Improving Queries

Enhancing Forms

Analyzing Data With Reports

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 5: Using Reports

If a report is too wide, you will see a green error indicator in the ____ corner of the report.

____ refers to enhancing the appearance of the information.

The ____________________ source is the table or query that defines the fields and records displayed on a report.

The same expression in different sections of a report produces different calculations.

You can click in the horizontal or vertical ____ to select all controls that intersect the selection line.

What are the steps to add a label to a report?

Match each numbered item in the accompanying figure with its button name. -Align Right

The Group Header section prints ____.

The Page Footer section prints ____.

-In the accompanying figure, item 2 points to the ____ section.

You can rename labels in Report Layout View.

Which section prints once for every record?

The report section before a group of records is called the Group ____________________ section.

-In the accompanying figure, item 1 points to the ____ section.

A(n) ____________________ is a built-in formula, such as Sum or Count.

The Report Header section prints ____.

The Alternate Row Color command changes the background color of alternate records in a selected section. _________________________

You can add a field as a grouping field in which pane?

You can both group and sort records on the same report.

Getting Started With Microsoft Office 2013

Getting Started With Chapter Access 2013

Building and Using Queries

Using Forms

Modifying the Database Structure

Improving Queries

Enhancing Forms

Analyzing Data With Reports

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