Browse 540 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).

"Thanks for running with just one person on the course. I have been on a few Wise Owl courses before and enjoy the style/approach employed (course materials, writing style, atmosphere in the classroom etc.)"

Magnus Windsor (Coloplast Ltd)

"Hands on course that will enable me to hit the ground running when I will need to use Power BI for analytics. Trainer is very knowledge and very easy to follow. The course covers a lot of topics and I reckon it is well structured. All in all, very satisfied with the Wise Owl offering!"

Carlo Pisoni (PricewaterhouseCoopers)

"Very well paced, excellent delivery. Got a good sense of the scope and potential of Power BI as a reporting and communication tool."

Rashid Jussa (Waltham Forest Council)

"The way the trainer talked through the examples and related them to real world scenarios was excellent. He went above and beyond to help me with an issue that was causing me trouble at work and made sure I had a resolution using the stuff we learned on the course. Can I also add that on all the 3 courses the hospitality was fantastic. The fact that the trainers consult each delegate as to what they would like to do for lunch, makes it feel very inclusive and gives the feeling of being valued."

Paul Maxwell (Innogy Business Services UK Ltd)

"Very fluid, informative; good balance between beginner and complexity. Well paced & easy to follow."

Paul Roberts (SMC Pneumatics)

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