Macros can be used to automate complex tasks. Describe some of the steps that should be taken when developing these types of macros

What will be an ideal response?

When developing a macro that automates complex tasks you should first consider all actions that the macro will need to execute to complete the task. Before you begin creating the macro in Access, create process flow that describes the actions and reasons for those actions. This will save time in the development of the macro and reduce the chance of errors while developing the macro.