Chapter 8

Question 1

Datasheet View

Answer 1

Assumes you want to create a table simply by entering data.

Question 2

Design View

Answer 2

Gives you control over all choices that need to be made during table creation, such as specifying data types and field properties for each attribute in the table.

Question 3

Data Type or Field Property

Answer 3

Determines what kind of data values may be entered into a database table’s column. Examples include text, numbers, currency, date/time, and so forth.

Question 4

Required Data Entry Field Property

Answer 4

A choice specified in table design view that will result in a user not being allowed to enter a record into the table without including a value for that field.

Question 5

Relationship Layout

Answer 5

A window in which relationships between tables are visually depicted.

Question 6

Show Table Window

Answer 6

A screen from which the user may choose which tables to include in the relationship layout or in a query design.

Question 7

Enforce Referential Integrity

Answer 7

Disallow any data entry into a foreign key or concatenated primary key field that is not blank or does not match exactly a value in the related primary key field.