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