About this Course

This VBA Access Course taught in Singapore is a 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 Access programming language to simplify many of the tasks in VBA Access 2007 & VBA Access 2010 environment.

Participants will be proficient in using VBA to create macros for automating repetitive tasks in Access 2007 & Access 2010.

Course Outline:

1 : Introduction to VBA in Microsoft Access 2007/2010

2 : VBA Variables

3 : Working with Procedures and Functions

4 : Conditions, Branches and Looping Control

5 : Debugging in VBA Access

6 : Error Handling

7 : Collection of Objects and DoCmd

8 : Forms and Report Events

9 : Microsoft Access Object Library

10 : Introduction to Recordsets

11 : Manipulating Recordsets

Prerequisites:

Prior knowledge of Access 2007 and especially suitable for students attended Access 2007/2010 Intermediate and Advance course.

Certificate Of Attendance:

Certificate Of Attendance will be awarded to students achieving minimum 75% attendance.

Training Duration:

Full-time: 3 Days                Time : 9.30am - 5.30pm 

Part-time: 6 Sessions        Time : 7.00pm - 10.00pm (twice a week)

Rate this course:

Log in to submit

Comments