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

In this tutorial:

  1. Visual Basic Development Environment
  2. Visual Basic Editor Window
  3. Relationship Between Access and Visual Basic
  4. Visual Basic Debugging Tools
  5. Working with the Watch Window
  6. Variables and Constants
  7. Variable and Constant Scope
  8. Declaring Constants and Variables
  9. Dim Statement
  10. Enum Statement
  11. Event Statement
  12. Private Statement
  13. Public Statement
  14. Static Statement
  15. Type Statement
  16. Collections, Objects, Properties, and Methods
  17. DAO Architecture
  18. ADO Architecture
  19. Referencing Collections, Objects, and Properties
  20. Use Exclamation Points and Periods
  21. Assigning an Object Variable-Set Statement
  22. Object Methods
  23. Manipulating Complex Data Types Using DAO
  24. Working with ADO Recordsets
  25. Functions and Subroutines
  26. Sub Statement
  27. Understanding Class Modules
  28. Property Let
  29. Property Set
  30. Controlling the Flow of Statements
  31. Do...Loop Statement
  32. For...Next Statement
  33. For Each...Next Statement
  34. If...Then...Else Statement
  35. RaiseEvent Statement
  36. Stop Statement
  37. With...End Statement
  38. Running Macro Actions and Menu Commands
  39. Executing an Access Command
  40. Trapping Errors
  41. Working with 64-Bit Access Visual Basic for Applications
  42. Using LongPtr Data Types
  43. Supporting Older Versions of Access
  44. Using LongLong Data Types