Tel: 1300 TO TRAIN

Email: info@advancedtraining.com.au

IT Training with Advanced Training



VBA for Access (Intelligent Programming with VBA Access)


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 data-bases.

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 data-base
  • 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.

On-Site Training

If you need training for three or more people, ask us about training at your site. You can enjoy the convenience of reduced travel cost and time, as well as a familiar environment for your staff. Additionally, we can customise the course for your business needs.




User Reviews

Not yet rated. You will need to follow this course before you can write a review.

Course Info


Next Step

Enquire Now
Tell a Friend
Email Course Outline

Course files