Exam 3: Access: Tables and Queries in Relational Databases

"lastName" is an example of ________.

To have your table perform mathematical functions automatically you would use a ________ field.

You should store data in their ________ parts.

When you run a query, it displays in what view?

You can save time and help prevent errors when you ________ data from an external source.

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

When creating a multitable query from scratch only include related tables in your query.

A good way to know what fields you will need is to think of what reports you might need later.

If you add a table with 10 records to a query and add an unrelated table with 4 records to the same query, how many records will display when you run the query?

There might be times when you want to add the same field to a query several times.

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

Checking the Cascade Delete Related Records checkbox assures that ________.

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

Logical operators only work with text and numbers, not dates.

What option automatically deletes records in related tables that match the primary key?

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

Which of the following would make a good primary key?

What is the most common relationship type?

Match the following field properties with their description or something true about the property: i. Caption II. Format III. Required IV. Indexed v. Result Type

Although you can create calculated fields in a query, most prefer to add them the table instead.