Home | Courses | Microsoft Training Courses | Microsoft Access | Microsoft Access VBA Training
Microsoft Access

Microsoft Access VBA Training

Course Duration: 2 Days

This Course Covers Version(s): Microsoft Access 2010, 2013, 2016 and 2019 and Office 365.

  • Live Class with Instructor
  • Digital Course Manual
  • Hands-on Labs
  • One Year Access to Recorded Course

In this Microsoft Access VBA Training course, students will learn how to use the VBA (Visual Basic for Applications) programming language to automate their database applications. They will learn about creating Sub Procedures and Functions and see how to call these blocks of code from an event occurring in Microsoft Access, such as a button being clicked or a user saving a record. Students will be introduced to the Microsoft Access Object Model, which will allow them to control all aspects of the application, including things like closing or opening forms, printing reports or validating user data entry. Students will also be introduced to accessing data in the database through code by using Data Access Objects (DAO,) allowing the manipulation of data behind the scenes – with no user action needed. Finally, students will see how to debug their code and add error handling to ensure that unexpected errors don’t force an application shutdown. Although a programming environment, VBA is fun and easy to learn – even for students who have no programming experience!

Upon successful completion of this course, students will be able to:

  • Create Sub Procedures and Functions
  • Attach code to user-initiated or application-initiated events
  • Control program flow by using If/Then and Looping structures
  • Access and modify data in the database directly using code
  • Debug code to find and fix programming errors
  • Implement error-handling code to catch and resolve run-time errors

Students should have basic experience in creating and using tables, forms, reports and queries in Microsoft Access. No programming experience is necessary.

This course is designed for students who want to go beyond macros in Microsoft Access to automate actions in their database.

  1. Getting Started with VBA
    • Introduction to Programming with VBA in Access
    • Why Use VBA in Access?
    • Understanding the Development Environment
    • Using Visual Basic Help
  2. Understanding Procedures and Functions
    • What is a Module
    • Using Standard Modules
    • What is a Procedure
    • Using Sub Procedures
    • How to Call Procedures
    • Using the Immediate Window
    • What is a Function Procedure
    • Naming Guidelines for Procedures
    • Organizing Your Code
    • Using the Code Editor
  3. Defining Objects in VBA
    • Understanding Classes and Objects
    • Understanding the Access Object Hierarchy
    • Using Collections
    • Using the Object Browser
    • Using the Application Object
    • Using the Form Object
    • Working with Object Properties
    • Using the With Statement
    • Working with Object Methods
    • Using the DoCmd Object
    • Working with Object Events
    • Understanding the Order of Events
  4. Using Expressions, Variables, and Built-In Functions
    • Using Expressions and Statements
    • How to Declare Variables
    • Understanding Available Data Types
    • Understanding Variable Scope
    • Understanding Variable Lifetime
    • Variable Visibility in Code
    • Using Built-In Functions
    • What is a Constant
    • Using Intrinsic Constants
    • Using Message Boxes for User Input
    • Using Input Boxes for User Input
  5. Controlling Program Execution
    • Using Control-of-Flow Structures
    • Understanding Boolean Expressions
    • Using If…End If
    • Using Select Case…End Select
    • Using For…Next
    • Using For Each…Next
    • Using Do…Loop
    • Guidelines for use of Branching Structures
  6. Working with Recordsets in VBA
    • Declaring and Creating DAO Variables
    • Working with the DAO Recordset Object
  7. How to Debug VBA Code
    • Identifying VBA Error Types
    • Using VBA Debugging Tools
    • How to Set a Breakpoint
    • Using Break Expressions
    • Using Break Mode
    • How to Step Through Code
    • Watch the Value of Expressions
  8. How to Handle Errors in VBA Code
    • Understanding Error Handling
    • Understanding Error Trapping Options in VBA
    • Using the On Error Statement
    • Using the Err Object
    • Writing an Error-Handling Routine
    • Using Inline Error Handling

This course does not align to a specific exam or certification.

Live Instructor-Led Virtual Class
Click here to load this Caspio Online Database.
Questions? View Our Live, Instructor-Led Virtual Class FAQs
Virtual or In-Person Group Training

  • For Private Groups as small as 2 people.
  • Live, Instructor-led Online or Onsite Class for your group.
  • Customizable to your needs.
Click here to load this Caspio Online Database.

Questions? Contact Us
Click here to load this Caspio Online Database.