Access VBA Programming Course 2003

Also known as Access Visual Basic for Applications Course 2003

Quick Links to Other Access Courses

1. Microsoft Access Basic Course
2. Microsoft Access Intermediate Course
3. Microsoft Access Advanced Course

Duration:

3 days

Prerequisites:

Access 2003 : Advanced or equivalent experience

• 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

• 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

• 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

• 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
  

• 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
  

• 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

• 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

• 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

• 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

• 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

• 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

• 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

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