Exam 3: Tables and Queries in Relational Databases

For security purposes you want to have data redundancy in your tables.

The ________ property provides literal characters that are typed for each entry.

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

Although you can create calculated fields in a query,most prefer to add them the table instead.

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

To have your table perform mathematical functions automatically you would use a ________ field.

The Enforce Referential Integrity box should normally be checked.

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

What is the most common relationship type?

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

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

In query design,the ________ row allows you to set limits on what records are displayed.

A good way to know what fields you will need is to think of what reports you might need later.

The primary key can only be a single field.

The AND operator will give you the most results in a query.

Access requires that common fields be named exactly the same.

Data entered in a query is actually stored in the underlying table(s).

Access uses ________ to speed up the sorting or filtering process.