Exam 2: Access: Tables and Queries in Relational Databases

Which of the following would make a good primary key?

What is the correct order of steps for creating a multitable query? I. Step 1 II. Step 2 III. Step 3 IV. Step 4 V. Step 5 A. Add the tables you want B. Click Query Design in the Queries group C. Click Run D. Drag the fields you want E. Click the Create tab

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

Where can you not use calculated fields?

When you import data, where can you not store it?

The ________ key is what guarantees that a record is unique.

When creating a multitable query from scratch only include related tables in your query.

What table property always necessitates an entry?

Which of the following comparison operators is not valid?

What is not critical when you are first designing a database?

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

Use the ________ data type if you need to store a True or False value.

Match the recommended field types with their definitions or examples: I. Calculate II. Lookup Wizard III. Short text IV. Number V. Currency A. Can hold up to 255 characters B. Used to force users to pick from a custom list C. Can be set to Euros D. References one or more existing fields E. Used if you want to store a dollar sign ($)in your data

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