Exam 2: Access: Tables and Queries in Relational Databases

You should store data in their ________ parts.

The ________ relationship is used when joining two primary keys.

The primary key can only be a single field.

Use the ________ data type when you do not know how much text space will be required.

What field property helps to make sure that correct data is entered?

The ________ field type makes a good primary key.

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

What field property would you use to automatically enter "PA" in a state field?

If you wanted the user to pick from a particular list, what would you pick from the data type drop down list for that field?

It is best to copy a query if you need a similar query, but with different criteria, rather than to start from scratch.

Access provides a wizard for easily importing Excel data into Access.

Enforcing referential integrity assures that ________.

You can only have one primary key in a table, but you can have several foreign keys.