Question 1

The Enforce Referential Integrity box should normally be checked.

Accepted Answer

A) True 
 B)False  True

Question 2

How many characters can be stored in a field with a Short Text data type?

Accepted Answer

A)   100
B)   255
C)   500
D)   256 B

Question 3

The ________ sign should be put around dates so that Access knows they are dates.

Accepted Answer

#, pound

Question 4

Enforcing referential integrity assures that ________.

Accepted Answer

A)   you cannot enter a value in the foreign key if there is no corresponding value in the primary key
B)   you cannot enter the same value in the foreign key of the same table
C)   you cannot leave that field empty
D)   you cannot enter invalid or incorrect information

Question 5

Which of the following is not a way to create a multitable query?

Accepted Answer

A)   Modifying an existing query
B)   Using the Query Wizard
C)   Adding a table in the Relationships window
D)   Creating a query from scratch

Question 6

Match the following terms with their description:
I. Caption
II. Foreign key
III. Data type
IV. Field properties
V. Wildcards
A. Used to relate tables on common fields
B. Effects what operations can be performed on data
C. Characteristic of a field
D. Special characters that can represent other characters
E. More understandable than a field name

Accepted Answer

The answer of Match the following terms with their description:
I....

Question 7

What field property would you use to insure that all the phone numbers looked consistent?

Accepted Answer

A)   Caption
B)   Format
C)   Default Value
D)   Input Mask

Question 8

What field property would allow the user to enter "" into a field with a Short Text data type?

Accepted Answer

A)   Required
B)   Indexed
C)   Allow Zero Length
D)   Allow Null Length

Question 9

Text you add to the criteria row in a query is case sensitive, so be careful or you may get unexpected results.

Accepted Answer

A) True 
 B)False

Question 10

Multitable queries inherit their relationships and you cannot change those in the query. You need to open the Relationships window to make any changes.

Accepted Answer

A) True 
 B)False

Question 11

The primary key can only be a single field.

Accepted Answer

A) True 
 B)False

Question 12

________ queries allow you to take full advantage of table relationships.

Accepted Answer

The answer of ________ queries allow you to take full...

Question 13

What field property makes up for the limitation of the field naming rules or common practices?

Accepted Answer

A)   Validation Rule
B)   Input Mask
C)   Format
D)   Caption

Question 14

Access uses ________ to speed up the sorting process.

Accepted Answer

The answer of Access uses ________ to speed up the...

Question 15

When you purchase from a store several times this would be an example of what kind of table relationship?

Accepted Answer

A)   Many-to-one (many purchases - one customer) 
B)   One-to-one (one customer - one store) 
C)   Many-to-many (many items purchased - many times) 
D)   One-to-many (one customer - many purchases)

Question 16

Which of the following comparison operators is not valid?

Accepted Answer

A)   
B)   >=
C)   =>
D)   <

Question 17

The Cascade Update Related Fields checkbox is irrelevant if the primary key has an AutoNumber field type.

Accepted Answer

A) True 
 B)False

Question 18

Where can you not use calculated fields?

Accepted Answer

A)   In a report
B)   In a module
C)   In a form
D)   In a table

Question 19

Storing duplicate data in more than one table is called data ________.

Accepted Answer

The answer of Storing duplicate data in more than one...

Question 20

Which field property helps a user know why an entry error was generated?

Accepted Answer

A)   Validation Text
B)   Validation Rule
C)   Expression
D)   Error Code

Exam 2: Tables and Queries in Relational Databases

The Enforce Referential Integrity box should normally be checked.

How many characters can be stored in a field with a Short Text data type?

The ________ sign should be put around dates so that Access knows they are dates.

Enforcing referential integrity assures that ________.

Which of the following is not a way to create a multitable query?

What field property would you use to insure that all the phone numbers looked consistent?

What field property would allow the user to enter "" into a field with a Short Text data type?

Text you add to the criteria row in a query is case sensitive, so be careful or you may get unexpected results.

Multitable queries inherit their relationships and you cannot change those in the query. You need to open the Relationships window to make any changes.

The primary key can only be a single field.

________ queries allow you to take full advantage of table relationships.

What field property makes up for the limitation of the field naming rules or common practices?

Access uses ________ to speed up the sorting process.

When you purchase from a store several times this would be an example of what kind of table relationship?

Which of the following comparison operators is not valid?

The Cascade Update Related Fields checkbox is irrelevant if the primary key has an AutoNumber field type.

Where can you not use calculated fields?

Storing duplicate data in more than one table is called data ________.

Which field property helps a user know why an entry error was generated?