Access 2016 Comprehensive, 1e Ch 3
Terms in this set (23)
A combination of elements that produce a value.
A field that displays the result of an expression rather than data stored in a field.
A predefined computation that performs a complex calculation.
A value that does not change.
A method of summarizing data by the values of a field.
An Access tool that helps you create more complicated expressions.
Calculates the loan payment given the rate, number of periods (also known as
term), and the present value of the loan (the principal).
A way to display aggregate data when a query is run.
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.
The location where you change settings such as number format and number of decimal places.
The input used to produce output for a function.
A calculation performed on an entire column of data that returns a single value. Includes functions such as Sum, Avg, and Count.
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?
Which of the following cannot be adjusted in the Property Sheet?
(b) Mathematical expression
(c) Number format (for example, displaying numbers as Currency)
(d) Number of decimal places
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?
(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?
(b) High School
(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
YOU MIGHT ALSO LIKE...
Academic Word Lists - AWL Sublists
Access Chapter 3 Quiz
Access Chapter 3
Access Chapter 3
OTHER SETS BY THIS CREATOR
Java How To Program (late objects) 10e
Java How To Program (late objects) 10e, Ch 12
Java How To Program (late objects) 10e, Ch 11
Java How To Program (late objects) 10e, Ch 10
THIS SET IS OFTEN IN FOLDERS WITH...
Access 2016 Comprehensive, 1e Ch 2
Access 2016 Comprehensive, 1e Ch 4
Access 2016 Comprehensive, 1e Ch 1
Access 2016 Comprehensive, 1e Ch 5