What is a Macro?
A macro is a group of predetermined actions that make Tables, Queries, Reports perform in a particular way. Macros automate several tasks which objects have to perform over and over again to save time and avoid monotony. Macros can automate tasks oft-repeated such as opening or closing a form or report or printing a report so that instead of going through all the clicks involved, you just need to click on a command button created and run by a macro. Though it’s very user-friendly and need absolutely no programming skills, macros are limited in its actions and so Visual Basic programming will be required for greater flexibility and more complex automation.
There are additional features to macros where you can require certain conditions to be met before a macro actually starts to run and perform the desired operation. Each action defined in the macro will activate a particular operation.
What is a Module?
A module is a compilation of procedures and declarations encoded in VBA or Visual Basic Application programming language and stored as a unit. As modules are written in VBA, the possibilities are endless as compared to macros which are limited to the list of macro actions provided in MS Access.
Modules are divided into two types—standard modules and class modules. Class modules are not displayed in the navigation bar and are attached to forms or reports. Standard modules are displayed separately from the objects in the navigation bar.