Course Description

This course aims to increase your productivity by providing the skills and knowledge to program VBA in Access 2003 effectively.

Pre-Requisites

This course is designed for participants who are proficient users of Access 2003.
Participants should have extensive experience in formatting, reports, queries and relational databases.

Outcomes

At the completion of this course, participants will be able to:

• Understand some of the aspects of developing applications in Access 2003
• Create and assign macros and understand the advantages and disadvantages of using macros
• 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
• Input/Message boxes
• 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 your programs
• Use ADO to handle working with data in your programs
• Debugging features
• Error checking and safeguarding