Access 2003 VBA Workshop

Dynamic Web Training Pty Ltd.
Adelaide, Brisbane, Canberra, Melbourne, Sydney, Australia

Course Format: Classroom | E-learning | Virtual Class | Online | On-site | Blended | Self-paced

Course Description:

'' This course is designed for participants with little or no knowledge of programming.

However a sound working knowledge if 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 effectively.

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, students will be able to:
* understand the 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 your programs
* use ADO to handle working with data in your 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
...''

Phone:1300 888 724, +61 2 9957 1366

School Address:

Level 11
32 Walker Street
North Sydney NSW 2060

Level 12
379 Collins Street
Melbourne VIC 3000

C/- Support Technology
Level 6, 371 Queen St
Brisbane QLD 4000

C/- Training Choice
Level 12, 15 London Circuit
Canberra ACT 2600

C/- Hire Intelligence
Level 4, 74 Pirie Street
Adelaide SA 5000

Jobs & Resumes: Adelaide, Brisbane, Canberra, Melbourne, Sydney
Houses & Roommates: Adelaide, Brisbane, Canberra, Melbourne, Sydney
Travel Agencies: Brisbane, Melbourne, Sydney

Search other schools for Access 2003 VBA training resources.

Illustrator CS3
InDesign CS3
Excel 2007 Level 1
Excel 2007 Level 2
Excel 2007 Level 3
Excel 2003 VBA
Word 2007 Level 1
Word 2007 Level 2
Word 2007 Level 3
Access 2003
PowerPoint 2003 Level 1
PowerPoint 2003 Level 2
Outlook 2007 Level 1
Outlook 2007 Level 2
Microsoft Project 2003
Microsoft Office 2007
Fast Track to MYOB
MYOB Payroll

Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
 

Tips: Besides Acquiring latest course information by the search form, Students can also leave their study interests here and let schools callback.