Question 1

Which report view's primary purpose is to review each page of the entire report as it will appear if printed?

Accepted Answer

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

Question 2

-In the accompanying figure, item 4 points to the ____ View button.

Accepted Answer

A)  Report 
B)  Layout 
C)  Zoom 
D)  Design 
A)  Report 
B)  Layout 
C)  Zoom 
D)  Design

Question 3

A ____ box is an outline box you create by dragging the pointer in Report Design View.

Accepted Answer

A)  selection 
B)  design 
C)  pointer 
D)  drag 
A)  selection 
B)  design 
C)  pointer 
D)  drag

Question 4

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

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 5

The Report Wizard automatically applies many formatting embellishments to a report.

Accepted Answer

A) True 
 B)False

Question 6

Which of the following is NOT a common report embellishment?

Accepted Answer

A)  Headers 
B)  Footers 
C)  Multiple fonts and colors 
D)  Command Buttons 
A)  Headers 
B)  Footers 
C)  Multiple fonts and colors 
D)  Command Buttons

Question 7

Koch labels are the most common manufacturer of labels, and therefore the default choice. _________________________

Accepted Answer

A) True 
 B)False

Question 8

Which two sections can be added to a report if you group records?

Accepted Answer

A)  Group Header and Group Footer 
B)  Group Header and Detail 
C)  Group Footer and Detail 
D)  Group Summary and Detail 
A)  Group Header and Group Footer 
B)  Group Header and Detail 
C)  Group Footer and Detail 
D)  Group Summary and Detail

Question 9

Use the Group, Sort, and ____________________ pane to modify sort orders in Report Design View.

Accepted Answer

The answer of Use the Group, Sort, and ____________________ pane...

Question 10

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 almost ready to print one of the reports. He wants to review the first page of the report to see how it will look when printed. 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 11

The Group Footer section prints ____.

Accepted Answer

A)  before every group of records 
B)  after every group of records 
C)  at the top of every page 
D)  at the bottom of every page 
A)  before every group of records 
B)  after every group of records 
C)  at the top of every page 
D)  at the bottom of every page

Question 12

Match each numbered item in the accompanying figure with its button name.
-Alternate Row Color

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 13

One way to select more than one control at a time in Report Design View is to click a control and press and hold ____ while clicking other controls.

Accepted Answer

A)  [Shift] 
B)  [Esc] 
C)  [F5] 
D)  [Alt] 
A)  [Shift] 
B)  [Esc] 
C)  [F5] 
D)  [Alt]

Question 14

For your report to fit on one page in a given orientation, you may need to move all of the controls within a given mark on the horizontal ____.

Accepted Answer

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

Question 15

Pressing the arrow keys while holding [Ctrl] moves selected controls one millimeter at a time in the direction of the arrow. _________________________

Accepted Answer

A) True 
 B)False

Question 16

The Report Footer section prints ____.

Accepted Answer

A)  at the end of the entire report 
B)  at the bottom of every page 
C)  at the top of the entire report 
D)  at the top of every page 
A)  at the end of the entire report 
B)  at the bottom of every page 
C)  at the top of the entire report 
D)  at the top of every page

Question 17

Reports are view-only objects, meaning they can be used to read and display data but cannot be used to change data. _________________________

Accepted Answer

A) True 
 B)False

Question 18

Which report view's primary purpose is to allow you to modify report controls while reviewing live data?

Accepted Answer

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

Question 19

You can apply more than one grouping order to a report.

Accepted Answer

A) True 
 B)False

Question 20

Discuss the meanings of calculation, expression, function, and argument.

Accepted Answer

You create a calculation by entering an

Which report view's primary purpose is to review each page of the entire report as it will appear if printed?

-In the accompanying figure, item 4 points to the ____ View button.

A ____ box is an outline box you create by dragging the pointer in Report Design View.

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

The Report Wizard automatically applies many formatting embellishments to a report.

Which of the following is NOT a common report embellishment?

Koch labels are the most common manufacturer of labels, and therefore the default choice. _________________________

Which two sections can be added to a report if you group records?

Use the Group, Sort, and ____________________ pane to modify sort orders in Report Design View.

The Group Footer section prints ____.

Match each numbered item in the accompanying figure with its button name. -Alternate Row Color

One way to select more than one control at a time in Report Design View is to click a control and press and hold ____ while clicking other controls.

For your report to fit on one page in a given orientation, you may need to move all of the controls within a given mark on the horizontal ____.

Pressing the arrow keys while holding [Ctrl] moves selected controls one millimeter at a time in the direction of the arrow. _________________________

The Report Footer section prints ____.

Reports are view-only objects, meaning they can be used to read and display data but cannot be used to change data. _________________________

Which report view's primary purpose is to allow you to modify report controls while reviewing live data?

You can apply more than one grouping order to a report.

Discuss the meanings of calculation, expression, function, and argument.

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

Which report view's primary purpose is to review each page of the entire report as it will appear if printed?

-In the accompanying figure, item 4 points to the ____ View button.

A ____ box is an outline box you create by dragging the pointer in Report Design View.

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

The Report Wizard automatically applies many formatting embellishments to a report.

Which of the following is NOT a common report embellishment?

Koch labels are the most common manufacturer of labels, and therefore the default choice. _________________________

Which two sections can be added to a report if you group records?

Use the Group, Sort, and ____________________ pane to modify sort orders in Report Design View.

The Group Footer section prints ____.

Match each numbered item in the accompanying figure with its button name. -Alternate Row Color

One way to select more than one control at a time in Report Design View is to click a control and press and hold ____ while clicking other controls.

For your report to fit on one page in a given orientation, you may need to move all of the controls within a given mark on the horizontal ____.

Pressing the arrow keys while holding [Ctrl] moves selected controls one millimeter at a time in the direction of the arrow. _________________________

The Report Footer section prints ____.

Reports are view-only objects, meaning they can be used to read and display data but cannot be used to change data. _________________________

Which report view's primary purpose is to allow you to modify report controls while reviewing live data?

You can apply more than one grouping order to a report.

Discuss the meanings of calculation, expression, function, and argument.

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