Microsoft Private

Access: VBA Programming Training (ACC301)

1 day
Microsoft AccessMicrosoft OfficeMicrosoftVBA

Develop practical VBA programming skills in Microsoft Access with the Visual Basic Editor, control structures, custom dialogs, debugging, and error handling.

Talk to a Learning ConsultantRequest a Private Class

Register or Request Training

  • Private class for your team
  • Live expert instructor
  • Online or on‑location
  • Customizable agenda
  • Proposal responses same day as request
Request Proposal

Course Overview

Designed for experienced Microsoft Access users, this instructor-led course introduces VBA programming in Access. Participants work in the Visual Basic Editor and learn to use the Access object model, variables, decision and loop structures, custom dialog boxes, debugging, and error handling.

Public classes use the current software version, with relevant differences for earlier versions noted by the instructor. Private classes can be taught using the version used by your organization.

Course Benefits

  • Write and run VBA procedures within Microsoft Access.
  • Navigate and work effectively in the Visual Basic Editor.
  • Use the Access object model and Object Browser.
  • Declare variables, manage variable scope, and accept user input.
  • Apply decision and loop structures to control program flow.
  • Create custom dialog boxes with user forms and events.
  • Debug VBA code and implement error handling.

Delivery Methods

Private Class
Delivered for your team at your site or online.

Microsoft Certified Partner

Webucator is a Microsoft Certified Partner. We design and deliver training that aligns directly with Microsoft's official technologies, standards, and learning objectives.

Microsoft Certified Partner

Course Outline

  1. Visual Basic Editor
    1. Introduction to Visual Basic for Applications
    2. Using the Visual Basic Editor
      1. The Visual Basic interface
      2. Working in the Visual Basic Editor
      3. Using the Visual Basic Editor in Access
      4. Creating a Close event procedure
      5. Saving and running a procedure
    3. Object programming
      1. The object model
      2. Using Help in the Object Browser
    4. Event procedures and macros
    5. Using the object model in Access
      1. The Access object model
  2. Programming Basics
    1. Data fundamentals
    2. Variable scope
    3. Naming variables
    4. Using variables to accept user input
  3. Control Structures
    1. Decision structures
    2. Loop structures
  4. Custom Dialog Boxes
    1. User forms
    2. Events
  5. Debugging and Error Handling
    1. Types of errors
    2. Debugging
    3. Error handling

Class Materials

Each student receives a comprehensive set of materials, including course notes and all class examples.

Class Prerequisites

Experience in the following is required for this VBA class:

  • Expert-level proficiency with Microsoft Access.

Prerequisite Courses

Courses that can help you meet these prerequisites:

Have questions about this course?

We can help with curriculum details, delivery options, pricing, or anything else. Reach out and we’ll point you in the right direction.

Talk to a Learning Consultant