Case AC 11-1 The Accounting department manually runs queries every Monday morning to verify the reconciliation of salesperson salary. They have asked the Information Technology (IT) department for some assistance in saving time with this repetitive task. Because the report involves salary and private personnel information, security is an utmost priority. As the senior IT database analyst, you volunteer to help out with this request. You explain that you will create a macro as part of the solution because ____.
A) viruses cannot infect macros
B) macros cannot be disabled
C) macros automate repetitive tasks, such as running queries
D) links to the database records make the macro query run faster

Question

Quizplus · Accepted Answer

Macros automate repetitive tasks, such as running queries, which is the main objective of the Accounting department's request. The other options, such as viruses not infecting macros or macros not being disabled, are not necessarily true and security measures can still be taken regardless of the use of macro. The speed of the query may be improved with the use of macros, but this is not the primary reason for choosing to use macros in this situation.

Case AC 11-1 the Accounting Department Manually Runs Queries Every