Access 2003 VBA - Advanced Plus
Course Information
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.
Pre-requisites
Those attending this course need a thorough knowledge of the features within Access in order to evaluate where macros and visual basic are required. Previous experience of programming is not assumed.
Course Objectives
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 windows
- 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
What you will learn:
Day One
Lesson 1 – VB Coding
VB Coding v’s Macros
The VB Editor
Simple Routines
Lesson 2 – VB Variables
Recognise VB Variables
Variable Commands
Variable Types
Lesson 3 – Procedures
Create Sub Procedures
Create Function Procedures
Pass Data
Lesson 4 – Routines
Repetition Routines
Decision Making
Error Handling
Day Two
Lesson 5 – De Bugging
Testing routines
De bug facilities
Lesson 6 – Objects
Attaching coding to Objects
The Object Browser
Object Variables
Lesson 7 – External References
Creating References to External Projects
Creating References to External Libararies
Controlling other MS Office Applications
