Exam 2: Access: Tables and Queries in Relational Databases

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

What field property makes up for the limitation of the field naming rules or common practices?

Although you can link to external data, it is not recommended.

It is safe to change data in a query since you are only changing a temporary copy of the data, not the underlying data in the table.

Access uses ________ to speed up the sorting process.

To limit the number of records displayed when a query is run you add ________.

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

Storing duplicate data in more than one table is called data ________.

A field's ________ determine how that field functions.

A database designer needs to be concerned about what fields might be needed rather than file size.

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

Which option would this wildcard, "H[!oe]" not display?

Checking the Cascade Delete Related Records checkbox assures that ________.

When you purchase from a store several times this would be an example of what kind of table relationship?

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."

What is not true about the hyperlink data type?

Match the following terms with their description: I. Caption II. Foreign key III. Data type IV. Field properties V. Wildcards A. Used to relate tables on common fields B. Effects what operations can be performed on data C. Characteristic of a field D. Special characters that can represent other characters E. More understandable than a field name

Which of the following is not a way to create a multitable query?