Microsoft Access 2003 VBA

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 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

After the course?

Each student will receive:
* Microsoft certificate of completion
* Microsoft Aproved Training Manual
* 12 months FREE email support
* FREE class re-sit (if necessary)

Duration:

3 Day

Class size:

Max 10 Students

Times:

9.00am to 5.00pm approx

Price:

$1320 incl GST

Content:

Unit 1: Development Basics

* The Access Development Environment
* The Importance Of Splitting Databases
* Maintaining Links
* Using The Database Splitter
* Using Queries For Reports And Forms
* Access Run-Time
* Understanding Client/Server
* Development Basics Quick Reference
* On Your Own

Unit 2: Macros And VBA

* Macro Overview
* Creating Macros
* Assigning Macros
* Creating More Complex Macros
* Converting Macros To VBA Code
* Macros Versus VBA
* Macros and VBA Quick Reference
* On Your Own

Unit 3: VBA Essentials

* Programming Environment Overview
* The Role Of Forms
* Creating A Startup Form
* Understanding Modules
* Code Behind Forms
* Standard Code Modules
* Standard Vs Class Modules
* Naming Conventions
* VBA Essentials Quick Reference

Unit 4: VBA Subroutines

* Understanding Modules In Access
* The Anatomy Of A Module
* Creating A Subroutine
* Creating A Function
* Calling Procedures
* Passing Parameters
* Returning Values
* Scoping Procedures
* VBA Subroutines Quick Reference

Unit 5: Variable VBA

* Overview Of Variables
* Creating String Variables
* Option Explicit
* Working With Numbers
* Dealing With Overflows
* Working With Decimals
* Working With Dates
* Default Values
* Scoping Variables
* Local Variables
* Module-Wide Variables
* Passing Parameters
* Passing Parameters By Value
* Variable VBA Quick Reference

Unit 6: Interactive VBA

* The Act Of Communicating
* Creating A Simple Input Box
* Creating More Elaborate Input Boxes
* Global Positioning
* Simple Message Boxes
* Creating Larger Messages
* Breaking A Message Line
* Customising Icons And Buttons
* Message Box Functions
* Responding To Different Buttons
* Interactive VBA Quick Reference

Unit 7: Decisive VBA

* Decisions Overview
* Creating An In-Line If
* Creating A Block If
* Multiple If
* Multiple If Using Text
* Using Case Statements
* Value Ranges In Case Statements
* Case Statements With OR
* Asking Yes/No Questions
* Decisive VBA Quick Reference

Unit 8: Looping VBA

* Program Loops
* Creating A While Loop
* Taking Care Of Counters
* Creating An Until Loop
* For Each Loops
* Exiting From Loops
* For Next Loops
* Looping VBA Quick Reference

Unit 9: The DoCmd Object

* Overview Of DoCmd
* Navigating With DoCmd
* Moving Through Records
* Filtering Records With DoCmd
* Opening A Form With DoCmd
* Opening A Report With DoCmd
* Closing A Form
* Creating Variable Reports
* The DoCMD Object Quick Reference

Unit 10: ActiveX Data Objects - Tables

* Overview Of ADO
* Setting References Using VBA
* Creating A Table With ADO
* Removing A Table Using ADO
* Populating A Form Using ADO
* Dealing With An Empty Table
* ActiveX Data Objects Quick Reference

Unit 11: ADO Forms & Recordsets

* Overview Of ADO With Forms & Recordsets
* Navigating Records In A Form
* Finding A Record
* Updating A Record
* Deleting A Record
* Adding A New Record
* ADO Forms & Recordsets Quick Reference

Unit12: Debugging VBA

* Overview Of Debugging
* Setting A BreakPoint
* Setting Additional Breakpoints
* Stepping Through A Procedure
* Viewing The Call Stack
* Using The Locals And Immediate Windows
* Adding A Watch
* Deleting A Watch
* Debugging VBA Quick Reference

Unit 13: Handling Errors In VBA

* Error Handling Overview
* Understanding Common Errors
* Creating A Simple Error Handler
* Understanding The Error Object Model
* More Elegant Error Handling
* Resuming From Errors
* Forcing An Error
* Creating Custom Errors
* Handling Errors Quick Reference.