VBA For Access - 2 Days - private courses from £1390 + vat
VBA for Access training uk
This VBA For Access training course is designed for experienced users of Access' advanced features, who wish to extend their knowledge to include the use of Visual Basic for Applications (VBA) within Access.
VBA for Microsoft Access Training Course Objectives
Experienced Access users with previous programming experience may find a 1:1 intensive VBA for Access training course achievable in one day. Less experienced users, users without programming experience, or for training in groups, the two day VBA for Access training course is recommended.
VBA for Access Training Course Content
Where Code is stored
- Standard modules
- Class modules
Development Environment
- Adding Code to a Form or Report
- Types of Procedures
- Entering Code
Running Code
- Run mode and Design mode
- Running Code from the development environment
- Running Code from the host application
Reusing Code
- Exporting a file
- Importing a file
Using VB for Applications Using Variables
- Lifetime and scope of variables
- Using and writing sub-procedures
- Using and writing Function procedure
Controlling Programme flow
- Conditional structures
- Looping structures
- Trapping errors
Debugging
- Using the break mode
- Using the VB Editor debug features
Using Standard VB
- Input Boxes
- Message Boxes
- Standard VB Functions
- Functions in your Code
Access Object Module Forms and Form Events
- Reports and Report Events
- Creating a Workspace Using the Microsoft Jet Engine
- Retrieving a Recordset
- Navigating Records
- Updating Records
- Adding Records
- Querying Data
Using VB
- Using VB Objects, Methods and Properties to manipulate, read, edit and update data in a Database
VBA for Access Course Prerequisites
Delegates should have a sound knowledge and experience of MS Access at Advanced level and preferably possess some experience in the use of Macros and Events within Access or other programming language.
What our clients think of our VBA training courses
Just a quick line to let you know how much Ilesh and myself gained from the excellent VBA course we recently attended at your offices. Your facilities are excellent and we were most impressed by the trainer's depth of knowledge and ability to restructure the course dynamically to ensure that we obtained the most relevant training.
The two days were not only very informative but also good fun!
Alan Hill - GlaxoSmithKline
VBA for Access Training Recommended Reading
Beginning Access 2003 VBA - David Sussman – buy from amazon
Access 2003 Vba Programmer's Reference - Cardoza – buy from amazon
Microsoft Office Access 2003 – buy from amazon
home book this course resources 01273 622272 info@siliconbeachtraining.co.uk
Microsoft Office and Sage Accounts are skills needed in most modern businesses, we offer a full range of beginners courses, and for more advanced delegates we provide VBA for Access and VBA for Excel training courses.