Exam 11: Analyzing Database Design Using Northwind

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

One-to-one relationships are rare.

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

What is positioned in the right side of the Field Properties pane?

-In the figure above, what is the name of the query being constructed?

To move a field list in the Relationship window, drag its ____________________.

A one-to-one relationship occurs when one record of the first table is related to ____________________ record(s) in the second table.

Match each term with the correct choice. -A blank entry

-In the figure above, what type of relationship is shown between the Customers and Shippers tables?

-Which statement is true about the figure above?

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

Compare and contrast a zero-length string with a null entry.

A right join is the default join between two tables in an Access query. _________________________

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

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

A switchback form is a special form used to help users navigate throughout the rest of the database.

A normalized database increases redundant data.

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

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

First normal form means that redundant data in the original table is extracted, placed in a new table, and related to the original table. _________________________