Access - Programming in VBA 2003

Cost: $1090.00   Duration: 2 days

Prerequisite
This course is designed for participants who have completed the Microsoft Access 2000/2002 Level 2 course or equivalent knowledge.

Objectives
To increase your productivity by providing the skills and knowledge to program VBA in Microsoft Access 2000/2002 effectively.

Methodology
Group and individual instruction, hands on practical exercises, visual aids, comprehensive course documentation.

At Drake Training, we've made it easier for students to complete their Microsoft applications training by combining all versions into one single session.

Users of the various Microsoft 2000, XP and 2003 applications will find that our courses prepare them to use all three products, which also means that our courses run more frequently since individual versions are not run in isolation. Our Office courses are also aligned to Microsoft Office Specialist certifications.

Content:

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

Macros And VBA
Creating Macros
Assigning Macros
Creating More Complex Macros
Converting Macros To VBA Code
Why You Shouldn't Use Macros
Macros and VBA Quick Reference

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

VBA Subroutines
The Anatomy of a Module
Creating a Subroutine
Creating a Function
Calling Procedures
Passing Parameters
Returning Values
Scoping Procedures
VBA Subroutines Quick Reference

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

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

Decisive VBA
Creating an In-Line If
Creating a Block If
Multiple If

Decisive VBA - Continued
Multiple If Using Text
Using Case Statements
Value Ranges in Case Statements
Case Statements with OR
Asking Yes/No Questions
Decisive VBA Quick Reference

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

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

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

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

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

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