Request a callback
Email us

Business Booking Details

Payment Of Invoices

For bookings from established businesses, we do not require payment at the point of booking.

We will send you an invoice which you can submit to your accounts payable system.

Purchase Orders

If your employer uses a purchase order (P.O.) system to manage supplier invoices that is no problem.

  • If you already have a P.O. number when booking add it to the PO number box on the booking form, and we will include it on your invoice.
  • If you need an invoice to generate a P.O. number in your accounts system, please book the course as normal and add a note in the PO number box – to be provided
  • We will send you an invoice (without a P.O.) which you can use to generate a P.O..
  • We will then re-issue your invoice with your P.O. included when you provide us with it

PAYMENT METHODS:

You are not able to pay directly online at the time of booking, we issue an invoice for all bookings.

We accept payment either via direct bank transfer or card

Our invoices contain our bank details if you would like to pay by bank transfer and there is also information on how to pay by card.

Please note, if you are using a business card there is a surcharge of 2% to cover the payment processing charges.

Microsoft Access Training: VBA Course

Microsoft Access Training: VBA Course

This Microsoft Access VBA training course will show you how to take complete control of your Access database using VBA (Visual Basic for Applications) code.

It will show you the key features and capabilities of using VBA with Access and get you using it as quickly as possible.

It is a hands-on course. It includes plenty of time for experimenting with what you are being taught, trying things out for yourself and asking questions.

✔ A complete beginners’ Access VBA course that covers all of the basics.
✔ Plenty of one to one attention and time to ask questions.
✔ Friendly expert trainers, small groups and a comfortable place to learn.
✔ All the materials and extras that you’ll ever need.
✔ Ongoing support and help with issues you have after the course.

What Will I Learn?

This course will ensure that you go back to your office as a confident, relaxed Access VBA programmer.

It will lead you through programming and controlling Access using VBA with multiple examples to reinforce the concepts that you are being taught.

Am I Ready For This Course?

This course assumes that you will have prior knowledge of Access up to the level taught in our Advanced course.

No prior knowledge of Access macros or Visual Basic for Applications (VBA) is required.

The Training Day

Our courses run from 9.30am to roughly 4.15pm with refreshments and biscuits throughout the day and a break for lunch.

We offer a relaxed, supportive learning environment, fully air-conditioned training facilities and some of the nicest instructors on the planet.

Also, you’ll receive:

✔ A full-colour manual which covers everything in the course.
✔ Your course exercises so that you can practice at home.
✔ A Certificate of Attendance.

 

Course Details

Download full course details Download full course details
This session concentrates on the VBA code editor that is contained within MS Access. Once you are comfortable with accessing the code editor, it moves on to show you how to create the modules that you will use to hold your code. It then discusses the project explorer which you will work in when writing your VBA code, and also looks at sub-routines and commenting your VBA code.
The key concepts trained are:
  • Two ways to create modules
  • Using Project Explorer
  • Basic subroutines and comments
This session focuses on using message boxes to communicate with and get input from users and also on the basics of variables.
The key concepts trained in this session are:
  • The all-powerful DoCmd object
  • Displaying messages
  • Getting input from users
  • Using variables

Functions are one of the key elements of a VBA program. Functions take input data, carry out an operation on that data and then return a value when they complete. A simple example of a function would be a calculator to work out the area of a rectangle. The function would require as inputs the two different lengths of the sides. It would multiply them together and return the area of the rectangle.

The input data into a VBA function are known as arguments which are passed through a function.

The key concepts trained in this session are:

  • Passing arguments
  • Returning values

Now that you have been introduced to the nuts and bolts of VBA code, this session steps back a little bit. It explains at a high level how VBA programs are organised and manipulated.

This session introduces delegates to the object model in Access and also to collections of objects. It introduces methods and property as well as other parts of the VBA framework.

The key concepts trained in the session are:

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

Once you are comfortable writing VBA code, the next step is to understand how to connect it to forms. This is the most user-friendly way to access the power of VBA on a day-to-day basis. It allows non-programmers to access your code and also allows you to run your code without opening the code editor.

The key concepts trained in this session are:

  • Attaching code to buttons
  • Attaching code to events
  • Making code not form-specific
  • Manipulating Form/Control Properties

Often within VBA code, you want a certain task to be repeated many times. This is known as looping. This session covers looping in detail including its application to forms and controls.

The key concepts trained in this session are:

  • The four types of loop
  • Looping over all open forms
  • Looping over controls
  • Looping over Access Objects
SQL (Structured Query Language) is the core database querying language. This session introduces SQL and then shows delegates how to amend the SQL of an Access query. This gives you complete control over queries in Access.
The key concepts trained in this session are:
  • Basic SQL statements
  • Amending queries in SQL

Recordsets, along with SQL, are the most common way for VBA developers to interact with a database. A recordset is simply a collection of records. They may either have come from a table, a number of tables or more often be the result of a query.

This session leads you through using recordsets to interact with your database. It starts by running through the differences between the major ways of using recordsets, ActiveX Data Objects (ADO) and Data Access Objects (DAO) before looking at the practicalities of adding, deleting and editing data.

The key concepts trained are:

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

Inevitably when you write VBA code in Access you will make errors. Learning to debug code is a key skill. The VBA code editor contains a number of tools to help you identify the pieces of your code that are causing the issues.

This session shows you the various methods that are available to you to help you isolate your problematic pieces of code.

The key concepts trained in this session are:

  • Stepping through macros
  • Setting breakpoints
  • Trapping for errors

The final session of this course covers working with Excel and Word. Inevitably, as your programming skills develop, you will want your Access code to interact with other Microsoft Office programs. This is most likely to be Excel and Word.

This session covers how you can use Access to access other applications and also how you can manipulate Excel from Access using your VBA code.

The key concepts trained are:

  • Referencing other applications
  • Manipulating Excel from Access

Online Training Requirements

To attend this Access course online, you will need:

✔ MS Access on your Windows PC with a camera, speakers & microphone
✔ A stable internet connection capable of running Zoom
✔ To be a confident computer user and able to use Zoom

If you have access to a second screen, we would encourage you to use it as it improves the experience.