Page 9 of 10PREVNEXT

Queries IV: Use functions and calculated fields in your 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.


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 calculate them.

Store them in a form.

A calculated field _____.

Is stored as data in your database.

Appears in query results, along with data from other fields in your datasource.

Cannot be displayed in query results.

Which of the following is true?

Access evaluates a multiplication or division operation before it evaluates anything else.

Access evaluates a negative operation before it evaluates anything else.

Access evaluates an exponent before it evaluates any other operation.

Page 9 of 10PREVNEXT