Question 1

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.

Accepted Answer

The answer of Access assumes that the first field name...

Question 2

When you drag and drop a foreign key onto a primary key,Microsoft Access assumes that the relationship is ____.

Accepted Answer

The answer of When you drag and drop a foreign...

Question 3

When you drag and drop a primary key onto a foreign key,Microsoft Access assumes that the relationship is ____.

Accepted Answer

The answer of When you drag and drop a primary...

Question 4

After entering information into each field of an Access table,you use the _____ key to get into the next field or row.

Accepted Answer

The answer of After entering information into each field of...

Question 5

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.

Accepted Answer

The answer of By turning on the enforcement of referential...

Question 6

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.

Accepted Answer

The answer of When creating the structure of a relation,the...

Question 7

A(n)_____ is a primary key of one file (relation)that appears in another file (relation).

Accepted Answer

The answer of A(n)_____ is a primary key of one...

Question 8

_____ are rules that help ensure the quality of the information.

Accepted Answer

The answer of _____ are rules that help ensure the...

Question 9

Entering information into an Access table is referred to as _____ it.

Accepted Answer

The answer of Entering information into an Access table is...

Question 10

In a database management system,the word relation is also called a(n)_____ or file.

Accepted Answer

The answer of In a database management system,the word relation...

Question 11

A(n)_____ is a relation created to eliminate a many-to-many relationship.

Accepted Answer

The answer of A(n)_____ is a relation created to eliminate...

Question 12

You need to assign a field _____ and a data _____ for each field in a given relation in Microsoft Access.

Accepted Answer

The answer of You need to assign a field _____...

Question 13

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.

Accepted Answer

The answer of When entering information into an Access table...

Question 14

A primary key is a field (or group of fields in some cases)that uniquely describes each _____ in a table.

Accepted Answer

The answer of A primary key is a field (or...

Question 15

Access defaults to identifying the first field in a relation as the _____ key.

Accepted Answer

The answer of Access defaults to identifying the first field...

Question 16

As a general rule,when establishing relationships between a primary and foreign key,you should turn on _____ to protect your database from inconsistent data.

Accepted Answer

The answer of As a general rule,when establishing relationships between...

Question 17

The Field Size in Microsoft Access defaults to _____ characters.

Accepted Answer

The answer of The Field Size in Microsoft Access defaults...

Question 18

The _____ includes a description of each relation and each piece of information in each relation.

Accepted Answer

The answer of The _____ includes a description of each...

Question 19

There are two main ways to create the data dictionary for e relation: in ______;and in ____.

Accepted Answer

The answer of There are two main ways to create...

Question 20

A(n)_____ key consists of the primary key fields from intersecting relations.

Accepted Answer

The answer of A(n)_____ key consists of the primary key...

Quiz 19: Implementing a Database With Microsoft Access