Deck 5: Using Reports

Question 1

Which report view's primary purpose is to quickly review the report without page breaks?

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

Answer 1

D

Question 2

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

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

Answer 2

C

Question 3

Grouping means to sort records plus provide extra report sections.

Answer 3

True

Question 4

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

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

Question 5

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

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

Question 6

Calculated expressions start with an equal sign.

Question 7

In the accompanying figure, item 2 points to a Group Footer section.

Question 8

Which of the following is NOT a common report embellishment?

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

Question 9

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

Question 10

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

Question 11

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

Question 12

The Group Footer section prints ____.

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 13

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

Question 14

The tasks that can be accomplished by each of the various report views are mutually exclusive.

Question 15

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

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

Question 16

The purpose of a report is to provide an easy-to-use data entry interface.

Question 17

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

Question 18

Portrait orientation is 8.5" wide by 13" tall.

Question 19

You can rename labels in Report Layout View.

Question 20

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

Question 21

The Report Header section prints ____.

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 22

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

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

Question 23

In the accompanying figure, item 3 points to the ____ section.

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

Question 24

Which command is used to copy a control from one report section to another?

A) Move
B) Second
C) Duplicate
D) Copy

Question 25

In the accompanying figure, item 5 points to the ____.

A) Page number
B) Next Page button
C) Previous Page button
D) Last Page button

Question 26

The Group Header section prints ____.

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 27

Which command can you use to move a control from one section to another on a report?

A) Move
B) Place
C) Adjust
D) Cut

Question 28

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

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

Question 29

Which section prints once for every record?

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

Question 30

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

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

Question 31

The Page Header section prints ____.

A) at the top of the first page
B) at the top of every page (but below the Report Header on the first page)
C) before every group of records
D) after every group of records

Question 32

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

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

Question 33

Which of the following is NOT a method of selecting more than one control at a time in Report Design View?

A) Click a control, then [Shift]+click other controls
B) Dragging a selection box
C) Clicking in the ruler
D) Right-dragging

Question 34

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

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

Question 35

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

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

Question 36

The Report Footer section prints ____.

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 37

Which of the following is the correct expression to count the number of records using a field named City?

A) =Count([City])
B) =Count[City]
C) =Count(City)
D) =Count{City}

Question 38

Which section prints below the Report Header on page one?

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

Question 39

Which of the following shows a calculated expression using appropriate syntax to subtotal a field called Quantity?

A) =Sum(Quantity)
B) =Sum[Quantity]
C) =Sum{Quantity}
D) =Sum([Quantity])

Question 40

The Page Footer section prints ____.

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 41

Use the Align button on the DESIGN tab to align the edges of the controls with respect to one another. _________________________

Question 42

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

Question 43

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

Question 44

The quick keystroke for Redo is [Ctrl][Z]. _________________________

Question 45

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

Question 46

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

Question 47

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

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

Question 48

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.

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

Question 49

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

Question 50

[Ctrl][Y] is the quick keystroke for the ____________________ command.

Question 51

____ refers to enhancing the appearance of the information.

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

Question 52

Use the alignment buttons on the ____________________ tab to align the content of a control within its own border.

Question 53

Tables, queries, forms, and reports can all be printed, but reports provide more sophisticated printing capabilities. What central feature of tables, queries, and forms is not shared by reports?

Question 54

____________________ orientation is 11" wide by 8.5" tall.

Question 55

In the expression =Sum([Price]), the ____________________ function is used.

Question 56

____________________ orientation is 8.5" wide by 11" tall.

Question 57

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

Question 58

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

Question 59

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

Question 60

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

Question 61

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?

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

Question 62

Match each numbered item in the accompanying figure with its button name.
a.Item 1
e.Item 5
b.Item 2
f.Item 6
c.Item 3
g.Item 7
d.Item 4
h.Item 8
Alternate Row Color

Question 63

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?

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

Question 64

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 wants to focus on just the details of one of the reports, without seeing the data. Which of the following should he use?

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

Question 65

Match each numbered item in the accompanying figure with its button name.
a.Item 1
e.Item 5
b.Item 2
f.Item 6
c.Item 3
g.Item 7
d.Item 4
h.Item 8
Font Color

Question 66

Match each numbered item in the accompanying figure with its button name.
a.Item 1
e.Item 5
b.Item 2
f.Item 6
c.Item 3
g.Item 7
d.Item 4
h.Item 8
Align Left

Question 67

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

Question 68

Match each numbered item in the accompanying figure with its button name.
a.Item 1
e.Item 5
b.Item 2
f.Item 6
c.Item 3
g.Item 7
d.Item 4
h.Item 8
Underline

Question 69

Match each numbered item in the accompanying figure with its button name.
a.Item 1
e.Item 5
b.Item 2
f.Item 6
c.Item 3
g.Item 7
d.Item 4
h.Item 8
Align Right

Question 70

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

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

Question 71

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

Question 72

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 ready to print his report, but he only wants to print specific pages of the report. On what tab can he find the options to accomplish this task?

A) PRINT PREVIEW
B) PRINT OPTIONS
C) SELECTION
D) TOOLS

Question 73

Match each numbered item in the accompanying figure with its button name.
a.Item 1
e.Item 5
b.Item 2
f.Item 6
c.Item 3
g.Item 7
d.Item 4
h.Item 8
Background Color or Shape Fill

Question 74

Match each numbered item in the accompanying figure with its button name.
a.Item 1
e.Item 5
b.Item 2
f.Item 6
c.Item 3
g.Item 7
d.Item 4
h.Item 8
Center

Question 75

Match each numbered item in the accompanying figure with its button name.
a.Item 1
e.Item 5
b.Item 2
f.Item 6
c.Item 3
g.Item 7
d.Item 4
h.Item 8
Shape Outline