A New York State Certified Woman-Owned Business Enterprise
BEAHIVE Training in Downtown Albany!
MicroKnowledge, Inc.
21 British American Blvd.
Latham, NY 12110
Phone: 518.786.1181
Fax: 518.786.6221
Access 2007 VBA Programming
Description:
This course is designed to help individuals new to Visual Basic learn the basics of programming in Access, create dynamic forms only possible through VBA, execute actions through conditional statements and loops, and understand and debug code.
This course is appropriate for individuals who need a better understanding of Visual Basic, or who need to automate more complex actions for users of their database. Prior knowledge of Visual Basic is not required.
Includes:
Comprehensive reference manual with participant guide and exercises
Visual Basic Command Reference card, created by MicroKnowledge specifically for this course
Access to participant data files
Follow-up support by email or phone for an unlimited period
Lesson 1: Visual Basic Editor
- Using Objects
- Changing Properties
- Using Methods
Lesson 2: Programming basics
- Working with Data
- Understanding Scope
Lesson 3: Control structures
- Decision structures
- Loop structures
Lesson 4: ActiveX Data Objects
- Getting started with ActiveX
- Data Objects
- Declaring and Opening Recordsets
- Using Recordset Methods
Lesson 5: VBA debugging tools
- Understanding Errors in Code
- Using Debugging Techniques
- Handling Run-Time Errors
