Microsoft Office training -  Access VBA macros

Access Training

Access VBA Training Course

£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 - or you could consider an onsite Access training course.

Course Contents

The content of this course are as follows:

The VBA code editor

  • Training topicTwo ways to create modules
  • Training topicUsing Project Explorer
  • Training topicBasic subroutines and comments

Messages and variables

  • Training topicThe all-powerful DoCmd object
  • Training topicDisplaying messages
  • Training topicGetting input from users
  • Training topicUsing variables

Creating functions

  • Training topicPassing arguments
  • Training topicReturning values

Visual Basic explained

  • Training topicObjects and collections
  • Training topicMethods and properties
  • Training topicThe Access object model
  • Training topicGetting help in VBA

Attaching code to forms

  • Training topicAttaching code to buttons
  • Training topicAttaching code to events
  • Training topicManipulating form/control properties
  • Training topicMaking code not form-specific

Looping

  • Training topicThe four types of loop
  • Training topicLooping over all open forms
  • Training topicLooping over controls
  • Training topicLooping over Access Objects

Recordsets

  • Training topicChoosing ADO or DAO
  • Training topicAdding data
  • Training topicEditing data
  • Training topicDeleting data

Debugging and error handling

  • Training topicStepping through macros
  • Training topicSetting breakpoints
  • Training topicTrapping for errors

Case studies

  • Training topicNavigation buttons
  • Training topicCreating a simple menu
  • Training topicValidating forms
  • Training topicCriteria forms

Covered if time allows If time

Linking to Excel and Word

  • Training topicReferencing other applications
  • Training topicManipulating Excel from Access

Covered if time allows If time

Modifying queries

  • Training topicBasic SQL statements
  • Training topicAmending 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?

View full list of benefits View full list of benefits

Sample customer feedback

"Very well explained and at a good pace that gave opportunities to ask questions, very good course. Material covered will be very useful going forward."

Andrew Appleton (Home Retail Group PLC)

"The trainer was very good and friendly. Very informative. Relaxed and friendly, good touch on going out to a restaurant for lunch."

David Barnes (Trafford Housing Trust)

"Very good course, handouts & exercise books. Training clear and helpful."

Anne McMillan (DHL Supply Chain)

"Excellent content and very well presented by a very knowledgeable and personable trainer. Small groups which allowed the trainer to spend a lot of time with everyone on the course. The course manuals cover all aspects of the training and are very clear and concise. I am looking forward to my next course.A++++ "

Steve Morley (Best Food Logistics (formerly Bidvest Logistics))

"Excellent course."

Amabel Grant (Bloom Services)

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