Exam 2: Tables and Queries in Relational Databases

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

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.

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

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

Match the following field properties with their description or something true about the property: I. Caption II. Format III. Required IV. Indexed V. Result Type A. Does not affect the stored value B. Increases efficiency during searches C. Used for calculated fields only D. More understandable than field names E. Cannot be Null

In a query, the sort order, when sorting on multiple fields, is determined by the field order from left to right.

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

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

What is the suggested data type for a street address?

You can easily ________ your data by using a multitable query.

It is best when designing a query to add all the fields from a table in case you need them later.

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 ________ lines if there are common fields.

The ________ field type makes a good primary key.

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

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

What is not one of the six guidelines for creating fields?

The first step in creating a query is selecting the fields you need.

What is the most common relationship type?

What is not true about the hyperlink data type?

A person's age is often a field used in table design.