Page 10 of 11PREVNEXT

Create queries for a new Access 2007 database

Test yourself

Complete the following test so you can be sure you understand the material. Your answers are private, and test results are not scored.


When you first create a query, you select:

A recordsource.

A system table.

A recordset.

Use criteria in a query when you need to:

Ensure your data is properly formatted.

Add formulas to a table.

Sort, filter, or otherwise limit what the query returns.

As you saw in the practice, parameters can cause a query to:

Ask you for input before the query runs.

Add sums or other functions to your data.

Sort your data.

Before you can use multiple tables as a recordsource, those tables must:

Be open in Datasheet view.

Participate in a relationship.

Not serve as the recordsource for another query.

As you saw in the practice, an expression is:

A formula stored in one or more database tables.

A formula that just calculates dates.

An object that can perform calculations and other tasks such as data validation.

Page 10 of 11PREVNEXT