Virtual and Classroom Training - All our courses are available virtually. We have also started a safe return to classroom training. Click here to learn more.

banner image

Access VBA Introduction

3 Day Course
course icon

Course Information

Overview

This Microsoft Office Access VBA training course builds on the skills you’ve already developed in creating database applications learnt on the previous Microsoft Access courses and helps you take them to the next level — using Visual Basic for Applications (VBA) to accomplish things you once performed manually.

To achieve this objective, Access includes the VBA programming language. Even if you’ve never programmed, Microsoft Office Access VBA training course will help you learn how to leverage the power of VBA to make your work with Access more efficient than ever before.

Microsoft Office Access VBA training course is for professionals who use Microsoft Access frequently in their daily work. You have serious work to get done and this course teaches you the essential skills you need to automate your databases as quickly as possible.

Level

VBA Introduction

Version

2016

Prerequisites

Attendance of Microsoft Access Introduction and Microsoft Access Advance courses or equivalent.

Course Outline

1. Getting Started
  • Introduction to Access programming
  • Understanding the development environment
  • Using VB help
2. Developing with Procedures and Functions
  • Understanding and creating modules
  • Defining procedures
  • Creating a sub-procedure
  • Calling procedures
  • Utilising the immediate window to call procedures
  • Making and naming a function procedure
  • Working using the code editor
3. Understanding Objects
  • Understanding classes and objects
  • Navigating the Access object hierarchy
  • Understanding collections
  • Using the object browser
  • Working with the application object
  • Understanding the form object
  • Working with properties
  • Using the with statement
  • Working with methods
  • Understanding the DoCmd object
  • Working with events
  • Understanding the order of events
4. Utilising Intrinsic Functions, Variables and Expressions
  • Defining expressions and statements
  • How to declare variables
  • Determining data typesHelp
  • Programming with variable scope
  • Harnessing intrinsic functions
  • Defining constants and using intrinsic constants
  • Adding message boxes and using input boxes
  • How to declare and use object variables
5. Controlling Program Execution
  • Understanding control-of-flow structures
  • Working with boolean expressions
  • Using the if...end if decision structures
  • Using the select case...end select structure
  • Using the for...next structure
  • Using the for each...next structure
  • Using the do...loop structure
  • Guidelines for use of
6. Working with Recordsets
  • Declaring and creating object variables
  • Working with the ADODB recordset object
  • Specifying a recordset cursor type
  • Locking records for updating
  • Specifying a recordset cursor location - optional
  • Using the cache size property - optional
  • Understanding recordset cursor properties - optional
7. Debugging the Code
  • Defining errors
  • Working with debugging tools
  • Determining breakpoints
  • How to step through code
  • Working with break mode during run mode
  • Identifying the value of expressions
8. Handling Errors
  • Understanding error handling
  • Understanding VBA's error trapping options
  • Trapping errors with the on error statement
  • Understanding the error object
  • Writing an error handling routine
  • Working with inline error handling
9. Ref: LS-VBA-3

Private Courses

We can arrange your own private Access course.

Tailored

Have us build a custom private course tailored to your needs.

Cost Effective

If you are looking to training a group of people private courses can be very cost effective.

Post Course Support

Unlimited post course email support on the course topics.

What Our Clients Think

The trainer was a really good instructor, he took the time to help us with individual issues and also tried to cater the course to meet our collective needs.

Ben Knight - Atlas Copco Ltd

As usual a first class training course.

Wendy Thomas - Aldi Stores Ltd

Trainer was very engaging, spent time explaining topics clearly.

Laura Choake - Desoutter Industrial Tools

Got a really good and rounded training session. It met more than my original needs, and has given me great confidence.

Debbie Seymour - FatFace

Really enjoyable and relevant, Stuart was brilliant!

Vicky Fox - Charity Link

This course was great, the trainer was very knowledgeable and has improved my knowledge considerably. The facilities are fantastic. Thank You!

Kurtis Fleming - HM Revenue & Customs

Related Courses

Introduction 1 Day
You will gain an essential understanding of Microsoft Access  create a new database, construct data tables, design forms and create queries.
Intermediate 1 Day
You will learn intermediary level skills for querying, reports, lookups, relationships and joins together with exporting and printing data.
Advanced 1 Day
You will gain advanced techniques including update queries. forms and controls, reports, macros, linking to external data and importing data. 
Administration 1 Day
You will learn how to exchange data with other applications, automate business processes by using VBA code and secure and share databases.
Introduction to VBA 3 Days
You will master the essential skills you need to automate your databases using VBA procedures and functions, controlling execution, debugging code and handling errors.