Access VBA Training: Introduction to Access 2007 VBA Including Your VBA Projects

Course Number: VBA-115
Duration: 2 days
view class outline

Access VBA Training Overview

Accelebrate's Introduction to Access 2007 VBA training course teaches experienced Access 2007 users how to automate Microsoft Access using VBA (Visual Basic for Applications).

Important Note: This version of the course includes a day of time spent working through your actual VBA projects. We also offer an “off the shelf” version of the course without your projects incorporated.

Location and Pricing

Most Accelebrate courses are taught on-site at our clients' locations worldwide for groups of 3 or more attendees and are customized to their specific needs. Please visit our client list to see organizations for whom we have recently delivered training. These courses can also be delivered as live, private online classes for groups that are geographically dispersed or wish to save on the instructor's or students' travel expenses. To receive a customized proposal and price quote private training at your site or online, please contact us.

In addition, some courses are available as live, online classes for individuals. To see a schedule of online courses, please visit http://www.accelebrate.com/online_training/?action=course&page=ACC301.

Access VBA Training Prerequisites

All attendees must be well-versed users of Microsoft Access 2007.

Hands-on/Lecture Ratio

This Access 2007 VBA training class is 70% hands-on, 30% lecture, with the longest lecture segments lasting for 20 minutes. Students "learn by doing," with immediate opportunities to apply the material they learn to real-world problems.

Access and Excel VBA Training Materials

All students receive comprehensive courseware and related textbook.

Software Needed on Each Student PC

This Access 2007 VBA training course requires:

Microsoft Access 2007(full installation including Visual Basic Help) with the latest service pack applied.

Access VBA Training Objectives

All students will be able to:

Use VBA within Microsoft Access 2007
Query and interact with database data via ADO (ActiveX Data Objects)
Debug VBA code
Integrate Access 2007 with other Office 2007 products via VBA

Access VBA Training Outline

Overview

Visual Basic Editor

Objects
Object Browser
Collections

Programming basics

Working with data
Scope

Control structures

Decision structures
Loop structures

ActiveX Data Objects

Getting started with ActiveX Data Objects
Working with ActiveX Data Objects

VBA debugging tools

Errors in code
Debugging techniques
Handling runtime errors

Office integration

Automating Office 2007
Working with Word from Access
Working with Excel from Access

One Day of Time on Your Actual VBA Projects

We would work with you in advance to determine the content and projects for this day

Conclusion

VB.NET, C#, ASP, & ASP.NET Training

Java Training

SQL Server Training
SharePoint Training

Adobe Training

“Accelebrate,” “Accelerated Learning Celebrated Results,” and the Accelebrate logo are registered trademarks of Accelebrate, Inc. All other product names and trademarks are property of their respective owners. Course outline content may mirror or be derived from the book that each student receives with the course. Otherwise, all content is copyright © 2003- by Accelebrate, Inc. of Atlanta, Georgia, USA. To contact us, please use the contact form, email info@accelebrate.com us, or call 1 877 849 1850 in the US and Canada, 0808 234 2132 in the UK, 1 800 550 311 in Ireland, or +1 678 648 3113 from all other locations.