#### Terms in this set (23)

• A value that does not change.
Constant
• A formula used to calculate new fields from the values in existing fields.
Expression
• Determines the sequence by which operations are calculated in an expression.
Order of Operations
• Dictates the structure and components required to perform the necessary calculations in an equation or evaluate expressions.
Syntax
• Enables you to change settings such as number format, number of decimal places, and caption.
Property Sheet
Expression Builder
• A predefined computation that performs a complex calculation. Almost 150 are built into Access.
Function
• Any data needed to produce output for a function.
Argument
• Calculates the periodic loan payment given the interest rate per period, term of the loan in months, and the original value of the loan.
Pmt Function
• Performs calculations on an entire column of data and returns a single value. Includes functions such as Sum, Avg, and Count.
Aggregate Function
• Displays aggregate function results as the last row in the Datasheet view of a table or query.
Total Row
• Makes an additional row available in the query design grid. Used to display aggregate data when the query is run.
Totals Query
• Allows you to summarize your data by the values of a field.
Grouping
• Which of the following correctly identifies the rules for the order of operations? Parentheses, exponentiation, addition, subtraction, multiplication, division Parentheses, exponentiation, multiplication, division, addition, subtraction Addition, subtraction, multiplication, division, exponentiation, parentheses Exponentiation, parentheses, addition, subtraction, multiplication, division
Parentheses, exponentiation, multiplication, division, addition, subtraction
• What is the result of the following expression? (3 * 5) + 7 − 2 − 6 / 2 13 7 17 14.5
17
• Which of the following cannot be adjusted in the Property Sheet? Mathematical expression Number format (for example, Currency) Number of decimal places Caption
Mathematical expression
• Which of the following is not an aggregate function? Min Avg Pmt Count
Pmt
• Which of the following can be added to a totals query? Grouping fields Aggregate functions Conditions All of the above can be added to a totals query
All of the above can be added to a totals query
• Which statement about a totals query is true? A totals query may contain several grouping fields but only one aggregate field. A totals query is limited to only two fields, one grouping field and one aggregate field. A totals query may contain several grouping fields and several aggregate fields. A totals query is created in Datasheet view.
A totals query may contain several grouping fields and several aggregate fields.
• Which of the following statements is true? A total order cost would be a common field to group by. For best results, add as many group by fields as possible. A last name would be a common field to group by. None of the above statements is true.
A last name would be a common field to group by.
• After creating a calculated field, you run the query and a Parameter dialog box appears on your screen. How do you respond to the Parameter dialog box? Click OK to make the parameter box go away. Close the query without saving changes. Reopen it and try running the query again. Look for a possible typing error in the calculated expression. Type numbers in the Parameter box and click OK.
Look for a possible typing error in the calculated expression.
• A query contains student names. You run the query and while in Datasheet view, you notice a spelling error on one of the student's names. You correct the error in Datasheet view. Which statement is true? The name is correctly spelled in the table and in all queries based on the table. You cannot edit data in a query. The name is correctly spelled in this query and any other queries, but will remain misspelled in the table. The name is correctly spelled in this query but will be misspelled in the table and all other queries based on the table.
The name is correctly spelled in the table and in all queries based on the table.
• Which of the following about the Total row in the query design grid is false? The Total row is located between the Table and Sort rows. The Total row cannot be applied to numeric fields. The Total row enables you to apply aggregate functions to the fields. The Total row does not display by default in all new queries.
The Total row cannot be applied to numeric fields.