Exam 3: Access: Tables and Queries in Relational Databases

When you import data, where can you not store it?

Match the following field properties with their example: i. Default Value II. Validation Text III. Validation Rule IV. Input Mask v. Field Size

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

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

One advantage of establishing relationships between tables is so you can combine fields from more than one table in a query or report.

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?

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

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.

You can only have one primary key in a table, but you can have several foreign keys.

What is not true about the Caption property?

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

Match the following terms with their description: i. Caption II. Foreign key III. Data type IV. Field properties v. Wildcards

A field's ________ determine how that field functions.

What is not one of the six guidelines for designing tables?

The ________ property provides literal characters that are typed for each entry.

Use the ________ data type if you need to store a True or False value.

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.

Use the ________ data type when you do not know how much text space will be required.

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

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