Microsoft Access 2003 - VBA Programming (Visual Basic for Application)
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