chapter 4 Flashcards
1
Q
Expression Builder
A
Tool helps create more complicated expressions, Enables you to easily see complex formulas and functions in there entirety.
2
Q
Argument
A
Each input used to produce output for a function
3
Q
Aggregate Function
A
Performs a calculation on an entire column of data and returns a single value. example SUM
4
Q
Average
A
Calculates the average value for a column
5
Q
Count
A
Counts the number of values in a column
6
Q
Maximum
A
Returns the item with highest value
7
Q
Minimum
A
Returns the item with lowest value
8
Q
SUM
A
Totals the items in a column
9
Q
Total Row
A
Displays the results of the aggregate functions as the last row in the datasheet view of table or query
10
Q
Totals Query
A
Contains an additional row in query design grid and is used to display aggregate data when the query is run.
