ACCESS TRAINING COURSES

ACCESS VBA

Target Audience

This course sits outside the main stream of Access courses and is suited to someone with Intermediate to Advanced Access knowledge wishing to Automate and develop custom applications with Microsoft Access.

Access VBA or Visual Basic for Applications is a programming language embedded in Microsoft Office applications. VBA allows for the Automation of processes in and the creation of new and unique functions and procedures.

Compared to most other programming languages, it is relatively easy to learn, yet extremely powerful.

This course will guide the user through well established programming methodologies while developing code that functions in the Access environment.

The outline below is for contemporary versions of Access (2013, 2016, 2019 and 365). We do run courses on earlier versions when required. Please mention this when booking.

Prerequisites

A good knowledge of Table, Query, Form and Report design are Prerequisites for this course.

Duration:

2 Days

Price:

Prices start from $500 per 2 day course but may vary based on location.

Course Dates - ONSITE (Your Premesis):

Dates are available for this course

Please Contact Us to schedule one that works for you

Schedule a Date


 

Course Dates - ONLINE-LIVE:

Dates are available for this course

Please Contact Us to schedule one that works for you

Schedule a Date

 

Course Files:

Download Course Files

 

COURSE OUTLINE

VBA Essentials

  • Understanding the Programming Environment
  • The VBA Editor Window
  • Working with the Project Explorer
  • Working with the Properties Window
  • Understanding Modules
  • Viewing the Code Behind Forms
  • Standard Code Modules
  • Understanding Naming Conventions I

VBA Subroutines

  • Understanding Procedures
  • Anatomy Of A Subroutine
  • Creating A Subroutine
  • Creating Functions
  • Calling Procedures
  • Passing Parameters
  • Scoping Procedures

Using Variables

  • Understanding Variables
  • Understanding Data Types
  • Creating And Using Variables
  • Implicit And Explicit Declarations
  • Working With Numbers
  • Dealing With Overflows
  • Working With Decimals
  • Working With Dates
  • Default Values
  • Variable Scope
  • Procedure Level Scoping
  • Module Level Scoping
  • Passing Variables By Reference
  • Passing Variables By Value

Interacting With Users

  • Understanding Input Boxes
  • Using The InputBox Function
  • Using InputBox Function Arguments
  • Understanding Message Boxes
  • Creating A Simple Message Box
  • Creating A Longer Message
  • Breaking A Message Line
  • Displaying Buttons And Icons
  • Using The Message Box Function
  • Responding To Different Buttons

Making Decisions

  • Understanding The IF Statement
  • Creating A Single-Line If Statement
  • Creating A Block If Statement
  • Creating Multiple If Statements
  • Using If For Multiple Text Conditions
  • Understanding The Select Case Statement
  • A Simple Select Case Statement
  • Value Ranges In Select Case Statements
  • Using Select Case Statements With OR

 

Looping In VBA

  • Understanding For Loops
  • Creating A While Loop
  • Working With Counters
  • Creating An Until Loop
  • For...Each Loops
  • Exiting From Loops
  • For...Next Loops

The DoCmd Object

  • Navigating With DoCmd
  • Moving Through Records
  • Filtering Records With DoCmd
  • Opening And Closing A Form With DoCmd
  • Opening A Report With DoCmd
  • Creating Variable Reports

ActiveX Data Objects - Tables

  • Setting References Using VBA
  • Creating Tables With ADO
  • Removing A Table Using ADO
  • Populating A Form Using ADO
  • Dealing With An Empty Table

ADO Forms And Recordsets

  • Finding A Record
  • Updating A Record
  • Deleting A Record
  • Adding A New Record

Debugging VBA

  • Setting A Breakpoint
  • Setting Additional Breakpoints
  • Stepping Through A Procedure
  • Viewing The Call Stack
  • Using Locals And Immediate Windows
  • Adding A Watch

Handling Errors In VBA

  • Common Errors
  • Understanding The On Error Statement
  • Simple Error Handling
  • Using The Err Object
  • Using The Resume Statement
  • Using Decision Structures In Error Handlers
  • Forcing An Error
  • Defining Custom Errors
  • Working With Errors