Access VBA Courses in London

Access VBA (Visual Basic for Applications) is an effective way to extend the capabilities of Microsoft Access. Compared with Excel VBA, Access VBA is not the most straightforward VBA to learn. A great deal of Access VBA code is Access specific ie not generic with regard to the other VBAs (Word and Excel). It is also not always the best behaved VBA, and can be a little tricky at times. This is where we come in! Some students may have some knowledge of basic programming techniques eg For Loops etc but if not, this is covered and in any case revised. The level to start with is very basic but eventually even ADO is covered as well as an introduction to classes and APIs.

Once again the philosophy is to provide for time between classes for revision. It is not our policy to teach continuously and risk students becoming fazed. Some exercises are set between sessions for revision. Indeed the revision (3 - 4 hrs per class) is probably the most important aspect of the training!

A colourful and hopefully much simlified manual is provided. A text is also recommended to accompany the manual - a chapter by chapter correspondence.

Our Access VBA courses run as evening or daytime courses from Bloomsbury Square.

What does the Access VBA course cover?

10 x 2.5 hour lessons = 25 hours total. Wednesday Evenings 6.30-9pm.

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.
SQL
XML.
API (Application Programming Interface)
Automation: To Control Access from Excel
Introduction to DAO and ADO

Cost: £750 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.
10 sessions of 2 hrs each.
Cost : £1250

Next start times:

Evening: Wednesday June 2 .

Day: Monday July 19