1. To make sure that only numbers between 1-100 are entered into a field, you would set this restriction in the _____ field property.

a. required

b. input mask

c. caption

d. validation rule

2. In the Relationships window, how would you ensure that when a primary key is changed, all foreign keys will change as well?

a. Click enforce referential integrity, then click cascade delete.

b. Create a one-to-many relationship.

c. Click cascade update.

d. Click enforce referential integrity, then click cascade update.

3. Which view lists the fields and data types of a table in columns?

a. design

b. column

c. relationships

d. datasheet

4. How can you tell if a table is sorted by a particular field?

a. the sorted field appears in the first column

b. the sorted field is highlighted

c. an arrow appears in the column header

d. a watermark appears in the background of the field's column