Access Multiple Choice Chapter 3

What is the result of the following expression? 2 * 5 + 8 - 6 / 2 (1 point) 15 6 20 23

15

Which of the following statements is true? A last name is an example of a common field to group by. A total order cost is an example of a common field to group by. For best results, add as many "group by" fields as possible. None of the above statements is true.

A last name would be a common field to group by.

When creating a calculation, which of the following would be identified as an error by Access? (1 point) A missing colon in the expression (for example: TotalHours [OTHours]+[RegHours]). A field name spelled wrong in a calculation. An order of operations error (for example, [HourlyPay] + 2 * [HoursWorked]). An incorrect formula (for example, adding two numbers instead of subtracting).

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

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 is created in Datasheet view. 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 can be added to a totals query? Grouping fields Conditions Aggregate functions All of the above can be added to a totals query.

All of the above can be added to a totals query

Which of the following cannot be used in a calculated field? (1 point) [HoursWorked] (a field in the current database) An asterisk (*) The number 12 All of these can be used in a calculated field

All of these can be used in a calculated field

Which of the following cannot be adjusted in the Property Sheet? Number of decimal places Caption Number format (for example, displaying numbers as Currency) Mathematical expression

Mathematical expression

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? (1 point) Race High School Gender Social Security Number

Social Security Number

Which of the following about the Total row in the query design grid is false? The Total row enables you to apply aggregate functions to the fields. The Total row is hidden by default in all new queries. The Total row applies only to non-numeric fields. The Total row is located between the Table and Sort rows.

The Total row cannot be applied to non-numeric fields.

Which of the following is not an aggregate function? Calculating the payment amount of a loan Finding the smallest value Averaging a series of numbers Counting the number of values that exist

pmt