23 terms

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, 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

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

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

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

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 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 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.

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.

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 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.