Microsoft Private

Access Programming with VBA (ACC_VBA)

3 days
Microsoft AccessVBAMicrosoft OfficeMicrosoft

Learn Microsoft Access VBA programming to work with objects, variables, control structures, custom dialogs, automation, and robust error-handling practices.

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

This introductory course teaches you to program Microsoft Access with Visual Basic for Applications (VBA). You will use the Visual Basic Editor and Access object model, work with several types of variables, apply selection and repetition structures, build custom dialogs, automate processes, and handle errors.

Each lesson introduces a VBA feature and demonstrates how to apply it in Access. Public classes use the current software version, with differences in earlier versions identified by the instructor. Private classes can be taught using the version used by your organization.

Course Benefits

  • Navigate and use the Visual Basic Editor in Microsoft Access.
  • Work with the Access object model and object variables.
  • Create and use string, date, and numeric variables.
  • Control program logic with selection structures and Select Case.
  • Display messages with the MsgBox function.
  • Use repetition structures and With statements.
  • Apply string functions in more advanced repetition structures.
  • Work with option button, check box, and list box controls.
  • Automate processes with VBA.
  • Trap and handle errors in VBA code.

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. Introduction to the Visual Basic Editor
    1. Using the Visual Basic Editor
  2. Working with the Object Model
    1. Using the Access Object Model
  3. Working with Object Variables
    1. Creating and Using Object Variables
  4. Working with String Variables
    1. Using String Variables
  5. Working with Date Variables
    1. Understanding Date Variables
    2. Using Date Variables
  6. Working with Numeric Variables
    1. Understanding Numeric Variables
    2. Using Numeric Variables
  7. Using Selection Structures
    1. Understanding Selection Structures
    2. Using Selection Structures
  8. Using Select Case and MsgBox
    1. Understanding Select Case and MsgBox
    2. Using Select Case and MsgBox
  9. Using Repetition Structures and With Statements
    1. Understanding Repetition Structures and With Statements
    2. Using Repetition Structures and With Statements
  10. Advanced Repetition Structures and String Functions
    1. Using Repetition Structures and String Functions
  11. Working with Form Controls
    1. Understanding Dialog Box Controls
    2. Using Option Buttons, Check Boxes, and List Boxes
  12. Automation
    1. Understanding Automation
    2. Using Automation
  13. Advanced Automation and Error Trapping
    1. Understanding Automation and Error Trapping
    2. Using Automation and Error Trapping

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:

  • Experience using 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