Browse 554 attributed reviews, viewable separately for our classroom and online training
Classroom training -  Access VBA macros

Classroom Training

Access VBA

Available as classroom training course only

£695 + VAT for most venues (£850 + VAT for London)

2 days

Access supports two different programming languages:

  • The painting-by-numbers macros, which you can use to perform basic functions;
  • The far more powerful VBA (Visual Basic for Applicatons) programming language.

If you're going to be using Access, we think you should be learning VBA - it's far more powerful, and is compatible with the programming languages used by other MS Office applications such as Excel and Word. On this two-day course you'll learn about the DoCmd object, variables, handling form events, linking to recordsets and much more!

We don't have any dates scheduled for this course, but we may well consider adding them - it's always worth asking.

Alternatively, you could enquire about running the course in your office or even (if available) as a tailored online course.

Course Contents

The contents of this course are as follows:

The VBA code editor

  • Two ways to create modules
  • Using Project Explorer
  • Basic subroutines and comments

Messages and variables

  • The all-powerful DoCmd object
  • Displaying messages
  • Getting input from users
  • Using variables

Creating functions

  • Passing arguments
  • Returning values

Visual Basic explained

  • Objects and collections
  • Methods and properties
  • The Access object model
  • Getting help in VBA

Attaching code to forms

  • Attaching code to buttons
  • Attaching code to events
  • Manipulating form/control properties
  • Making code not form-specific

Looping

  • The four types of loop
  • Looping over all open forms
  • Looping over controls
  • Looping over Access Objects

Recordsets

  • Choosing ADO or DAO
  • Adding data
  • Editing data
  • Deleting data

Debugging and error handling

  • Stepping through macros
  • Setting breakpoints
  • Trapping for errors

Case studies

  • Navigation buttons
  • Creating a simple menu
  • Validating forms
  • Criteria forms

Covered if time allows If time

Linking to Excel and Word

  • Referencing other applications
  • Manipulating Excel from Access

Covered if time allows If time

Modifying queries

  • Basic SQL statements
  • Amending queries' SQL

Delegates should only attend this course if they have a good working knowledge of Access basics, and if they are proficient computer users. Experience of programming, while useful, is not essential.

Why Choose Us?

Sample customer feedback

Our thanks to everyone who agreed to share their thoughts (note that some of these reviews may be for our online courses).

"Trainer was very engaging. Content was well thought out and relative. Good to keep the material to look at afterwards."

Ian Wilson (NHS Pension Scheme)

"Really good content."

Philip McTiernan (Department of Health)

"Very knowledgeable trainer - able to answer all of our questions and issues that came up."

Lyndsay Haynes (Derby and Burton Hospitals NHS FT)

"Really excellent course - a brilliant (& entertaining) trainer. Good pace, good explanation. Will definitely be recommending when I get back to the office! Good introduction to SSIS - excellent course outline on website. Recommendation came from manager."

Elspeth Clark (Central and North West London (CNWL) NHS Foundation Trust)

"Great trainer - very clear, easy to understand and set a perfect pace for everyone on the course. Great level of detail and fantastic content - all very useful. The booklet and exercises are super helpful both in the training and after. Lovely venue & perfect lunch choices. Honestly best course I've been on yet!"

Katie Stevenson (Barbican Insurance / Arch Capital Gp Ltd)

There are lots more where these came from (or just refresh this page to change the quotes shown).

Related Courses

Access Developers

Introduction/Intermediate

3 day course

Advanced VBA

Very advanced

2 day course

Other Microsoft Access training resources

Access exercises

Access exercises

If you're learning Access VBA, you may want to have a look at the course exercises before booking a place.

View Access VBA or Access 2010 exercises

Access blogs

Access blogs

We've published a range of blogs on Microsoft Access and Access VBA to help you learn this challenging subject.

View Access or VBA macros blogs

This page has 0 threads Add post