|
Here is the
Cumulative
Exam covering material from Chapter 2.
Multiple choice (choose the BEST answer):
1)
In datasheet view, a table in MS Access is similar to
the appearance of:
(a)
an Excel worksheet
(b)
Word Document
(c)
Excel Chart
2)
As opposed to rows and columns, a table is made up of
records and:
(a)
Titles, respectively
(b)
Subjects, respectively
(c)
Fields, respectively
3)
You can select design view by:
(a)
Left-clicking design view from the main database view
(b)
Right clicking in datasheet view, and switch to design
view
(c)
Creating a table in the wizard and choose to open
design view
(d)
All of the above
4)
Previously created tables (once they are saved) are
listed:
(a)
From Newest to Oldest
(b)
From Oldest to Newest
(c)
In Alphabetical Order
5)
By clicking on NEW when Tables from the left menu bar
is selected:
(a)
The Table Wizard appears
(b)
You can choose a view or whether to import a table
(c)
A Sample table appears
True or False (If true,
explain why; if false, correct the statement):
6)
Information in a table can be modified in design view
and datasheet view.
7)
You cannot change the type of data for a field once
that field has been created.
8)
The maximum field size of an inputted record is 250.
9)
In the table wizard, you are asked whether or not you
would like to set a primary or secondary key.
10)
In the form wizard, you can choose from 9 different
styles, including datasheet and justified.
11)
When in design view of a form, the upper left box will
allow you to view Properties, where you can manipulate event
procedures.
12)
When choosing design view for a form, the ruler bars on
the horizontal and vertical axes appear automatically.
13)
Command buttons can only be inserted into a form by
choosing the appropriate icon from the options toolbar.
14)
Once created, the source of an object, text box,
drop-down box, or list box cannot be modified.
15)
If a drop-down or list box is created, the information
or records are recalled from tables and queries.
Fill in the Blank:
16)
If you are unsure about what fields to place in a
table, the _______________ can take you through a step by step
process of making one.
17)
In order to define an individual record in a table, one
must designate the record by establishing a _______________.
18)
If a button is created on a form and has the ability to
recall information from a table, it is said to have a
_____________ control.
19)
One can manually edit and modify information of a table
in _________________ view.
20)
If you want to create a specific operation, a
___________ can be used with most options under Properties.
Matching (choose the BEST
answer):
21)
____Primary Key A. Identifies the
maximum number of characters for a
record
22)
____Date/Time field B. Can be used to create
specific objects, display data,
and
decorate a form.
23)
____Number field C. Used for alignment
and justification of text boxes,
label
boxes,
etc.
24)
____Field Size D. Allows one to
input numbers for year, month, and
day
25)
____Detail E. Allows one to
input numbers of any type
26)
____Ruler F. Can be used to
perform various operations from the
design view of a form.
27)
____Controls G. Signifies the
area on a form where one can design
the
form (hint: the grid)
28)
____Commands H. Uniquely defines an
individual record in a table
and
helps with maintaining identification of that
table.
Back
to Main Page
|
: Chapter 2 :
Instructor