23 terms

Access Chapter 3

STUDY
PLAY

Terms in this set (...)

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
An Access tool that helps you create more complicated expressions.
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.