104.
Access assumes that the first field name is ID and that its Data Type is
____, meaning that the first record will have an ID of 1, the second will have
2, and so on.
105.
You need to assign a field _____ and a data _____ for each field in a given
relation in Microsoft Access.
106.
The Field Size in Microsoft Access defaults to _____ characters.
107.
_____ are rules that help ensure the quality of the information.
108.
When creating the structure of a relation, the result of changing the _____ to
“No”, means that something must be entered into the field name when a
new record is added.
109.
Access defaults to identifying the first field in a relation as the _____ key.
110.
A primary key is a field (or group of fields in some cases) that uniquely
describes each _____ in a table.
111.
A(n) _____ key consists of the primary key fields from intersecting relations.
112.
A(n) _____ is a relation created to eliminate a many–to-many relationship.
113.
A(n) _____ is a primary key of one file (relation) that appears in another file
(relation).
114.
By turning on the enforcement of referential integrity option, your DBMS
will make sure that when you enter a _____ key in a relation it matches one
of the _____ keys in the other relation.
115.
When you drag and drop a primary key onto a foreign key, Microsoft Access
assumes that the relationship is ____.
116.
When you drag and drop a foreign key onto a primary key, Microsoft Access
assumes that the relationship is ____.
117.
As a general rule, when establishing relationships between a primary and
foreign key, you should turn on _____ to protect your database from
inconsistent data.
118.
Entering information into an Access table is referred to as _____ it.
119.
When entering information into an Access table where referential integrity
has been violated, Access displays a(n) _____ alert and does not allow you
to continue.
120.
After entering information into each field of an Access table, you use the
_____ key to get into the next field or row.
121.
A(n) _____ tool helps you graphically design the answer to a question.
122.
When creating a query in Query Design, you can drag and drop the fields
that you want in the query results into the QBE ____.
123.
Once a query has been constructed, you click on the _____ point button to
run it.
124.
When entering text into the _____ box, you must be careful that you have
the right letters (and digits and spaces, if applicable) in the right places.
125.
In Access, a report can be created using either Design View or the ____.
126.
When generating a report, _____ lets you specify groups within the top
grouping.
127.
When viewing a report where information in a field has been cut off, it is
said to be ____.
128.
If you want to place the date at the bottom of each page (Page Footer) of a
report, the command _____ is used.
129.
_____ simplify the task of entering new information and can make field
areas longer or shorter, change text colors, and add and remove fields and
labels.