ch 3 access

Question 1

What is the result of the following​ expression? 2​ * 7​ + 8​ - 6/2

A. 19
B. 8
C. 20
D. 12

Answer 1

A. 19

Question 2

Which statement about a totals query is​ true?

A. A totals query may contain several grouping fields and several aggregate fields.
B. A totals query is limited to only two​ fields, one​ group-ing field, and one aggregate field.
C. A totals query is created in Datasheet view.
D. A totals query may contain several grouping fields but only one aggregate field.

Answer 2

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

Question 3

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

A. The Total row applies only to​ non-numeric fields.
B. The Total row is located between the Table and Sort rows.
C. The Total row is hidden by default in all new queries.
D. The Total row enables you to apply aggregate functions to the fields.

Answer 3

A. The Total row applies only to​ non-numeric fields.

Question 4

Which of the following statements is​ true?

A. A total order cost is an example of a common field to group by.
B. For best​ results, add as many​ “group by” fields as possible.
C. A last name is an example of a common field to group by.
D. None of these statements is true.

Answer 4

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

Question 5

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

A. An incorrect formula​ (for example, adding two numbers instead of​ subtracting)
B. An order of operations error​ (for example,​ [HourlyPay]+2*[HoursWorked])
C. A field name spelled wrong in a calculation
D. A missing colon in the expression​ (for example: TotalHours​ [OTHours]+[RegHours])

Answer 5

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

Question 5

Which of the following cannot be added to a totals​ query?

A. Grouping fields
B. Aggregate functions
C. Conditions
D. All of these can be added to a totals query.

Answer 5

D. All of these can be added to a totals query.

Question 6

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. Driver’s License Number
B. Gender
C. High School
D. Race

Answer 6

A. Driver’s License Number

Question 7

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

A. An asterisk​ (*)
B. [HoursWorked] (a field in the current​ database)
C. The number 12
D. The​ % symbol

Answer 7

D. The​ % symbol

Question 8

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

A. Counting the number of values that exist
B. Averaging a series of numbers
C. Calculating the payment amount of a loan
D. Finding the smallest value

Answer 8

C. Calculating the payment amount of a loan

Question 9

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

A. Caption
B. Number of decimal places
C. Mathematical expression
D. Number format​ (for example, displaying numbers as​ Currency)

Answer 9

C. Mathematical expression