Microsoft Access 2003 - Visual Basic for Applications

Who should do this course?

This course is designed for participants with little or no knowledge of programming, however a sound working knowledge of Access 2003 is essential, including formatting, reports, queries and relational databases.

About the course:

This course aims to increase your productivity by providing the skills and knowledge to develop programs in VBA for Microsoft Access 2003. A workshop is conducted at the end of the course to reinforce the concepts taught during the session. The aim of the workshop is to put into practice the skills taught during formal sessions, and to foster good coding skills. Special emphasis will be placed on re-usability of code blocks, creation of efficient coding structures and application of standard and consistent VBA coding syntax.

Learning outcomes:

Upon successful completion of this course, participants will be able to:

• understand aspects of developing applications in Access 2003
• use macros in Access 2003
• understand the programming environment and how forms and modules are used in it
• create and work with subroutines and function procedures
• create and work with variables
• communicate with the user through input boxes and message boxes
• program decision structures using IF and CASE statements
• develop a variety of programming loops for repeating operations
• use the DoCmd object to perform most of the operations associated with a database
• use DAO to handle working with data in programs
• use ADO to handle working with data in programs
• use the debugging features of VBA to locate and identify errors
• develop safeguards in your program and prevent unforeseen errors
• understand the role of syntax, and be able to create well-formed code
• develop an appreciation of the importance of planning within VBA