What is a Module?

A module is a collection of declarations, statements, and procedures that are stored together as a unit. Modules are very similar to macros since they are objects that provide more functionality to the database. However, while you create Access macros by selecting macro actions, Visual Basic for Applications (VBA)  is used to write modules.

Modules generally belong to two types: class modules and standard modules. Class modules contain procedures which are associated with a specific report or form that it’s attached with. Standard modules contain procedures that are not associated with specific objects and can be found under Modules within the Navigation Pane.

Developing Programming Code

MS Visual Basic for Applications is the program language used in Access and is almost identical to VB 6.0. You can manipulate data queries and tables in VBA and 2 database libraries of components are available: Data Access Objects and ActiveX Data Objects. Developers are also able to use ODBC and OLE DB to develop C/C++ Access programs.  ADO is required for ADPs and manipulating SQL Server data. The most appropriate way to manage Access / Jet Databases is DAO and it’s also the only way you can manipulate  complex ACCDB table field types.