Exam 10: Analyzing Database Design Using Northwind

One-to-one relationships are rare.

You query for zero-length strings using Is Null criteria. _________________________

You should always try to create databases that use 1NF normalization rules. _________________________

Describe third normal form.

In the figure above, what is the name of the field list?

The "" criteria is used to query for ____ values.

First normal form refers to ____.

In the figure above, results are grouped first by ____.

In the figure above, which field is the grouping field?

Kelsey and Matt are in an advanced Access class together and have teamed up as study partners. They have created a mini-quiz for each other. Following are some of Kelsey's questions for Matt. Which window shows you how well the data has been normalized?

You work in the registrar's office of a large university. You are responsible for creating a student database that contains students' ID numbers, names, addresses, phone numbers, and some medical information. The student health database contains a Students table. If each student record in the Students table has a unique StudentID, what special designation would the StudentID field be given in the Students table?

A(n) ____________________ table is a table that stores values used in a field of another table.

In Table Design View, you can view the properties of ____ field(s) at a time.

A special form used to announce information is called a splash screen.

When two fields are used in a Validation Rule expression, you should enter the rule in the ____.

When a query is based on another query's field list, the field list is called a(n) ____.

Northwind is provided by Microsoft as a(n) ____.

A(n) ____________________ primary key consists of two fields, such as OrderID and ProductID.

The Append Only property of the Memo field is available for all Access databases, regardless of which version of Access you are using.

The Relationships window shows how well the data has been ____________________.