32)
A(n) ________ inserts the page number when a report is displayed in Print Preview or is
printed.
32)
Answer:
page number control
Explanation:
33)
The actual typing of information into the records is known as ________ entry.
33)
Answer:
data
Explanation:
34)
The tables or queries from which a report’s data is taken are known as the ________.
34)
Answer:
record source
Explanation:
35)
The ________ creates an instant form in a simple top–to–bottom layout with all the fields
lined up in a single column.
35)
Answer:
Form tool
Explanation:
36)
The queries or tables that provide the underlying data for a report are the ________.
36)
Answer:
record source
Explanation:
37)
To apply a theme only to the current object, ________ the Theme name.
37)
Answer:
right–click
Explanation:
38)
A(n) ________ inserts the current date each time a report is opened.
38)
Answer:
date control
Explanation:
39)
Displaying a subset of records based on matching specific values is known as ________.
39)
Answer:
filtering
Explanation:
40)
A(n) ________ in a form is a grouped arrangement of controls.
40)
Answer:
control layout
Explanation:
41)
When placing a bound control such as a text box onto a form, Access places a(n) ________
control to the left, which contains descriptive information about the control.
41)
Answer:
label
Explanation:
42)
In the Group, Sort, and Total pane, when asking for “with A on top” results in a(n)
________ sort.
42)
Answer:
ascending
Explanation:
7
43)
________ layout in an Access form is similar to a paper form, with labels to the left of each
field.
43)
Answer:
Stacked
Explanation:
44)
The ________ condition means that both conditions must be true for a record to be
displayed.
44)
Answer:
AND
Explanation:
45)
The order in which the insertion point moves from one field to the next when the Tab key
is pressed is known as the ________ order.
45)
Answer:
tab
Explanation:
46)
To create a report without predefined labels or fields, use the ________ tool.
46)
Answer:
Blank Report
Explanation:
47)
Precise changes to the characteristics of a particular control can be made in the associated
________ Sheet.
47)
Answer:
Property
Explanation:
48)
Objects in a form that display data or perform actions are called ________.
48)
Answer:
controls
Explanation:
49)
Match the following terms to their meanings:
I. Unbound control A. most commonly used control
II. Label control B. where precise changes to characteristics of controls
are made
III. Text Box control C. has no source of data
IV. Property Sheet D. descriptive information, usually a field name
49)
Answer:
C, D, A, B
Explanation:
50)
If you do not summarize data in a report, the ________ Footer does not display.
50)
Answer:
Group
Explanation:
51)
If a control on a form doesn’t have a source of data , it is a(n) ________ control.
51)
Answer:
unbound
Explanation:
8
52)
Match the following terms to their meanings:
I. Filter by Form A. applies or removes a filter
II. Subset B. a portion of the total records
III. Advanced Filter/Sort C. matches selected value in selected field
IV. Filter by Selection D. has design grid similar to a query
V. Toggle Filter E. filters records in a form based on one or more
fields, or on more than one value in the same field
52)
Answer:
E, B, D, C, A
Explanation:
53)
Match the following terms to their meanings:
I. Report Header A. displays information at the bottom of every page of
a report
II. Page Footer B. displays information at the top of every page of
a report
III. Page Header C. displays the field label by which the data has been
grouped
IV. Group Header D. displays information at the top of the first page of
a report
53)
Answer:
D, A, B, C
Explanation:
54)
To view data while making changes to a form, use ________ view.
54)
Answer:
Layout
Explanation:
55)
A detailed view of the structure of a form is given in ________ view.
55)
Answer:
Design
Explanation:
TRUE/FALSE. Write ‘T’ if the statement is true and ‘F’ if the statement is false.
56)
The Report tool will automatically adjust the size of fields within headers and footers to fit onto one
page.
56)
Answer:
True
False
Explanation:
57)
Access forms typically are not printed.
57)
Answer:
True
False
Explanation:
58)
When entering new information into a field, the record selector displays a hand with a finger
pointing to the current record being entered.
58)
Answer:
True
False
Explanation:
59)
Forms are only capable of displaying a single record at a time.
59)
Answer:
True
False
Explanation:
9
60)
Section bars designate the various sections of a form in Design view.
60)
Answer:
True
False
Explanation:
61)
To see how information is grouped, sorted, or totaled, Design view is the preferred view.
61)
Answer:
True
False
Explanation:
62)
A single record in a form can be printed to .pdf (Adobe Acrobat) format.
62)
Answer:
True
False
Explanation:
63)
A report can include a summary line that details what is being summarized and the number of
records being included in the summary total.
63)
Answer:
True
False
Explanation:
64)
Two controls normally found in a Report Footer are the date control and the page number control.
64)
Answer:
True
False
Explanation:
65)
Text boxes and their label controls must be formatted together.
65)
Answer:
True
False
Explanation:
66)
Use the Report Wizard when you want to control the report’s content and design.
66)
Answer:
True
False
Explanation:
67)
Themes cannot be applied to a single database object.
67)
Answer:
True
False
Explanation:
68)
Forms can be used to control access to data.
68)
Answer:
True
False
Explanation:
69)
The choice of a theme should precede other formatting choices.
69)
Answer:
True
False
Explanation:
70)
Sorting in a report can be done on up to three fields.
70)
Answer:
True
False
Explanation:
71)
The Report tool generates a report by displaying all records and all fields from the selected record
source.
71)
Answer:
True
False
Explanation:
10
72)
Report modifications need to be made in Design view.
72)
Answer:
True
False
Explanation:
73)
A form’s control layout can only be altered in Design view.
73)
Answer:
True
False
Explanation:
74)
Forms are bound to the table in which the records are stored.
74)
Answer:
True
False
Explanation:
75)
A truncated field is one that is narrowed because the field size is too small.
75)
Answer:
True
False
Explanation:
76)
Access forms can be used to enter or edit data, but not to delete data.
76)
Answer:
True
False
Explanation:
77)
Access forms can be laid out to follow existing paper forms.
77)
Answer:
True
False
Explanation:
78)
The Blank Report tool is most efficient when your table contains lots of fields.
78)
Answer:
True
False
Explanation:
79)
Different themes can be applied to various objects within a database.
79)
Answer:
True
False
Explanation:
80)
Forms can only be modified in Layout view.
80)
Answer:
True
False
Explanation:
81)
The Form tool creates a form displaying all fields from the underlying data source.
81)
Answer:
True
False
Explanation:
82)
Advanced Filter allows the OR condition.
82)
Answer:
True
False
Explanation:
83)
The margins and page breaks in a report are only viewable in a report’s Design view.
83)
Answer:
True
False
Explanation:
11
84)
Forms based on a single table cannot display information from other related tables.
84)
Answer:
True
False
Explanation:
85)
Filter by Selection can only be used in a single field.
85)
Answer:
True
False
Explanation:
86)
Filter by Selection allows filters based on multiple values in the same field.
86)
Answer:
True
False
Explanation:
87)
Both the Find and Replace commands can be utilized within forms.
87)
Answer:
True
False
Explanation:
88)
The Report and Group Headers are printed at the top of every page of the report.
88)
Answer:
True
False
Explanation:
89)
The “keep whole group together on one page” command keeps everything between the group
header and the group footer on one page.
89)
Answer:
True
False
Explanation:
12