1.
A(n) __________ is a collection of data organized in a
manner that allows access, retrieval, and use of that data.
a.
file management
system
b.
database management
system
c.
integrated system
d.
database
2.
In Access, a
database consists of a collection of __________.
a.
columns
b.
tables
c.
worksheets
d.
rows
3.
Access is a
__________.
a.
word processing
software package
b.
database
c.
database
management system
d.
worksheet
management system
4.
A(n) __________ contains information about a given
person, product, or event.
a.
attribute
b.
column
c.
field
d.
record
5.
A(n) __________ contains a specific piece of information
within a record.
a.
field
b.
entity
c.
row
d.
database
6.
A field that
uniquely identifies a particular record in a table is called a _________ key.
a.
secondary
b.
primary
c.
principal
d.
foreign
7.
If a width is not
assigned to a text field, Access assumes the width is __________.
a.
30
b.
40
c.
50
d.
60
8.
Field names can
be a maximum of __________ characters in length.
a.
64
b.
32
c.
16
d.
8
9.
To move from the
upper pane, the one where fields are defined, in the Table window to the lower
pane, the one where field properties are defined, press the __________ key.
a.
f8
b.
f7
c.
f6
d.
f5
Note: If you are preparing an examination using
your own word processor, for Multiple Choice question 10 and 11 (not on our exam) you must use
the Picture command on the Insert menu to insert FigA01.bmp. The figure
is referenced when students answer the question. When the Insert Picture dialog
box displays, select FigA01.bmp from the Instructor’s
Materials folder and make sure the Link to File check box is not checked.
10.
If a key appears
in front of a field in the Table window, such as that shown in the accompanying
figure, it means the field is the __________ for the table.
a.
primary key
b.
row selector
c.
page header
d.
foreign key
11.
To make a field
the primary key for a table, such as that shown in the accompanying figure,
select the field and then click the _________ button on the toolbar.
a.
Unique Key
b.
Single Key
c.
Principal Key
d.
Primary Key
12.
Table names can
be no more than _________ characters in length and can contain letters,
numbers, and spaces.
a.
32
b.
64
c.
128
d.
256
Note: If you are preparing an examination using
your own word processor, for Multiple Choice question
13 you must use the Picture command on the Insert menu to insert FigA02.bmp.
The figure is referenced when students answer the question. When the Insert
Picture dialog box displays, select FigA02.bmp from
the Instructor’s Materials folder and make sure the Link to File check box is
not checked.
13.
If the Customer
table is represented as a collection of rows and columns, as shown in the
accompanying figure, then the table is displaying in __________ view.
a.
Table
b.
Tablesheet
c.
Datasheet
d.
Worksheet
14.
If the value
1505.5 is entered in a field that has been defined as Currency data type, then
the value will display as __________.
a.
1505.5
b.
1505.50
c.
$1505.50
d.
$1,505.50
15.
To delete a
record from a table, select the record and then press the __________ key(s).
a.
delete
b.
ctrl+d
c.
ctrl+delete
d.
ctrl+y
16.
To change to
landscape orientation to print a table, right-click the report in the Print
Preview window and then click __________ on the shortcut menu.
a.
Page Setup
b.
Print Settings
c.
Print Orientation
d.
Page Format
17.
__________ view displays a single record at a time.
a.
Datasheet
b.
Screen
c.
Form
d.
Record
18.
To create a form,
select the table for the form in the Database window, click the New Object:
AutoForm button arrow on the toolbar, and then click __________ in the list
that displays.
a.
AutoForm
b.
FormView
c.
AutoScreen
d.
ScreenView
19.
To move from Form
view to Datasheet view, click the View button arrow on the Form View toolbar
and then click __________ in the list that displays.
a.
Table View
b.
Datasheet View
c.
Multirecord View
d.
Worksheet View
20.
To preview a
report from the Database window, click Reports on the Objects bar to display
the report, right-click the report, and then click __________ on the shortcut
menu.
a.
View Report
b.
Open
c.
Display
d.
Print Preview
21.
In the Access
Help system, the __________ is similar to the Office Assistant in that it
answers questions that you type in your own words.
a.
Contents sheet
b.
Ask a Question
box
c.
Index sheet
d.
Locate sheet
22.
__________ refers
to the arrangement of data into tables and fields.
a.
File management
b.
Database
structure
c.
Database design
d.
Normalization
23.
__________ means
storing the same fact in more than one place.
a.
Normalization
b.
Consistency
c.
Reference
d.
Redundancy
24.
__________ is a
special technique for identifying and eliminating redundancy.
a.
Consistency
b.
Replication
c.
Iteration
d.
Normalization
25.
All of the
following are benefits of controlling redundancy except __________.
a.
greater
consistency is maintained
b.
less space is
occupied
c.
update is easier
d.
all of the above
are benefits
The answers to the above questions are below
1. d [A 1.07]
2. b [A 1.07]
3. c [A 1.07]
4. d [A 1.07]
5. a [A 1.07]
6. b [A 1.08]
7. c [A 1.13]
8. a [A 1.14]
9. c [A 1.18]
10. a [A 1.18]
11. d [A 1.18]
12. b [A 1.20]
13. c [A 1.21]
14. d [A 1.23]
15. a [A 1.28]
16. a [A 1.30]
17. c [A 1.34]
18. a [A 1.35]
19. b [A 1.39]
20. d [A 1.46]
21. b [A 1.49]
22. c [A 1.49]
23. d [A 1.50]
24. d [A 1.50]
25. d [A 1.50]