Access 3: End of Chapter Quiz

What is the result of the following expression- 2 * 5 + 8 - 6 / 2

15

Which statement about a totals query is true

A totals query may contain several grouping fields and several aggregate fields

Which of the following statements is true?

A last name is an example of a common field group by.

When creating a calculation, which of the following would be identified as an error by Access?

A missing colon in the expression

Which of the following cannot be used in a calculated field?

All can be used.

Which of the following can be added to a totals query

All the above

Which of the following could not be done using an aggregate function

Calculating the payment amount of a loan

Which of the following cannot be adjusted in the Property Sheet

Mathematical Expression

If you want to calculate aggregate statistics about graduation rates for students in a college database, which of the following would provide the least useful information if you were to group by it?

Social Security Number

Which of the following about the Total Row in Query design is false

The Total row applies only to nonnumeric fields.