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.

Outline

  • Introduction to access programming
  • Understanding the development environment
  • Using VB help
  • 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
  • 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
  • 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
  • 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
  • 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
  • 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
  • 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
Dates and Prices

There are currently no public dates for this course. This course can be run as a private course either at one of our training centers or at your offices. To get pricing for this use our quote wizard to generate a customised quote or call us on 0118 324 3000 to discuss your requirements.

image
3 Days

Testimonials

  • Noel was an excellent tutor. He did check all of the group was able to keep up and if there were any problems or questions of the attendants, he was always willing to help.

    Marianne Seager-Wincanton
  • This was a really good training, nicely paced, very useful and well presented. Thank you, Stuart!

    Joris Latinne-Oracle