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.