Microsoft Access 2007/2010 VBA
Class timetable | Course outline
Course DescriptionThis 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 Level 3 class.
For added peace of mind, Training Connection’s Microsoft Access training comes with a 100% Money Back Guarantee.
If by lunchtime you don't feel that the program is for you, then you can leave the course at this point and receive a full refund of your course fees.
Access VBA Class Timetable
| Chicago | Mar 1 | Register |
| Los Angeles | Mar 8 | Register |
| Chicago | May 3 | Register |
| Los Angeles | Jun 7 | Register |
| Chicago | Jul 5 | Register |
* Class almost full ! Class guaranteed to run † Class is full
Learning 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.
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
What's included
Microsoft Access Training Manual
Certificate of Course Completion
6 Months FREE Repeat Policy
2 AMC Movie Vouchers
Related Courses
