Multiple Choice
Identify the
letter of the choice that best completes the statement or answers the question.
|
|
|
1.
|
The
process of creating separate collections of records sharing some characteristic is known as
__________. a. | collecting | c. | sorting | b. | matching | d. | grouping | | | | |
|
|
|
2.
|
To
create a report from scratch, use __________ instead of the Report Wizard. a. | Layout
view | c. | Design
view | b. | Print
Preview | d. | New
view | | | | |
|
|
|
3.
|
Use
__________ to modify the design (layout) of the report. a. | Modify
view | c. | Layout
view | b. | Design
view | d. | Template
view | | | | |
|
|
|
4.
|
To
move from Design view to Print Preview, click the __________ button on the Report Design
toolbar. a. | Print
Preview | c. | View
Data | b. | View
Layout | d. | Preview
Report | | | | |
|
|
|
|
|
|
5.
|
The
portions of the Report window (for example, Page Header, Detail) that display in the accompanying
figure are called __________. a. | slices | c. | sections | b. | areas | d. | segments | | | | |
|
|
|
6.
|
The
Properties command that displays in the accompanying figure will display a(n) __________, which is a
list of properties for a control that can be modified. a. | control
list | c. | property
inspector | b. | object list | d. | property sheet | | | | |
|
|
|
7.
|
As
shown in the accompanying figure, the controls in the Page Header section serve as __________ for the
data. a. | captions | c. | placeholders | b. | braces | d. | selectors | | | | |
|
|
|
8.
|
To
spread data over two lines in a report, change the __________ property from No to
Yes. a. | Enlarge | c. | Expand | b. | Can Grow | d. | Magnify | | | | |
|
|
|
9.
|
To
print a report, right-click the report in the Database window, and then click __________ on the
shortcut menu. a. | Setup | c. | Print | b. | Display | d. | View | | | | |
|
|
|
10.
|
To
remove a control from a report, select the control and press the _________ key(s). a. | CTRL+DELETE | c. | CTRL+D | b. | DELETE | d. | CTRL+Y | | | | |
|
|
|
11.
|
To
remove unwanted controls, right-click the report in the Database window, and then click __________ on
the shortcut menu. a. | Design View | c. | Page View | b. | Layout
View | d. | Normal
View | | | | |
|
|
|
12.
|
To
add a calculated control to a report, use the __________ tool in the toolbox. a. | Calculated
Control | c. | Bound Field
Control | b. | Text Box | d. | Field | | | | |
|
|
|
13.
|
On a
custom form, controls that are used to display data that comes from a database are called __________
controls. a. | data | c. | field | b. | bound | d. | unbound | | | | |
|
|
|
14.
|
Controls used to display such things as the form’s title are called _________
controls. a. | external | c. | outside | b. | text | d. | unbound | | | | |
|
|
|
15.
|
Controls used to display data such as total amount, which is calculated by adding the
amount paid and current due amounts, are called __________ controls. a. | tabulated | c. | computed | b. | calculated | d. | defined | | | | |
|
|
|
16.
|
To
remove an attached label, click the label and then press the __________ key(s). a. | CTRL+DELETE | c. | DELETE | b. | CTRL+D | d. | CTRL+Y | | | | |
|
|
|
17.
|
To
add a new field to a form, click the __________ tool in the toolbox. a. | Field
Box | c. | Object
Box | b. | Text
Box | d. | Control
Box | | | | |
|
|
|
18.
|
When
you create a calculated control, field names used in the expression must be enclosed in
__________. a. | parentheses (
) | c. | brackets [
] | b. | curly braces {
} | d. | single quotes
‘ ‘ | | | | |
|
|
|
19.
|
To
place a combo box, a box that allows a user to select entries from a list, use the __________ tool in
the toolbox. a. | Text
Box | c. | Value
Box | b. | List
Box | d. | Combo
Box | | | | |
|
|
|
20.
|
To
add a title to a form, use the __________ tool in the toolbox. a. | Title | c. | Label | b. | Unbound | d. | Text | | | | |
|
|
|
21.
|
To
change the color of a label, change the __________ property on the property sheet. a. | Color | c. | Back
Color | b. | Shade | d. | Hue | | | | |
|
|
|
22.
|
To
make a label appear to be raised from the screen, change the __________ property on the property
sheet. a. | Special
Effects | c. | Visual | b. | Border | d. | Frame | | | | |
|
|
|
23.
|
To
change the font size of a label, change the __________ property on the property
sheet. a. | Text
Size | c. | Point
Size | b. | Font
Size | d. | Type
Size | | | | |
|
|
|
24.
|
To
bypass a control when tabbing through the controls on a form, change the __________ property for the
control from Yes to No. a. | Bypass | c. | Tab Stop | b. | Stop | d. | Skip | | | | |
|
|
|
25.
|
To
open a form, right-click the form in the Database window, and then click __________ on the shortcut
menu. a. | Open | c. | Display | b. | View | d. | Data View | | | | |
|
True/False
Indicate whether the sentence or statement is true
or false.
|
|
|
26.
|
Classifying means creating separate collections of records that share some common
characteristic.
|
|
|
27.
|
A
combo box is a box that allows a user to select entries from a list.
|
|
|
28.
|
To
create a very simple report that includes all fields and records in a table, use
AutoReport.
|
|
|
29.
|
Either a table or a query can form the basis for a report.
|
|
|
30.
|
Within the Report Window, there are two different possible views: Layout view and
Design view.
|
|
|
31.
|
Use
View Report to view a report with sample data.
|
|
|
32.
|
Use
Design view to modify the design (layout) of the report.
|
|
|
33.
|
To
move from Design view to Print Preview, click the Print Preview button on the Report Design
toolbar.
|
|
|
34.
|
To
dock the toolbox in a different location on the Report Design window, drag the title bar of the
toolbox to one of the edges of the window.
|
|
|
35.
|
To
remove the toolbox from the Report Design window and return it to the screen when needed, click the
My Tools button on the Report Design toolbar.
|
|
|
36.
|
To
view multiple pages at the same time when previewing a report, click the Multiple Pages button on the
Print Preview toolbar, and then click the number of pages to view.
|
|
|
37.
|
The
portions of the Report window (for example: Page Header, Detail, and Page Footer) are called
sections.
|
|
|
38.
|
The
contents of the Page Footer will print once, at the end of the report.
|
|
|
39.
|
Another common term for the sections in a report is segment.
|
|
|
40.
|
The
contents of the Detail section print once for each record in the table.
|
|
|
41.
|
The
contents of the Page Header will print once at the top of each page.
|
|
|
42.
|
The
controls in the Report Header section serve as captions for the data in a report.
|
|
|
43.
|
The
Report window uses small squares called grippers to indicate which portion of the report currently is
selected.
|
|
|
44.
|
You
can move, resize, modify, and delete a control.
|
|
|
45.
|
The
object list is a list of properties for a control that can be modified.
|
|
|
46.
|
To
produce the property sheet, right-click the desired control and then click Properties on the shortcut
menu.
|
|
|
47.
|
To
spread data over two lines in a report, change the Can Grow property from No to Yes.
|
|
|
48.
|
To
print a report, right-click the report in the Database window, and then click Print on the shortcut
menu.
|
|
|
49.
|
In
grouping, reports typically include one additional type of section and that is a group
footer.
|
|
|
50.
|
If
you create a customer report grouped on city, the group header for the report will print once for
each different city in the table.
|
|
|
51.
|
A
subtotal for a report appears in the group footer.
|
|
|
52.
|
To
remove a control that should not be included in a report, select the control and press
CTRL+D.
|
|
|
53.
|
To
remove unwanted controls, right-click the report in the Database window and click Design View on the
shortcut menu.
|
|
|
54.
|
To
enlarge the Page Header section, drag the bottom edge of the Page Header section down.
|
|
|
55.
|
To
split a column heading over two lines, place the insertion point at the position where the heading
should be split, and then press SHIFT+ENTER.
|
|
|
56.
|
To
select multiple controls, click the first control and then hold down the CTRL key and click each of
the other controls.
|
|
|
57.
|
To
preview a report from the Database window, right-click the report and then click Data View on the
shortcut menu.
|
|
|
58.
|
To
add a calculated control to a report, use the Text Box tool in the toolbox.
|
|
|
59.
|
To
create a very simple form that includes all fields in the table or query, use AutoForm.
|
|
|
60.
|
To
modify the design of an existing form, right-click the form in the Database window and then click
Layout View on the shortcut menu.
|
|
|
61.
|
The
three types of controls on a form are bound controls, external controls, and calculated
controls.
|
|
|
62.
|
Bound
controls are used to display data that comes from the database.
|
|
|
63.
|
Unbound controls have attached labels that typically display the name of the field
that furnishes the data for the control.
|
|
|
64.
|
Calculated controls are used to display data that is calculated from data in the
database.
|
|
|
65.
|
To
remove an attached label, click the label and then press the DELETE key.
|
|
|
66.
|
To
add a new field to a form, click the Label tool in the toolbox.
|
|
|
67.
|
When
you create a calculated control, field names used in the expression must be enclosed in curly braces
{ }.
|
|
|
68.
|
To
deselect a control, click somewhere outside the control.
|
|
|
69.
|
To
change the format of a field, right-click the field and then click Format on the shortcut
menu.
|
|
|
70.
|
To
place a combo box, use the Combo Box tool in the toolbox.
|
|
|
71.
|
To
add a title to a form, use the Text Box tool in the toolbox.
|
|
|
72.
|
To
change the color of a label, right-click the label, click Properties on the shortcut menu, and then
change the Hue property.
|
|
|
73.
|
To
prevent a user from tabbing to a control, change the value of the Tab Stop property from Yes to
No.
|
|
|
74.
|
To
open a form from the Database window, right-click the form and then click View.
|
|
|
75.
|
If
the data that a user will enter comes from a paper form, make the screen form resemble the paper form
as closely as possible.
|
Matching
|
|
|
a. | grouping | n. | property
sheet | b. | combo box | o. | properties | c. | report
wizard | p. | can
grow | d. | print
preview | q. | print | e. | close | r. | group header, group footer | f. | sections | s. | SHIFT+ENTER | g. | page footer | t. | design view | h. | detail | u. | back
color | i. | report footer | v. | label | j. | report
header | w. | unbound | k. | captions | x. | text box | l. | band | y. | brackets | m. | sizing handles | z. | format | | | | |
|
|
|
76.
|
means
creating separate collections of records that share some common characteric
|
|
|
77.
|
to
change the format of a field, change the _____ property on the property sheet.
|
|
|
78.
|
when
you create a calculated control, field names used in the expression must be enclosed in
_____.
|
|
|
79.
|
a(n)
_____ is a box that allows a user to select entries from a list.
|
|
|
80.
|
the
simplest way to create a report design is to use the
|
|
|
81.
|
to
add a new field to a form, click the _____ tool in the toolbox.
|
|
|
82.
|
on a
custom form such as that shown in the accompanying figure, controls that are not associated with data
in a database are called _____ controls.
|
|
|
83.
|
within the report windows, there are two different possible views: design view
and _____.
|
|
|
84.
|
to
move from print preview to design view, click the _____ button on the print preview
toolbar.
|
|
|
85.
|
to
add a title to a form, use the _____ tool in the toolbox.
|
|
|
86.
|
to
change the color of a label, change the _____ property on the property sheet.
|
|
|
87.
|
the
portions of the report window (for example, page header and detail) are called _____.
|
|
|
88.
|
The
contents of the _____ section will print once, at the bottom of each page.
|
|
|
89.
|
to
modify the design of an existing form, right-click the form in the database window, and then click
_____ on the shortcut menu.
|
|
|
90.
|
to
split a column heading over two lines, place the insertion point at the position where the heading
should be split, and then press the _____ key(s).
|
|
|
91.
|
the
contents of the _____ section will print once for each record in the table.
|
|
|
92.
|
the
contents of the _____ section will print once at the end of the report.
|
|
|
93.
|
in
grouping, reports typically include two additional types of sections: a(n) _____ and a(n)
_____.
|
|
|
94.
|
to
print a report, right-click the report in the database window, and then click _____ on the shortcut
menu.
|
|
|
95.
|
the
contents of the _____ section will print once at the beginning of the report.
|
|
|
96.
|
the
controls in the page header section of a report server as ______ for the data.
|
|
|
97.
|
to
spread data over two lines in areport, change the _____ property from No to Yes.
|
|
|
98.
|
to
produce the property sheet, right-click the desired control and then click _____ on the shortcut
menu.
|
|
|
99.
|
the
report window uses small squares called _____ to move or resize a control.
|
|
|
100.
|
the
_____ is a list of properties for a control that can be modified.
|
|
|
101.
|
another common term for the sections in a report is _____.
|