Exam 2: Tables and Queries in Relational Databases

In table relationships, the foreign key of one table cannot be joined to the ________ key of another table.

Checking the Cascade Delete Related Records checkbox assures that ________.

There might be times when you want to add the same field to a query several times.

Use the ________ data type when you want to store multiple pictures in your records.

The term that can be used in a query to refer to blank cells is ________.

What table property always necessitates an entry?

When you run a query, it displays in what view?

You should store data in their ________ parts.

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

In table relationships, the primary key is normally joined to a ________ key.

One way to fix the problem that exists if you add a table with 10 records to a query and add an unrelated table with 4 records to the same query is to add another ________ that does have common fields with both existing tables.

Which of the following would make a good primary key?

The ________ relationship requires a junction table for it to function properly.

"lastName" is an example of ________.

You cannot create a relationship between two tables unless there is at least one ________ key.

The first step to resizing a column in datasheet view is to move the pointer until it looks like a ________.

One advantage of establishing relationships between tables is so you can combine fields from more than one table in a query or report.

Access does not require that every table has a primary key.

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

To limit the number of records displayed when a query is run you add ________.