Access VBA Courses in London
Access VBA (Visual Basic for Applications) is an effective way to extend the capabilities of Microsoft Access. Access VBA is not the easiest language to learn. A great deal of Access VBA code is Access specific (for example the coding behind an Access form) with regard to the other VBAs.Unfortunately to develop even a half-serious Access database (for example a database with custom email capability) requires Access VBA. It would be preferable that a student had some programming knowledge eg For Loops etc. It is recommended that contact is made with usl to discuss an individual's current level of programming expertise. I some cases it might be preferable to perhaps first tackle Excel VBA which is easy. 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 contiguoulsly without time for study.
A colourful and hopefully much simlified manual is provided. A text is also recommended to accompany the manual .
Our Access VBA courses run as evening or daytime courses in Bayswater.
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
- Code Modules
- Basic Programming concepts. For Loops etc.
- To Convert an Access Macro to Code
- The code behind Forms.
- Form events: Current, GotFocus, Enter, Before Insert, Filter etc.
- The Object Browser
- Objects and Collections
- To attach Code To a Menu Bar
- Combo boxes. Option groups etc.
- The Nz function.
- The Object Browser
- Error handling
- Keyboard events: KeyUp etc.
- RecordsetClone.
- Using DoCmd to open Forms and Reports.
- Making and preventing data changes with a Form.
- One to Many Forms.
- Menus and Toolbars
- Introduction to ADO
- Data Access Objects (DAO)
- Transactions
- Customizing Reports with VBA
- Report Events.
- Using SQL with DAO.
- Using XML with VBA.
- The API (Application Programming Interface)
- Automation: To Control Access from Excel
Cost: £950 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 : £1550
Private Tuition
£75 per hr
Next class start times:
Day Time:
May 2019