Exam 3: Tables and Queries in Relational Databases

If you wanted the user to pick from a particular list, what would you pick from the data type drop down list for that field?

What data type assigns the next consecutive number to new records?

A field's ________ determine how that field functions.

Which field property helps a user know why an entry error was generated?

What is the most common relationship type?

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

Which of the following cannot be imported from one Access database into another Access database?

Match the recommended field types with their examples: I. AutoNumber II. OLE III. Hyperlink IV. Yes/No V. Attachment A. An email address B. Multiple pictures C. An object created by another program D. When the answer can be either True or False E. Very useful for Primary keys

How many characters can be stored in a field with a Short Text data type?

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

Access does not require that every table has a primary key.

The Cascade Update Related Fields checkbox is irrelevant if the primary key has an AutoNumber field type.

________ queries allow you to take full advantage of table relationships.

You should store data in their ________ parts.

Storing a book's title in more than one table within a database is considered data ________.

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

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

The ________ field type makes a good primary key.

Match the following field properties with their example: I. Default Value II. Validation Text III. Validation Rule IV. Input Mask V. Field Size A. ! \(999") "000\-0000;0;_ B. "MD" C. 14 D. "MD" Or "PA" Or "WV" E. "Please enter a value greater than 40."

When you need a query to return entries based on any of a set of criteria, then you would use the ________ condition.