Access 2007 VBA Programming Course
Course DescriptionThis 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.
|
£335 1 day course Scheduled Dates: 20 January 2012 17 February 2012 16 March 2012 13 April 2012 11 May 2012 08 June 2012 Location: PTR's Training Centre Wokingham, Berkshire. |
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:
Technical Training Course
This is an instructor led training course taught in a classroom based environment.
Scheduled course dates
20 January 2012 to 20 January 2012
17 February 2012 to 17 February 2012
16 March 2012 to 16 March 2012
13 April 2012 to 13 April 2012
11 May 2012 to 11 May 2012
08 June 2012 to 08 June 2012
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