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
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
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started