Looking for the best and quickest ways to master MS Access and Access VBA? Join hundreds of other professional database users who have mastered the skills needed to create MS Access databases and program them using VBA, in the quickest possible way.
A signed up membership gives you exclusive access to hundreds of online video tutorials. These tutorials are carefully designed so that you can learn Microsoft Access and Access VBA in the shortest time possible.
Learn MS Access with the following express training courses:
Some free sample tutorials from our Express Training Series
Access VBA: Using DoCmd
MS Access 2007: Access Security
MS Access 2003: Using AutoForm
While there have been various versions of Microsoft Access, Access VBA has not changed. So whether you have Access 2007, Access 2003, or any other versions, the programming concepts and principles of VBA apply to all. The express Access VBA training course include plenty of examples to enable you to grasp the topics quickly.
The latest free Access VBA Tutorial
Introduction to MS Access VBA
Just like the old say, before you can run you must learn to walk so these tutorials assume you already know how to use Access. If you're new to access, we've made available a highly structured, easy to understand MS Access training course for you. Please make sure you're proficient in using and creating tables, queries, forms, reports and macros. This is important as there're tons of stuff you can do using the tools in Access without wasting time writing VBA code. VBA is normally used in cases where you need you database to perform tasks that are not already built into Access, or perhaps you want to automate tasks that are built in.
Writing Access VBA Code - The Basics
To begin writing VBA code, you need to understand how VBA fits into the structure of Microsoft Access. In an Access database, VBA code is stored in modules. A module is simply a container of VBA code. This VBA code can be called upon to perform a specified task.
Programming With Objects
An Access database is made up of objects such as forms, reports, tables, macros, and modules. Objects also include controls such as a text box on a form, a table column, a form button etc... Each of these objects has properties that define of the object look and behave. They also have methods that determine what you can do with the object. An object also has events that it responds to. An event can be an action by the user or something happen in the system.
Tools in the VBA Editor
Everytime you open the VBA Editor you're presented with a number of tools that make coding your project much easier. These tools include: