Page 10 of 11PREVNEXT

Create queries for a new 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 record source.

A system table.

A record set.

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 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 record source, those tables must:

Be open in Datasheet view.

Participate in a relationship.

Not serve as the record source 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.

This course has taught you everything you need to know about queries



Page 10 of 11PREVNEXT