Quasar Courses Page

Course Information

Duration:

2 days

Microsoft Access 2002/2003
Introducing VBA in Access

This two day course is designed to introduce and explore the capabilities of Visual Basic for Applications within Access. Delegates will learn the basics of structured coding and how to utilise simple forms in application development.

Those attending this course need a thorough knowledge of the features within Access 97 in order to evaluate where macros and visual basic are required. Previous experience of programming is not assumed.

By the end of the course delegates will be able to:

Recognise when Visual Basic coding rather than Macros might be required.
Navigate the various elements that comprise the VB Editor window.
Write simple routines triggered by actions of the database user.
Recognise when to use Visual Basic Variables.
Recognise the Variable code commands and types.
Create Sub and Function Procedures.
Pass data between separate procedures.
Effectively control Repetition and Decision Making within routines.
Build routines that handle Errors internally.
Utilise the Debug facilities available in Access to test coding.
Attach coding to objects and events on Access Forms.
Utilise the Object Browser.
Create References to external libraries and projects.
Utilise Object Variables.
Control other MS Office applications from Access modules.