Microsoft Access Training - VBA

Microsoft Access VBA Introduction– 2 Days

VBA Development Basics

• The Access Development Environment
• The Importance Of Splitting Databases
• Maintaining Links
• Using Queries For Reports And Forms
• Understanding Client/Server

Macros And VBA

• Macro Overview
• Creating Macros
• Assigning Macros
• Creating More Complex Macros
• Converting Macros To VBA Code
• Why You Shouldn't Use Macros

VBA Essentials

• Programming Environment Overview
• The Role Of Forms
• Creating A Startup Form
• Understanding Modules
• Code Behind Forms
• Naming Conventions

VBA Subroutines

• Creating A Subroutine
• Creating A Function
• Calling Procedures
• Passing Parameters
• Returning Values
• Scoping Procedures

VBA Variables

• Overview Of Variables
• Option Explicit
• Default Values
• Scoping Variables
• Local Variables
• Module-Wide Variables
• Passing Parameters
• Passing Parameters By Value

Debugging VBA

• Overview Of Debugging
• Setting A BreakPoint
• Stepping Through A Procedure
• Viewing The Call Stack
• Using The Locals And Immediate Windows
• Adding A Watch

Interactive VBA

• The Act Of Communicating
• Creating A Simple Input Box
• Simple Message Boxes
• Creating Larger Messages
• Breaking A Message Line
• Message Box Functions
• Responding To Different Buttons

Decisive VBA

• Decisions Overview
• Creating An In-Line If
• Creating A Block If
• Multiple If
• Using Case Statements
• Value Ranges In Case Statements

Looping VBA

• Program Loops
• Creating A While Loop
• Creating An Until Loop
• For Each Loops
• Exiting From Loops
• For Next Loops

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

ActiveX Data Objects

• 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

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

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