Page 22 of 23PREVNEXT

Queries II: Limit your data and calculate values

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.


You can use a totals query to average a group of items.

True.

False.

Which of the following is the best practice for working with calculations?

Always store them in a table.

Use a query to make your calculations.

Store the results in a form.

A calculated field _____

Is displayed in query results with fields from your database.

Cannot be displayed in query results.

Is stored as data in your database.

Page 22 of 23PREVNEXT