Access Chapter 3 Flashcards
a combination of elements that produce a value
expression
a field that displays the result of an expression rather than data stored in a field
calculated field
a predefined computation that performs a complex calculation
function
a value that does not change
constant
a method of summarizing data by the values of a field
grouping
an access tool that helps you create more complicated expressions
expression builder
calculated the loan payment given the rate, number of period (also known as term), and the present value of the loan (the principal)
pmt function
a way to display aggregate data when a query is run
totals query
a sequence by which operations are performed in a mathematical expression
order of operations
a method to display aggregate function results as the last row in datasheet view of a table or query
total row
the location you change settings such as number format and number of decimal places
property sheet
imput used to produce output for a function
argument
a calculation performed on an entire column of data which returns a single value ex. sum, avg, count
aggregate function
