Visual Basic for Application (VBA) for Access
2003
Course Objective:
This 3-day course guides participants in
using some of Access's commonly used formulas.
Participant will also learn how to simplify
your work in the Access environment by automating
many of the repetitive tasks that are part
of database development. In this course, participant
will apply the Visual Basic for Applications
(VBA) programming language to simplify many
of the tasks in Access 2003 environment.
Participants will be proficient in using VBA
to create macros for automating repetitive
tasks in Access 2003.
Prerequisites:
Prior knowledge of Access 2003 and especially
suitable for students attended Access 2003
Intermediate and Advance course.
Certificate Of Attendance:
Certificate Of Attendance will be awarded to
students completing the course.
Training Duration:
Full-time: 3 Days Time : 9.00am - 5.00pm
Part-time: 6 Sessions Time : 6.30pm - 10.00pm (twice a week)
Course Outline:
1. Getting Started
2. Working with Procedures and Functions
3. Using Expressions, Variables, and Intrinsic
Functions
4. Controlling Program Execution
5. Working with Recordsets
6. Debugging Code