True/False
Indicate whether the sentence or statement is true
or false.
|
|
|
1.
|
Data from a
report cannot be displayed on the screen.
|
|
|
2.
|
Access
reports can be based on either a table or query object.
|
|
|
3.
|
Reports can
include clip art.
|
|
|
4.
|
You cannot
enter or edit data through a report.
|
|
|
5.
|
Grouping
means to sort records plus provide extra report sections.
|
|
|
6.
|
When using a
wizard, you can click the Back button to review previous dialog boxes.
|
|
|
7.
|
You can base
a report on a query object.
|
|
|
8.
|
Once a
report is created, you cannot change the way the records are grouped.
|
|
|
9.
|
Once a
report is created, you cannot change the way the records are subtotaled.
|
|
|
10.
|
If you
double-click the edge of a control, you automatically delete it.
|
|
|
11.
|
Calculated
expressions within text boxes start with an equal sign.
|
|
|
12.
|
When
entering an expression, the field name must be referenced exactly and surrounded by square
brackets.
|
|
|
|
|
|
13.
|
In the
figure above, item 8 points to a Group Footer section.
|
|
|
14.
|
In Report
Design View, when you drag a field from the Field List to the report, only a label control is
created.
|
|
|
15.
|
You can sort
records within groups.
|
|
|
16.
|
You can
modify controls that contain calculated expressions.
|
|
|
17.
|
Press and
hold the [Ctrl] key while pressing the arrow keys to resize a selected control.
|
|
|
18.
|
You can use
both the horizontal and vertical rulers to select controls.
|
|
|
19.
|
If you try
to print colors on a black and white printer, the printer will display an error message indicating
that it cannot print color.
|
|
|
20.
|
You use the
Toolbox toolbar to apply formatting changes to a report.
|
|
|
21.
|
The Report
Wizard applies many formatting choices to a report.
|
|
|
|
|
|
22.
|
In the
figure above, item 5 refers to the Line/Border Color button.
|
|
|
23.
|
In the
figure above, item 4 refers to the Align Left Edges of Several Controls button.
|
|
|
24.
|
In the
figure above, the Bold button is a toggle button.
|
|
|
25.
|
In the
figure above, item 1 refers to the Bold button.
|
|
|
26.
|
In the
figure above, to change the line color of the selected control, click the button identified as item
8.
|
|
|
27.
|
In the
figure above, to change the style of the border of the selected control, click the button identified
as item 7.
|
|
|
28.
|
In the
figure above, to change the color of the text of selected label, click the button labeled item
6.
|
|
|
29.
|
Portrait
orientation is 8.5" wide by 11" tall.
|
|
|
30.
|
Landscape
orientation is 11" wide by 8.5" tall.
|
|
|
31.
|
The
horizontal ruler in Report Design View tells you the width of the paper you have
selected.
|
|
|
32.
|
By default,
the margins of an Access report are 1".
|
Multiple Choice
Identify the
letter of the choice that best completes the statement or answers the question.
|
|
|
33.
|
Which of the
following are common report embellishments? a. | Headers | b. | Footers | c. | Calculations on groups of records | d. | All of the
above | | |
|
|
|
34.
|
Text boxes
bound to underlying fields are generally placed in this report section. a. | Group
Header | b. | Group Footer | c. | Report
Header | d. | Detail | | |
|
|
|
35.
|
Which of the
following is NOT a common use for an Access report? a. | To communicate
information at meetings | b. | To communicate information to outsiders | c. | To group and summarize
records | d. | To enter and update data | | |
|
|
|
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 | | |
|
|
|
37.
|
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 | | |
|
|
|
38.
|
The Detail
section prints ____. a. | At the top of the first page of the report | b. | At the bottom of the
every page | c. | At the end of the entire report | d. | Once for every
record | | |
|
|
|
39.
|
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 | | |
|
|
|
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 | | |
|
|
|
41.
|
Which
control is most commonly placed in the Report Header section? a. | Text
box | b. | Subtotal | c. | Check box | d. | Label | | |
|
|
|
42.
|
Which
control is most commonly placed in the Detail section of a report? a. | Label | b. | Subtotal | c. | Text box | d. | Command button | | |
|
|
|
43.
|
A text box
control bound to the field by which the records are grouped would most likely be found in which
report section? a. | Report
Header | b. | Page Header | c. | Detail | d. | Group Header | | |
|
|
|
44.
|
A text box
control that contained a calculated expression such as a subtotal or count would most likely be found
in which report section? a. | Report Header | b. | Page
Header | c. | Page Footer | d. | Group Footer | | |
|
|
|
45.
|
Which
section would most likely contain page number and date expressions? a. | Report
Header | b. | Group Header | c. | Detail | d. | Page Footer | | |
|
|
|
46.
|
Which
section prints below the Report Header on page one? a. | Report
Header | b. | Page Header | c. | Page Footer | d. | Report Footer | | |
|
|
|
47.
|
A text box
control that contained a grand total for all records would most likely be found in which report
section? a. | Group
Header | b. | Detail | c. | Report Footer | d. | Page
Footer | | |
|
|
|
48.
|
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 page one) | c. | Before every group of
records | d. | After every group of records | | |
|
|
|
49.
|
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 | | |
|
|
|
50.
|
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]) | | |
|
|
|
51.
|
Which of the
following buttons is NOT a toggle button within Report Design View? a. | AutoFormat | b. | Field List | c. | Toolbox | d. | Properties | | |
|
|
|
52.
|
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 | | |
|
|
|
|
|
|
53.
|
In the
figure above, the information identified as item 2 would most likely be found in which report
section? a. | Report
Header | b. | Group Header | c. | Group
Footer | d. | Report Footer | | |
|
|
|
54.
|
In the
figure above, the information identified as item 1 is most likely found in which report
section? a. | Group
Header | b. | Report Footer | c. | Page
Footer | d. | Detail | | |
|
|
|
55.
|
In the
figure above, the information identified as item 3 would most likely be found in which report
section? a. | Page
Header | b. | Group Header | c. | Detail | d. | Report Footer | | |
|
|
|
56.
|
In the
figure above, the information identified as item 4 would most likely be found in which report
section? a. | Page
Header | b. | Group Header | c. | Detail | d. | Group Footer | | |
|
|
|
57.
|
In the
figure above, what type of control is most likely found in the section identified as item
4? a. | Text
box | b. | Label | c. | Unbound | d. | Calculated | | |
|
|
|
|
|
|
58.
|
In the
figure above, item 5 points to the ____ button. a. | Sorting and Grouping | b. | Toolbox | c. | Label | d. | Text Box | | |
|
|
|
59.
|
In the
figure above, item 6 points to the ____ button. a. | Sections | b. | Sorting and Grouping | c. | Controls | d. | Toolbox | | |
|
|
|
60.
|
In the
figure above, item 7 points to the ____ button. a. | Properties | b. | Formatting | c. | Toolbox | d. | Grouping | | |
|
|
|
61.
|
In the
figure above, item 4 points to the ____ button. a. | Preview | b. | Field List | c. | Properties | d. | Sorting and Grouping | | |
|
|
|
62.
|
In the
figure above, item 2 points to a label in which section? a. | Group
Header | b. | Detail | c. | Page Footer | d. | Report Header | | |
|
|
|
63.
|
In the
figure above, item 3 points to a ____. a. | Text box | b. | Label | c. | List box | d. | Toolbox | | |
|
|
|
64.
|
In the
figure above, item 1 points to a(n) ____. a. | Section | b. | Expression | c. | Option button | d. | Group | | |
|
|
|
65.
|
The Group
Header and Group Footer section can be turned on or off in which dialog box? a. | Properties | b. | Field List | c. | Toolbox | d. | Sorting and Grouping | | |
|
Completion
Complete each sentence or
statement.
|
|
|
66.
|
A(n)
____________________ is an Access object whose primary purpose is to create professional
printouts.
|
|
|
67.
|
The
____________________ Wizard can help you create an initial report object that you can later
modify.
|
|
|
68.
|
The term
____________________ refers to sorting records plus providing a section before and after the group of
records.
|
|
|
69.
|
The report
section before a group of records is called the Group ____________________ section.
|
|
|
70.
|
The section
after a group of records is called the Group ____________________ section.
|
|
|
71.
|
Text boxes
that display data in underlying records are generally placed in a report's ____________________
section.
|
|
|
72.
|
The Detail
section prints once for every ____________________.
|
|
|
73.
|
The
____________________ Wizard asks questions that guide you through the initial development of the
report.
|
|
|
74.
|
In Report
Design View, you can click a control, and then click the ____________________ button to view its
property sheet.
|
|
|
75.
|
You make all
structural changes to a report in the object's ____________________ View.
|
|
|
76.
|
In Print
Preview, click the ____________________ pointer to quickly toggle between two different
magnifications.
|
|
|
77.
|
A(n)
____________________ is a built-in formula provided by Access that helps you quickly create a
calculated expression.
|
|
|
78.
|
In a report,
you create a(n) ____________________ by entering an expression into an unbound text
box.
|
|
|
79.
|
A(n)
____________________ is a combination of field names, operators (such as +, -, /, and *), and
functions that result in a single value.
|
|
|
80.
|
Arguments
for a function are placed in ____________________.
|
|
|
81.
|
Every
calculated expression starts with a(n) ____________________ sign.
|
|
|
82.
|
Calculated
expressions are entered in ____________________ box controls.
|
|
|
83.
|
____________________ are the pieces of information that the function needs in order to
create a final answer.
|
|
|
84.
|
To align
controls with respect to one another, use the Align command on the ____________________
menu.
|
|
|
85.
|
If you make
a mistake in Form Design View, click the ____________________ button to reverse your last
action.
|
|
|
86.
|
The Redo
option is found on the ____________________ menu.
|
|
|
87.
|
[Ctrl][Z] is
the quick keystroke for the ____________________ command.
|
|
|
88.
|
In the
expression =Sum([Price]), the ____________________ function is used.
|
|
|
89.
|
[Ctrl][Y] is
the quick keystroke for the____________________ command.
|
|
|
90.
|
The
Fill/Back ____________________ button changes the background color of the selected
control(s).
|
|
|
91.
|
There are
two different types of ____________________ commands that help you align a control within its own
border or with respect to the edges of other controls.
|
|
|
92.
|
____________________ refers to enhancing the appearance of the information on a
report.
|
|
|
|
|
|
93.
|
In the
figure above, the button identified as item 2 is the ____________________ button.
|
|
|
94.
|
In the
figure above, the button identified as item 3 is called the ____________________
button.
|
|
|
95.
|
In the
figure above, the button identified as item 4 is the Align ____________________ button.
|
|
|
96.
|
In the
figure above, the button identified as item 8 is the Line/Border ____________________
button.
|
|
|
97.
|
Paper
orientation that is 11" wide by 8.5" tall is referred to as ____________________
orientation.
|