COVID-19: Choose between our familiar (but now socially distanced) classroom training courses and our excellent new live online courses.
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).

"Course materials are really useful and very comprehensive. Lots of useful tips and tricks."

Clair Rigby (Royal Northern College of Music)

"Very well structured, good mix each day. Very knowledgeable trainer."

Taylor Robinson (Precision Polymer Engineering (PPE) / Idex Corp)

"I was impressed. I didn't want to do the course, I'm now an SSIS convert."

Darren Phillips (StepChange Debt Charity)

"The trainer was without doubt very knowledgeable and able to answer all of my questions. Tandoori sea bass was excellent. I needed to discover what more could be done with VBA and I learned plenty. I have progressed on to using VBA in other office applications as well and have automated much of my monthly workload."

Geoff Doyle (Humankind Charity)

"Good content - lots to learn! Trainer patient!! Need to practice now."

Ann Marie Clyde (BAE Systems)

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 skills assessment

Access skills assessment

You can test how well you know Access VBA using one of the tests at our separate skills assessment site.

View Test your Access skills skills assessment tests

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