Over a Decade of Serious Learning
for Ambitious Minds.
* 9.3 of 10 (over 13 k student survey results - 2015)
1-877-760-0078
Request a quote

Find A
Class in Your City:

Microsoft Access 2003 - VBA Programming (Visual Basic for Application)
Email this page | Print this page

Microsoft Access VBA

* Training at your company site (group or 1on1) -- click here.


Course Description
This course on Microsoft Access: VBA Programming is designed for experienced Access users who want to learn ActiveX data objects, control structures, and the basics of VBA programming. This manual is designed for quick scanning in the classroom, and filled with interactive exercises.

Performance Objectives

  • Work with objects, use Object Browser, identify collection objects, and use the Controls collection.
  • Manipulate data by declaring variables, combine data by using expressions, get user input, create Sub and Function procedures, and call one procedure from another.
  • Use decision structures and use loop structures.
  • Identify ActiveX Data Objects (ADO) architecture and collections, connect to a database, work with a Recordset, and create a parameter query.


Prerequisites
To ensure the successful completion of Microsoft Office Access: VBA Programming, we recommend the equivalent knowledge (familiarity with basic and intermediate features of Access tables, relationships, queries, forms, and reports):


Who Should Take This Course?
Microsoft Access: VBA Programming is for students who have a thorough understanding of the basic and advanced user features of the Access program, and are interested in learning introductory level administrator skill sets. The course is also for the student that may be working in a web-based environment and may need to adapt Access applications to the environment.


Course Contents

Unit 1: Visual Basic Editor

Topic A: Objects
Topic B: Object Browser
Topic C: Collections

Unit 2: Programming basics

Topic A: Data
Topic B: Scope

Unit 3: Control structures

Topic A: Decision structures
Topic B: Loop structures

Unit 4: ActiveX Data Objects

Topic A: Getting started with ActiveX Data Objects
Topic B: Working with ActiveX Data Objects

Unit 5: VBA debugging tools

Topic A: Errors in code
Topic B: Debugging techniques
Topic C: Handling run-time errors

Appendix A: Office integration

Topic A: Automating Office 2003
Topic B: Working with Word from Access
Topic C: Working with Excel from Access