23 terms

Access 2016 Comprehensive, 1e Ch 3

STUDY
PLAY

Terms in this set (...)

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).
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
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 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
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
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
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.
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 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 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
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.
The Total row applies only to non-numeric fields