Access - Ch 3 Flashcards
1
Q
Combination of elements that produce a value
A
Expression
2
Q
Displays results of an expression
A
Calculated Field
3
Q
Sequence of calculations
A
Order of Operations
4
Q
Order of Operations
A
PEMDAS
5
Q
Used to format a field in a query; enables you to change the way a field appears
A
Property Sheet
6
Q
Performs a calculation on an entire column of data and returns a single value
A
Aggregate Function
7
Q
Displays the result of the aggregate function as the last row in Datasheet View
A
Total Row
8
Q
Contains an additional row in a query design grid and is used to display aggregate data when the query is run
A
Totals Query
9
Q
Allows you to summarize your data by the values of a field
A
Grouping
