Access VBA

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.


MS Access             Training


Learn MS Access with the following express training courses:

Express Access VBA

Express MS Access 2007

Express MS Access 2003


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.

If you need to brush up on your Microsoft Access skills, the Express Training Series also include 2 training courses in Access 2007 and Access 2003.



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.

Read more...


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.

Read more...


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.

Read more...


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:

  • Project Explorer
  • Properties window
  • Immediate window
  • Code window

Read more...