Essay
Match the following terms with their description:
I. Total row
II. Totals query
III. Property Sheet
IV. Expression Builder
V. Aggregate function
A. Calculation performed on a column and returns one value
B. Way to display aggregate function results when a query is run
C. Tool to create complicated expressions
D. Where you can change the number of decimals
E. Displays aggregate function results as the last row in a table or query
Correct Answer:

Verified
Correct Answer:
Verified
Q8: When you want to add a condition
Q23: What symbol does Access use to express
Q25: What error will you get if there
Q30: If the formula,3*[Bonus],the 3 is considered a(n)_.
Q33: Calculating values will help to avoid inconsistencies.
Q41: Sometimes it is best to verify calculations
Q56: A calculated field displays the results of
Q63: The rate argument in the Pmt function
Q69: The _ aggregate function totals the items
Q71: Unless you add a minus sign,the Pmt