Exam 2: Access: Tables and Queries in Relational Databases

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.

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

The query wizard is best used to create what kind of query?

The ________ sign should be put around dates so that Access knows they are dates.

Use the ________ data type when you want to store multiple pictures in your records.

What objects will not use the caption instead of the field names?

Match the following terms with their description: I. "And" condition II. "Or" condition III. Null IV. Comparison Operator V. Criteria A. Blank field value B. Examples include: >, <, <>, = C. Returns only records that meet all criteria D. Determines which records are selected E. Returns records meeting any criteria

Data entered in a query is actually stored in the underlying table(s).

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

What field property would you use to insure that all the phone numbers looked consistent?

What field property increases the speed at which searches can be performed?

What field property forces data to follow certain rules of data entry?

What can you not import from one Access database into another Access database?

Which logical operator would return the fewest records?

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