Access VBA Courses in London

VBA stands for Visual Basic for Applications. It's a very effective way for you to extend the capabilities of Microsoft Access.

Our Access VBA courses run as evening or daytime courses from our London campus, in Bloomsbury Square.

What does the Access VBA course cover?

12 x 2.5 hour lessons = 30 hours total. Wednesday Evenings 6-30-9pm. Day Times to be arranged.

Next Evening Course: Wed 14th May 2008

Topics covered on this course are:

Make An Access Macro
To Edit the Code
Code Modules
To Convert an Access Macro to Code
To Write Access VBA Code directly
The code behind Forms.
Form events: Current, GotFocus, Enter, Before Insert, Filter etc.
The Object Browser
Error handling
Combo boxes
Option groups
Keyboard events: KeyUp etc.
Using a Form's RecordsetClone.
Using DoCmd to open Forms and Reports.
The Nz function.
Making and preventing data changes with a Form.
To attach Code To A Menu Bar
One to Many Forms.
The difference between Refresh and Requery.
Menus and Toolbars
The Object Browser
Objects and Collections
Data Access Objects (DAO)
Transactions
To Make a Table from Code using DAO
To Create a Query From Code using DAO
Customizing Reports with VBA
Report events.
Introduction to SQL
Introduction to XML.
API (Application Programming Interface)
Automation: To Control Access from Excel
Introduction to ActiveX Data Objects (ADO)

Cost: £650 per person.

Individual Courses:
20 hrs: These can be aranged to suit but it is not recommended that these are continous. The course content is quite considerable so it is essential that a student is able to allocate a few hours beween sessions to practising and doing set exercises.
8 sessions of 2 1/2 hrs each or 10 sessions of 2 hrs each for example.
Cost : £950