VBA using Access

Date	Location	Duration	Cost
21 Sep 2010 (Tue) 22 Sep 2010 (Wed) 23 Sep 2010 (Thu) 24 Sep 2010 (Fri)	Washington	4	£ 975
06 Dec 2010 (Mon) 07 Dec 2010 (Tue) 08 Dec 2010 (Wed) 09 Dec 2010 (Thu)	Washington	4	£ 975
11 Apr 2011 (Mon) 12 Apr 2011 (Tue) 13 Apr 2011 (Wed) 14 Apr 2011 (Thu)	Washington	4	£ 975
14 Jun 2011 (Tue) 15 Jun 2011 (Wed) 16 Jun 2011 (Thu) 17 Jun 2011 (Fri)	Washington	4	£ 975
Please contact us to discuss private course dates and locations

Course Overview

This course is aimed at those who would like to develop their skills and knowledge of VBA programming in Access application development.

Delegates should have attended Access Level 2 and/or Level 3 courses or have equivalent knowledge.
Delegates should be currently working with an Access database application that they have built themselves.
Delegate should also understand table, query, form, report and macro design and function, as well as data normalization and table relationships.

Delegates will be able to:

Explain the difference between sub and function procedures in VBA code
List 3 common events and in where they might use them in application design
Write professional VBA code segments with error checking to carry out tasks as defined by your tutor
Use the AccessObject object to create an intelligent report selection form
Build a browse form for quick navigation to a specific record
Create a flexible report such that people may choose its content at run-time
Describe how to debug VBA code

Scheduled public courses at one of our training venues
Private course at your company office throughout the UK, at one of our training venues (Durham, Newcastle or Washington) or at an independent location, convenient to you
Bespoke course written to your specific needs, at your company office throughout the UK, at our training venue or at an independent location, convenient to you
For further information please contact us on 0191 377 8377