Exam 2: Access: Tables and Queries in Relational Databases

Text you add to the criteria row in a query is case sensitive, so be careful or you may get unexpected results.

What is not one of the six guidelines for creating fields?

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

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

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 another ________ that does have common fields with both existing tables.

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

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

Access requires that common fields be named exactly the same.

What field property would allow the user to enter "" into a field with a Short Text data type?

The term that can be used in a query to refer to blank cells is ________.

Having common fields is important when you begin to build ________ between the tables.

The first step to resizing a column in datasheet view is to move the pointer until it looks like a ________.

For security purposes you want to have data redundancy in your tables.

What is not true about field names?

What view offers the most flexibility in setting the properties of a field?

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?