Microsoft Access 2003 - Visual Basic for Applications
Those with a sound knowledge of Microsoft Access can learn to develop programs in VisualBasic for Microsoft Access 2003. Re-use code blocks, create efficient coding structures and learn standard and consistent VBA coding syntax.
Quick Facts
Duration: 3 Days
Class Size: 10
Level: Advanced
Times: 9.00am to 5.00pm approx
Other Microsoft Access 2003 Courses:
About the Course
This 3 day course teaches participants 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 practices. 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.
Who should do this course?
This is an advanced level course designed for people who have a thorough working knowledge of Microsoft Access, but need to learn VBA Programming techniques to improve their skills and productivity.
Prerequisites
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.
Course Units
- 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 and Recordsets
- - Overview of ADO with Forms and Recordsets
- - Navigating Records in a Form
- - Finding a Record
- - Updating a Record
- - Deleting a Record
- - Adding a New Record
- - ADO Forms and Recordsets Quick Reference
|
- Unit 12: 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
|
Upcoming Courses
|
Sydney
Level 11, 32 Walker Street
North Sydney
View map
|
- Date:
- 13-15 Dec 10
|
|
Melbourne
Level 12, 379 Collins Street
Melbourne
View map
|
- Date:
- 20-22 Oct 10
- 20-22 Dec 10
|
|
Brisbane
C/- Training Choice, Mezzanine Level, 88 Creek Street
Brisbane
View map
|
- Date:
- 29 Sep - 01 Oct 10
|
|
Canberra
C/- Training Choice, Level 4, 54 Marcus Clarke Street
Canberra
View map
|
Date: upon demand
|
|
Adelaide
C/- Mindfull Computer & Seminar, Level 4, 74 Pirie Street
Adelaide
View map
|
Date: upon demand
|
|
Perth
C/- Training Choice, Level 7, 105 St Georges Terrace
Perth
View map
|
Date: upon demand
|
Duration: 3 Days
Class Size: 10
Level: Advanced
Times: 9.00am to 5.00pm approx
