Menu

    Call us on:
    020 8892 5637

Microsoft Access VBA Training Courses

If you’re looking for really great Microsoft Access VBA training you’re in the right place.

Companies large and small choose us – why? Your own tailored, Microsoft Access VBA training course, at your own premises at the same price as a standard course from elsewhere.

When working with a Microsoft Access database becomes repetitive, it makes sense to create a macro to automate the task. Whilst you can use built-in wizards to create simple macros, if you want to create complex macros in Microsoft Access then using VBA (Visual Basic for Applications) will enable you to program your own. This course is designed to teach you how.

We provide Access VBA training at your offices in London, Bristol, Cardiff, Birmingham, Bath, Swindon, Reading, Bracknell, Newport, Swansea, Glasgow etc.

The JMD Training difference is clear:

  • We come to you - your Microsoft Access VBA training will be given on your site
  • You get to keep the manuals - Access VBA training manuals are provided as PDFs
  • We can train using your own Microsoft Access databases
  • There will only be people from your company on your course
  • We offer a money-back guarantee if any delegates are not completely satisfied
  • The training date is around you, not us!
  • Our prices are astounding
  • We can assess all learners in advance for free
  • Our courses are never cancelled

Request Course Now »

Course TypeCost per day
1 to 1 training£425
2 to 4 delegates£595
5 to 8 delegates£795

Prices are PER DAY, and NOT per-person! E.g. if there’s 5 people on the course, you pay £795. All prices exclude VAT. Please note this is a two day course.

Other Microsoft Access training courses

 

Visit our blog If Only I’d Known That,; we have called it that because we hear it so many times in training sessions. In fact, if only we had an extra £100 for every time someone says “If only I’d known that.” ….

Clients who have benefitted from our Access VBA training include:

Access VBA Training Overview

Microsoft Access is a Database Management System (DBMS) that you can use to store, query and report on your data.

Using Access ‘out of the box’ can be a powerful tool but to make the most of your investment you will no doubt benefit from making use of Visual Basic for Applications (VBA), a programming language which can be used to build your own applications.

Within this Integrated Development Environment (VBA is part of the Microsoft Office suite so no additional software is required) you create ‘macros’ which are step-by-step procedures written in Visual Basic. These procedures can then be run, triggered, by actions through the forms and reports events.

No previous programming experience is required. Our course will introduce you to coding by example and will demonstrate how to use VBA to interact with Access so you can automate and simplify complex tasks with a relatively small amount of code. You will also find having learned VBA within one Microsoft Office application you can apply your knowledge throughout the Office suite.

Prerequisites

A good working knowledge of Access allows the delegates to gain the maximum from this course.

As we mention above; no previous programming experience is required.

Provisional Course Outline

Getting Started

  • Introduction to Programming in Access
  • Why Program in Access?
  • Understanding the Development Environment
  • Using Visual Basic Help

Working with Procedures and Functions

  • Understanding Modules
  • Creating a Standard Module
  • Understanding Procedures
  • Creating a Sub Procedure
  • Calling Procedures
  • Using the Immediate Window to Call Procedures
  • Creating a Function Procedure
  • Naming Procedures
  • Organising Code and Procedures
  • Working with the Code Editor

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

Using Expressions, Variables, and Intrinsic Functions

  • Understanding Expressions and Statements
  • Declaring Variables
  • Understanding Data Types
  • Working with Variable Scope
  • Working with Variable Lifetime
  • Considering Variable Scope and Lifetime Together
  • Using Intrinsic Functions
  • Understanding Constants
  • Using Intrinsic Constants
  • Using Message Boxes
  • Using Input Boxes

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 Branching Structures

Working with Recordsets

  • Declaring and Creating Object Variables
  • Working with the DAO Recordset Object

Debugging Code

  • Understanding Errors
  • Using Debugging Tools
  • Setting Breakpoints
  • Setting Break Expressions
  • Using Break Mode during Run Mode
  • Stepping through Code
  • Determining the Value of Expressions

Handling Errors

  • Understanding Error Handling
  • Understanding VBA’s Error Trapping Options
  • Trapping Errors with the On Error Statement
  • Understanding the Err Object
  • Writing an Error-Handling Routine
  • Working with Inline Error Handling

Request Course Now »

We provide Microsoft Access training courses, Microsoft Office training courses, other IT training courses and Personal Development training courses in London, Richmond, Twickenham, Kingston, Hounslow, Brentford, Putney, Kingston, Wimbledon, Walton-on-Thames, Chiswick, Teddington, Hampton, Feltham, Acton, Ealing, Heathrow, Egham, Staines, Hanwell, Sunbury, Hammersmith, Fulham, Greenford, Clapham, Chertsey, Woking, Weybridge, Wandsworth, Middlesex, Surrey, the M25 corridor, High Wycombe and beyond. We will travel further if expenses are covered.

For Access VBA training courses Sydney, Australia, please visit our sister site http://www.jmdtraining.com.au/microsoft-office-training/microsoft-access-training/access-vba-training