Access 2007 VBA Programming Course
Course Description
This course provides delegates with an overview Access VBA. Rather than being a formal "learning to programme" course, this is a hands-on, task-based course which tackles some common problems and shows how they can be overcome with a little knowledge of VBA. It also serves as an excellent grounding in VBA concepts for delegates attending the 4 day "Access 2003 Programming" course.
Course pre-requisites:
Delegates should have a good knowledge of Microsoft Access, including creating tables, forms, reports and queries. A knowledge equivalent to PTR's Access Level 3 course is assumed.
Topics covered on the 1 day Access 2007 VBA Programming course
Visual Basic Editor
- Objects
- Object Browser
- Collections
Programming basics
- Working with data
- Scope
Control structures
- Decision structures
- Loop structures
ActiveX Data Objects
- Getting started with ActiveX Data Objects
- Working with ActiveX Data Objects
VBA debugging tools
- Errors in code
- Debugging techniques
- Handling runtime errors
Office integration
- Automating Office 2007
- Working with Word from Access
- Working with Excel from Access
Course Classification:
Applications Training Course
This is an instructor led training course taught in a classroom based environment.
Scheduled course dates
| September 2010 | October 2010 | November 2010 | December 2010 | January 2011 |
| 3 | 1 | 5 | 3 | - |
View full schedule of Microsoft Access courses
View full schedule of VBA courses
Print / Download PDF Version of full course schedule
If you would prefer to run this course at your premises as you have several employees to place on the course perhaps, then we are also able to offer onsite VBA Training and bespoke VBA courses
The Access 2007 VBA Programming course qualifies for the PTR Training Passport SAVE IT Scheme, which offers discounts on bookings for multiple courses and/or multiple delegates.