Exam
Name___________________________________
MULTIPLE CHOICE. Choose the one alternative that best completes the statement or answers the question.
1)
To view report data while making changes to a report, use
1)
A)
Datasheet view.
B)
Layout view.
C)
Form view.
D)
Design view.
Answer:
Explanation:
A)
B)
C)
D)
2)
When a filter is active, which of the following is NOT true?
2)
A)
On the Home tab, in the Sort and Filter group, the Toggle Filter button is active.
B)
The word “Filtered” appears on the right side of the status bar.
C)
A Filtered button displays next to the number of records.
D)
A small funnel appears to the right of the database name in the title bar.
Answer:
Explanation:
A)
B)
C)
D)
3)
Resizing sections in a form must be done in
3)
A)
Form view.
B)
Design view.
C)
Layout view.
D)
Datasheet view.
Answer:
Explanation:
A)
B)
C)
D)
4)
Which is NOT true concerning forms?
4)
A)
Every table must have at least one form.
B)
They are used for data entry.
C)
They can show one or multiple records at a time.
D)
They can be used to control access to the database.
Answer:
Explanation:
A)
B)
C)
D)
1
5)
Which of the following would NOT be considered a design modification of a report?
5)
A)
Change the table on which the report is based.
B)
Add or remove controls.
C)
Change the format of controls.
D)
Change the placement of controls in a report.
Answer:
Explanation:
A)
B)
C)
D)
6)
The Report Wizard
6)
A)
is less user friendly than the Report Design tool.
B)
does not allow the use of fields from more than one table.
C)
enables you to specify how the report data is grouped and sorted.
D)
asks questions, then suggests ways to design the report manually.
Answer:
Explanation:
A)
B)
C)
D)
7)
To print just one record from a form, which of the following would you choose in the Print dialog
box?
7)
A)
the All option
B)
the Print Range option
C)
the Page Setup button
D)
the Selected Record(s) option
Answer:
Explanation:
A)
B)
C)
D)
8)
In Layout view, the ________ is a small symbol displayed in the upper left corner used to move the
entire group of controls.
8)
A)
layout control
B)
layout handle
C)
layout selector
D)
label handle
Answer:
Explanation:
A)
B)
C)
D)
9)
The OR condition
9)
A)
is only used within filters (not queries).
B)
can only be used in combination with the AND condition.
C)
displays records that meet either of two criteria.
D)
can only be used with nonnumeric data.
Answer:
Explanation:
A)
B)
C)
D)
2
10)
In Layout view, if the width of controls is insufficient to display all of the data, the field has been
10)
A)
controlled.
B)
accommodated.
C)
truncated.
D)
shortened.
Answer:
Explanation:
A)
B)
C)
D)
11)
Access forms can
11)
A)
not display only selected records using filtering.
B)
be based on multiple tables.
C)
display only one record at a time.
D)
only follow certain layouts, making matching printed forms more difficult.
Answer:
Explanation:
A)
B)
C)
D)
12)
Which of the following is NOT true regarding a report?
12)
A)
It can summarize the records in an easy–to–read format.
B)
It can be based on a table.
C)
It can be based on another report.
D)
It can be based on a query.
Answer:
Explanation:
A)
B)
C)
D)
13)
When a field is too narrow to display numeric information, the data displays as
13)
A)
truncated numbers.
B)
dollar signs.
C)
dashes.
D)
pound signs.
Answer:
Explanation:
A)
B)
C)
D)
14)
Compared to the Form tool, the Form Wizard
14)
A)
also includes all fields in the underlying data source.
B)
can be used with unrelated multiple tables.
C)
allows more flexibility in the layout and design of the form.
D)
allows for headers, footers, and logos.
Answer:
Explanation:
A)
B)
C)
D)
3
15)
When viewing a report in Design view, which of the following is NOT a section name?
15)
A)
Form Footer
B)
Group Footer
C)
Page Header
D)
Report Header
Answer:
Explanation:
A)
B)
C)
D)
16)
A theme
16)
A)
affects the structure (i.e., file sizes, field names) as well as appearance of the objects.
B)
should be applied before doing other formatting to a form.
C)
can only be applied to all objects within a database.
D)
cannot be altered once chosen.
Answer:
Explanation:
A)
B)
C)
D)
17)
When you delete records in Access,
17)
A)
any records deleted by mistake must be reentered.
B)
you can use the Undo button to restore a record.
C)
a “many” table record may only be deleted if no related “one” record exists.
D)
Access displays no warning message.
Answer:
Explanation:
A)
B)
C)
D)
18)
Form Layout view differs from Design view in that
18)
A)
only Design view allows users to modify displayed field widths.
B)
Form Layout view offers more options for the form.
C)
only Form Layout view allows modifications while viewing data.
D)
Design view is easier for users to master.
Answer:
Explanation:
A)
B)
C)
D)
19)
Which of the following displays only records that contain the value in the selected field?
19)
A)
Filter by Value
B)
Filter by Selection
C)
Advanced Filter/Sort
D)
Filter by Form
Answer:
Explanation:
A)
B)
C)
D)
4
20)
Organizing and summarizing data in a report can be accomplished by
20)
A)
grouping data.
B)
adding a calculated field.
C)
adding a page footer.
D)
applying a theme.
Answer:
Explanation:
A)
B)
C)
D)
21)
Which of the following can display records based on values in one or more fields?
21)
A)
Filter by Selection
B)
Filter by Value
C)
Filter by Form
D)
Advanced Filter/Sort
Answer:
Explanation:
A)
B)
C)
D)
22)
Compared to Filter by Form, Filter by Selection
22)
A)
does not allow as much flexibility.
B)
can be used to filter several fields at the same time.
C)
allows filters that require matching multiple values.
D)
can be used for more than one value in the same field.
Answer:
Explanation:
A)
B)
C)
D)
23)
Using a form for data entry can increase the usefulness of a database by increasing
23)
A)
accuracy.
B)
redundancy.
C)
complexity.
D)
compatibility.
Answer:
Explanation:
A)
B)
C)
D)
24)
The advantage of resizing controls in Layout view rather than in Design view is
24)
A)
by seeing the content of the fields in Layout view, you can visually determine that the space
allotted is adequate.
B)
in Layout view, each control must be sized separately, allowing greater control.
C)
in Layout view, unbound controls do not appear.
D)
by utilizing the spin boxes on the Design tab, widths can be determined exactly.
Answer:
Explanation:
A)
B)
C)
D)
5
25)
Using the “keep whole group together on one page” command ensures
25)
A)
labels, data, and totals will all be on one page as long as the data doesn’t exceed one page.
B)
sums, counts, and averages will be taken for each numeric field.
C)
all data and labels will display fully on the page.
D)
subtotals will be given on each page, should the data exceed one page.
Answer:
Explanation:
A)
B)
C)
D)
SHORT ANSWER. Write the word or phrase that best completes each statement or answers the question.
26)
Match the following terms to their meanings:
I. Form Header A. prints only on last page if forms are printed as a
group
II. Section bar B. printed on the top of the first page when records
are printed as forms
III. Form Footer C. gray line in a form or report that identifies and
separates one section from another
IV. Record selector bar D. used to select an entire record in Form view
26)
Answer:
B, C, A, D
Explanation:
27)
Match the following terms to their meanings:
I. AND condition A. displays a subset of the database records
II. Record source B. records having either criteria values will be
displayed
III. OR condition C. queries or tables that provide underlying data
for a report
IV. Filtering D. records having both criteria values will be displayed
27)
Answer:
D, C, B, A
Explanation:
28)
The ________ allows you to select and move an entire group of controls.
28)
Answer:
layout selector
Explanation:
29)
The ________ is used to select an entire record in Form view.
29)
Answer:
record selector bar
Explanation:
30)
________ act as a window through which other people can enter records, filter records, and
use your database.
30)
Answer:
Forms
Explanation:
31)
The option “keep whole group together on one page” is found in the ________.
31)
Answer:
Group, Sort, and Total pane
Explanation:
6