Microsoft Access 2007 VBA Training

How To Take This Class:

• Live Instructor-Led Online Class   > View Schedule or Register
• Onsite Group Training   > Request Pricing

Instructor-Led Online Course Tuition:

$245.00

Course Duration:

1 Day

What Students Receive:

Each student will receive:

• A printed courseware manual with hands-on exercises for use during and after class.
• A CertBlaster pre- and post-assessment software key to assess your knowledge both before and after class.
• A PC headset for communicating with your instructor and fellow students during your Microsoft Access 2007 Training Class
• A course completion certificate upon successful completion of your Microsoft Access 2007 Training course
• Six months of post-class email support from a Microsoft Access Instructor

Course Description:

This Microsoft Access 2007 VBA Training course is designed for experienced Access 2007 users who want to learn ActiveX Data Objects, control structures, and the basics of VBA programming. This course comes with CertBlaster pre- and post-assessment software (download) so students can assess their knowledge both before and after class. In the course students will exchange data with other applications, automate business processes by using VBA code, and learn how to find and fix errors in VBA code.

Course Objectives:

Upon successful completion of this course, students will be able to:

• Work with Objects, use the Object Browser, identify Access 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 such as If / Then and use looping structures in VBA.
• Identify ActiveX Data Objects (ADO) architecture and collections, connect to a database, work with a Recordset, and create a parameter query.
• Identify compile-time, run-time, and logical errors and use the debugging tools.
• Write error-handling code.

Course Audience:

This course is designed for students who have a thorough understanding of the basic and advanced user features of the Microsoft Office Access™ 2007 application, and are interested in learning introductory level Visual Basic for Application programming skills.

Course Prerequisites:

Students should have completed, or have experience with, topics covered in the Microsoft Access 2007 Introduction, Intermediate and Advanced Training courses.

Course Syllabus:

1. Visual Basic Editor
• Working with Objects in Access 2007
• Using the Object Browser
• Working with Access Collections
2. VBA Programming basics
• Working with data
• Understanding Scope
3. Control structures
• Using Decision structures
• Creating Loop structures
4. Using ActiveX Data Objects
• Getting started with ActiveX Data Objects
• Working with ActiveX Data Objects
5. VBA debugging tools
• Finding and fixing errors in code
• VBA Debugging techniques
• Handling runtime errors
6. Using VBA for Office Integration
• Automating Office 2007
• Working with Word from Access
• Working with Excel from Access