Back

About MrExcel
Consulting Services
Learn Excel Resources
Challenge of the Month
MrExcel Seminars

Message Board

MrExcel Store
Podcast
Search
Media
Contact
Home

 

 


Click here to order the CD!

 

  This training tool provides a solid foundation
for those who want to develop Access databases!

Access 2007 VBA Made Accessible
How to Steer Access 2007 Using Visual Basic for Applications

Designed as a Training Tool
This training CD-ROM allows Access users to advance to the next level by using Visual Basic for Applications (VBA). From learning total control of coding to employing various variables and spotting errors, this resource provides a solid foundation for those who want to develop Access databases.Learn how to make VBA work more efficiently with Access 2007 to automate your databases and accomplish tasks performed manually.

Completely Visualized!
Containing more than 1,110 step-by-step slides, this user-friendly guide ensures total absorption of the material by encouraging a self-paced training program.

Self-Paced with Self-Checks!
Click through the slides at your own pace. Every few slides, there will be a multiple choice question to ensure you've mastered recent concepts. These are the same concepts taught during Dr. Verschuuren's Excel Seminars. If you can't schedule Gerry at your office, then the next best thing is to buy this CD!

Click here to order the CD!

Look at everything you will learn!
You get three complete modules on the CD covering 1150 slides.

Part 1

    1. Object-Oriented
    • Object Browser
    • Properties and Events
    • Subs and Functions

    2. Code Control
    • Branching
    • Interaction

    3. Variables
    • Value Data Type
    • Collections
    • Object Data Type

    4. Loops
    • Do Loops
    • For Loops
    • For-Each Loops

    5. Error Handling
    • Access Errors
    • VBA Errors

Part 2

    1. Custom Procedures
    • Custom Subs
    • Custom Functions

    2. DAO Recordsets
    • Navigation
    • Manipulation

    3. Arrays and Collections
    • Arrays
      • Variant Arrayss
      • 1D and 2D Arrays
      • Typed Arrays
      • Functions and Arrays
    • Collections

    4. SQL and Transactions
    • SQL to Select Data
    • SQL to Summarize Data
    • SQL to Modify Data
    • SQL to Remove Duplicates
    • Transactions

Part 3

    1. Navigation in a Daisy DB
    • Queuing
    • Cascading
    • Switchboard
    2. Dynamic Requests
    • Binding
    • Synchronizing
    • Building on the Fly
    3. Ins and Outs
    • Exporting into Excel
    • Importing from Excel
    • Email and PDF Files
    4. Add-Ins
    • Building Add-Ins
    • Using Add-Ins
    5. Custom Classes
    • Building Classes
    • Using Classes
    • Class Collections
    6. Protection + Security


Click here to order the CD!

An Incredible Bargain!
Compare this course to anything else. You could visit a training center at a local computer chain and pay $225 for a one-day course. Once that course is over, it is over. With the CD-ROM, you can play the course over and over, reviewing just the items that you need to review. Rather than be out of the office for an entire day, you can insert the CD and get training on a certain section on an as-needed basis. Pass the CD around your department and train everyone for one low price. With 1,110 slides, this course runs circles around any other training.

About the Author
Dr. Gerard M. Verschuuren is a Microsoft Certified Professional specialized in VB, VBA, and VB.NET. He is the author of many textbooks and has more than 20 years of experience in teaching at colleges and corporations. He holds master's degrees in Biology and in Philosophy, plus a Doctorate in the Philosophy of Science from Universities in Europe. He is author of the Visual Training Series including Excel 2007 VBA CD-ROM, Excel 2007 for Scientists CD-ROM, See Sharper with C# DVD, and Excel 2007 Expert CD-ROM.

Product Details
CD-ROM: 1,110 Slides
ISBN-10: 1932802398
ISBN-13: 978-1932802399
System Requirements: PowerPoint 2007
Publisher: Holy Macro! Books;
Price: $99

If installing in Vista, read this note.


Click here to order the CD!

 

Excel is a registered trademark of the Microsoft® Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.

All contents Copyright 1998-2008 by MrExcel Consulting.