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