Question 1

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

Accepted Answer

A) True 
 B)False  True

Question 2

The quick keystroke for Undo is _____.

Accepted Answer

A)   [Ctrl][W]
B)   [Ctrl][Y]
C)   [Ctrl][X]
D)   [Ctrl][Z] D

Question 3

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 D

Question 4

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 5

Critical Thinking Questions Case 4-1
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

Question 6

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

Accepted Answer

The answer of What are the steps to add a...

Question 7

In Report Layout View, you can work with sections and make modifications that you cannot make in other views.

Accepted Answer

A) True 
 B)False

Question 8

The Mailing Wizard is a special report wizard that precisely positions and sizes information for hundreds of standard business labels. _________________________

Accepted Answer

A) True 
 B)False

Question 9

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

Question 10

Critical Thinking Questions Case 4-1
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.
Which of the following will Bradley use if he is looking for the optimal view for changing the positioning of some of his report controls while also reviewing the live data?

Accepted Answer

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

Question 11

Access reports can be created by selecting fields from one or more tables or queries.

Accepted Answer

A) True 
 B)False

Question 12

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

Accepted Answer

A) True 
 B)False

Question 13

____________________ orientation is 11" wide by 8.5" tall.

Accepted Answer

The answer of ____________________ orientation is 11" wide by 8.5"...

Question 14

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 15

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

Question 16

In Report Design View, you can click in the ____________________ to select all controls that intersect the selection line.

Accepted Answer

The answer of In Report Design View, you can click...

Question 17

To quickly review a report without page breaks use ____________________ View.

Accepted Answer

The answer of To quickly review a report without page...

Question 18

When using a wizard, you can click the Back button to review previous dialog boxes.

Accepted Answer

A) True 
 B)False

Question 19

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]

Question 20

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

Exam 4: Using Reports

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

The quick keystroke for Undo is _____.

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

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

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

In Report Layout View, you can work with sections and make modifications that you cannot make in other views.

The Mailing Wizard is a special report wizard that precisely positions and sizes information for hundreds of standard business labels. _________________________

The Report Footer section prints ____.

Access reports can be created by selecting fields from one or more tables or queries.

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

____________________ orientation is 11" wide by 8.5" tall.

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

The Group Footer section prints ____.

In Report Design View, you can click in the ____________________ to select all controls that intersect the selection line.

To quickly review a report without page breaks use ____________________ View.

When using a wizard, you can click the Back button to review previous dialog boxes.

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.

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