Case AC 11-2 Craig has responsibility for updating the frozen food inventory for the Frosty Freeze Snack Shop each night. On Sunday evenings, Craig wants to print five forms displaying weekly summary inventory results that he provides to his five different suppliers and his manager the next morning. He does not want the form to remain open after it is printed. As Shelly is a part-time employee working at the Frosty Freeze Snack Shop to help pay her way through college, Craig asks Shelly if she can write the macro to open and print the report. As Shelly starts writing the macro she decides to include multiple actions starting with the print action. Craig expresses some concern as he recalls from his Advanced Access 2010 class that ____.
A) if he does not have a printer connected to his computer, the macro will not run
B) when recording a macro, Access can only support single actions
C) if you want to print a report, you will probably want to select an action that first opens the report and then select the action to print the report
D) Shelly should first be making the report open in a Read Only mode

Question

Quizplus · Accepted Answer

Craig is correct that in order to print a report, it is typically necessary to first open the report and then select the action to print the report. This is because the print action alone does not specify which report to print, what printer to use, or what settings to apply. However, Shelly can create a macro with multiple actions that includes both opening the report and printing it, as well as any other necessary steps such as saving or closing the report. Additionally, whether or not Craig has a printer connected to his computer should not affect Shelly's ability to create the macro, as long as the printer is properly configured in Access. Similarly, while Access does have some limitations on the complexity of recorded macros, it is possible to create macros with multiple actions using Visual Basic for Applications (VBA) code instead. Finally, while making the report open in read-only mode could prevent accidental changes or deletions, it would not necessarily be required for simply printing the report.

Case AC 11-2 Craig Has Responsibility for Updating the Frozen