  Tables
 Queries
 Forms
 Reports
 Macros
 Modules
 What is a module?
|
|
Modules are the next step up from macros. Although Gaining Access does not go over it, modules use a programming language called VBA. A good sound knowledge base of VBA is needed to create effective modules within Access.
But why have two types of programming languages within in Access? Modules in Access are more powerful than macros. Some of the advantages of modules over macros are:
- Allowance for definition of a new function
- Improved error handling capabilites
- Faster execution because the modules are compiled rather than the interpreted macros
At this stage, modules are a bit too far advanced for those just trying to gain user-level knowledge of Access.
|
