Home / MS-Access / Getting Started

Visual Basic Fundamentals

The tutorial covers the following major topics:

  • The Microsoft Visual Basic Editor (VBE) and its debugging tools

  • Variables and constants and how to declare them

  • The primary object models defined in Access-the Access model, the Data Access Objects (DAO) model, and the ActiveX Data Objects (ADO) model. You'll need to understand these models to be able to manipulate objects such as forms, form controls, and recordsets in your code.

  • Visual Basic procedural statements:

    • Function and Sub statements

    • Property Get, Property Let, and Property Set (for use in class modules) statements

    • Flow-control statements, including Call, Do, For, If, and Select Case

    • DoCmd and RunCommand statements

    • On Error statements

  • A walkthrough of some example code you'll find in the sample databases