Adobe Training
Acrobat Training
Captivate Training
Dreamweaver Training
Flash Training
Flex Training
Illustrator Training
InDesign Training
Photoshop Training
Web Development
AJAX Training
CSS Training
HTML Training
JavaScript Training
PHP MySQL Training
Ruby on Rails Training
XML Training
Microsoft Office
Access Training
Excel Training
Outlook Training
PowerPoint Training
Project Training
Visio Training
Word Training
Business Skills
Anger Management Class
Business Communication
Business Etiquette Training
Business Writing Class
Change Management
Customer Service Training
Project Management Training
Sales Training
Supervisor Training
Time Management Training
QuickBooks
QuickBooks Training
Access VBA Training | Chicago
Fast Facts
Duration
1 day
1 day
Class Size
Max 8 students
Max 8 students
Times
9.00am to 4.30pm
9.00am to 4.30pm
Computer
One per student
One per student
Training Manual
Included
Included
Price
395.00
395.00
Access 2003 - VBA
Course Description
This Access VBA course is designed for experienced Access users who want to learn ActiveX data objects, control structures, and the basics of VBA programming.
Target Audience
Experience Access users looking to learn Access VBA. Students should already have good working knowledge of Access or have completed our Access 2003 Level 3 class.
Leaning Objectives
Upon successful completion of this Access VBA training course students will be able to:
- VBA Terminology.
- To work with Objects, their Properties, Methods, and Events.
- Using Variables, Procedures and Functions in VBA.
- Control Structures to Execute Code.
- ActiveX Data Objects.
- Work with a Recordset and Parameter query.
- Learn Debugging Tools.
Course Outline
Visual Basic Editor
- Visual Basic Terminology
- Work with Objects, their properties, methods, and events
- Use Object Browser to get information about Objects
- Identify Collection Objects and use Collection Control
Programming Basics
- Manipulate and Combine Data to get User input
- Declare Variables and Procedures
- Create Sub and Function Procedures
- Call one Procedure from other
Control Structures
- Use Decision Structures to create procedures that execute code
- Use Loop structures to execute code repeatedly
ActiveX Data Objects
- Examine ActiveX Data Objects architecture and collections
- Connect to a Database
- Work with a Recordset and Parameter query
VBA Debugging Tools
- Identify compile-time, run-time and logical errors
- Use the Debugging Tools
- Write Error-handling code to trap errors
