Introduction to VBA in Microsoft Access
Programming with VBA in Access allows for database manipulation that may be awkward or even impossible with standard data access techniques. This may be accomplished by writing code directly in the Visual Basic Editor (VBE), which includes a window for writing code, debugging code, and code module organization. To find out how to access the VBE by adding the developer toolbar to your excel 2007, 2010 and 2013 versions of Access, please follow the appropriate link in the Related Articles section.
VBA within Access can be used to automate a variety of tasks from generating stored procedures to designing reports, and can even be used to automate other Microsoft Office products through a process called OLE Automation.
When learning about VBA in Access it’s very important that a programmer become familiar with the Access Object Model. The object model is a representation of how all the different objects within Access (Application, Forms, Reports, Queries.) interact with each other. By understanding the relationship of these objects, even if just at a high level, will make VBA much easier to develop in. Please follow this link for a high level tutorial on the Access Object Model.
Once you have an understanding of the Access Object Model I’m sure you’ll want to start writing your own code. If you are the kind of person who likes building everything from scratch, check out our code snippets section or if you’d prefer to work with some concrete and practical examples you can find them in our tutorials section.