MICROSOFT ACCESS MULTIPLE CHOICE: 1.) When creating a calculation, which of the

ID: 3808260 • Letter: M

Question

MICROSOFT ACCESS MULTIPLE CHOICE:

1.) When creating a calculation, which of the following would be identified as an error by access?

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

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

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

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

- The total row enables you to apply aggregate functions to the fields

- The total row is located between the table and sort rows

- The total row applies only to non-numeric fields

3.) A report can be made from one or more tables or a query. The object(s) that a report is based on its known as the:

- Record Source

- Theme

- Control

Answer

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

[2] The total row applies only to non-numeric fields

[3] Record Source

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.