Module J Implementing a Database with Microsoft Access Answer
Key
Multiple Choice Questions
1.
The competitive advantage for many people seeking employment is
knowledge in which of the following software packages?
2.
What is the name of Microsoft’s database management system software?
3.
Which personal database management system software is the most
popular?
4.
Before information can be entered into a database, what is the first step
you need to do?
5.
Once the structure of the database has been created, what is the next
step?
6.
The data dictionary contains the _____ structure for the information in a
database.
7.
Where does the information about field format and file sizes get stored in
Microsoft Access?
8.
Which of the following could you use to create a data dictionary in Microsoft
Access?
9.
For text fields, which of the following is the default field size?
10.
What are rules that help ensure the quality of information?
11.
Where does the information about a field (e.g., size, type, decimals) get
stored in Microsoft Access?
12.
When defining a database structure, what does Access default to when
identifying the first field?
13.
What is the name of a field that uniquely describes each record in a
database?
14.
Which of the following is a one-step method for saving the changes you
make to a table, query, form, or report in Microsoft Access?
15.
When developing a database structure in Microsoft Access, what icon is
shown to the left of the field name to indicate that the field is a primary
field?
16.
Which of the following is a key that consists of the primary key fields from
two intersecting relations (files)?
17.
A(n) _____ is a relation you create to eliminate a many-to–many
relationship.
18.
An intersection relation is sometimes called a(n) ____.
19.
Using both Order Number and Product Code together as a primary key for
an order entry system, eliminates what type of relationship?
20.
What key is a primary key of one file that appears in another file?
21.
When you’re creating relationships, what Access option allows you to
protect your database from inconsistent data?
22.
Where do you turn on the “Enforce Referential Integrity” option in Access?