Page 8 of 9PREVNEXT

Queries II: Create basic select queries

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.


What are two ways to create a query?

By using the AutoQuery feature or by clicking the Run button.

By using the Query Wizard or Design view.

By using Layout view to arrange the fields in your result set.

Which of the following is true when you specify criteria for a field?

You must display that field in your query results.

You can't display that field in your query results.

Your criteria must match an existing value in your database.

How can you modify criteria in a select query?

Use the query design grid.

In the Simple Query Wizard.

When you run the query.

Which of the following can you use in a record source?

Forms and reports.

Tables and queries.

System tables and code modules

Page 8 of 9PREVNEXT