Describe the various macros that you created, both stand alone and embedded, and what purpose they serve in the system

Question

What will be an ideal response?

Answer 1

Several macros were required to automate the basic functionality of the system and to improve the overall user experience. Macros were used to run the appropriate queries necessary to record the clock-in and clock-out times of the employees while turning off the warning messages for the action queries used. A macro was used to verify that the employee's login credentials matched that stored in the tblAccount table. Another macro was used to check that the employee trying to access the manager administration form was authorized to do so. Another macro was used to launch the Password Reset form and close the login form when the Forget Password? button was clicked as well as another that verified that the answer to the password reset question, matched the one stored in the tblAccount table, and one that runs the update query to change the password. Several embedded macros were used to close windows and open additional forms and reports when prompted. Finally, an AutoExec macro was created to automatically open the login form and delete the record from the tblCurrentUser table.