23 terms

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

Calculates the loan payment given the rate, number of periods (also known as

term), and the present value of the loan (the principal).

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

The 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 where you change settings such as number format and number of decimal places.

Property Sheet

The input used to produce output for a function.

Argument

A calculation performed on an entire column of data that returns a single value. Includes functions such as Sum, Avg, and Count.

Aggregate function

Which of the following cannot be used in a calculated field?

(a) The number 12

(b) An asterisk (*)

(c) [Hours Worked] (a field in the current database)

(d) All of these can be used in a calculated field

(a) The number 12

(b) An asterisk (*)

(c) [Hours Worked] (a field in the current database)

(d) All of these can be used in a calculated field

All of these can be used in a calculated field

When creating a calculation, which of the following would be identified as an error by Access?

(a) A field name spelled wrong in a calculation.

(b) An incorrect formula (for example, adding two numbers instead of subtracting).

(c) An order of operations error (for example, [HourlyPay] + 2 * [HoursWorked]).

(d) A missing colon in the expression (for example: TotalHours [OTHours] + [RegHours ]).

(a) A field name spelled wrong in a calculation.

(b) An incorrect formula (for example, adding two numbers instead of subtracting).

(c) An order of operations error (for example, [HourlyPay] + 2 * [HoursWorked]).

(d) A missing colon in the expression (for example: TotalHours [OTHours] + [RegHours ]).

A missing colon in the expression (for example: TotalHours [OTHours]+[RegHours])

What is the result of the following expression?

2*5+8-6/2

(a) 6

(b) 15

(c) 20

(d) 23

2*5+8-6/2

(a) 6

(b) 15

(c) 20

(d) 23

15

Which of the following cannot be adjusted in the Property Sheet?

(a) Caption

(b) Mathematical expression

(c) Number format (for example, displaying numbers as Currency)

(d) Number of decimal places

(a) Caption

(b) Mathematical expression

(c) Number format (for example, displaying numbers as Currency)

(d) Number of decimal places

Mathematical expression

Which of the following could not be done using an aggregate function?

(a) Averaging a series of numbers

(b) Calculating the payment amount of a loan

(c) Counting the number of values that exist

(d) Finding the smallest value

(a) Averaging a series of numbers

(b) Calculating the payment amount of a loan

(c) Counting the number of values that exist

(d) Finding the smallest value

Calculating the payment amount of a loan

Which of the following can be added to a totals query?

(a) Conditions

(b) Grouping fields

(c) Aggregate functions

(d) All of the above can be added to a totals query.

(a) Conditions

(b) Grouping fields

(c) Aggregate functions

(d) 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) A totals query is created in Datasheet view.

(b) A totals query may contain several grouping fields but only one aggregate field.

(c) A totals query is limited to only two fields, one grouping field and one aggregate field.

(d) A totals query may contain several grouping fields and several aggregate fields.

(a) A totals query is created in Datasheet view.

(b) A totals query may contain several grouping fields but only one aggregate field.

(c) A totals query is limited to only two fields, one grouping field and one aggregate field.

(d) A totals query may contain several grouping fields and several aggregate fields.

A totals query may contain several grouping fields and several aggregate fields.

Which of the following statements is true?

(a) A total order cost is an example of a common field to group by.

(b) A last name is an example of a common field to group by.

(c) For best results, add as many "group by" fields as possible.

(d) None of the above statements is true.

(a) A total order cost is an example of a common field to group by.

(b) A last name is an example of a common field to group by.

(c) For best results, add as many "group by" fields as possible.

(d) None of the above statements is true.

A last name is an example of a common field to group by

If you want to calculate aggregate statistics about graduation rates for students in a college database, which of the following would provide the least useful information if you were to group by it?

(a) Gender

(b) High School

(c) Race

(d) Social Security Number

(a) Gender

(b) High School

(c) Race

(d) Social Security Number

Social Security Number

Which of the following about the Total row in Query design is false?

(a) The Total row enables you to apply aggregate functions to the fields.

(b) The Total row is hidden by default in all new queries.

(c) The Total row is located between the Table and Sort rows.

(d) The Total row applies only to non -numeric fields.

(a) The Total row enables you to apply aggregate functions to the fields.

(b) The Total row is hidden by default in all new queries.

(c) The Total row is located between the Table and Sort rows.

(d) The Total row applies only to non -numeric fields.

The Total row applies only to non-numeric fields