Your Access to the World

November 2004

Finally! the definitive training for Access, learn at your own pace!

Buy Now »

Completely Visualized in Full Color

Finally - visual training covering every aspect of Access. This 1650 slide, self-paced training package is loaded with informative topics. Pick and choose from the eight days of training and learn at your pace on your own schedule.

Completely Visualized!

Learn Access in full color. Every slide has rich illustrations to demonstrate the concept.

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 Access Seminars. He has taught this course to thousands with rave reviews! If you can't schedule Gerry at your office, then the next best thing is to buy this CD!

Look at everything you will learn!

You get three complete modules on the CD covering 1650 slides.

• Module 1 - Access Infrastructure

  • Relational Databases

    • Multiple Tables
    • One-To-Many Relationships
    • Many-to-Many Relationships

  • The Table Warehouse

    • Data Types
    • Format vs. Input Mask
    • Validation Rules
    • Lookup Values
    • Relationships

  • Query Spiders

    • Sorted Searches
    • Filtered Searches
    • Parameter Filters
    • Multiple Tables

  • Interactive Forms

    • Navigation
    • Form Design
    • Properties & Calculations
    • Forms inside Forms

  • Reporting Tools

    • Designing Reports
    • Calculated Reports
    • Multiple Source Reporting
    • Filtered Reports

• Module 2 - Access Superstructure

  • Importing and Linking

    • Transferring Databases
    • Converting Databases
    • Establishing Relationships

  • Total Queries

    • Summaries
    • Calculated Fields
    • Cross Tab Queries

  • Forms with Subforms

    • Columnar Subforms
    • Tabular Subforms
    • Datasheet Subforms
    • Lookup Connections
    • Special Controls
    • Cross-tab Forms
    • Pivot Tables and Charts

  • Action Queries

    • Update Queries
    • Append Queries
    • Delete Queries
    • Cascading Actions

  • Reports Revisited

    • Grouped Reports
    • Summaries and Details
    • Reports within Reports
    • Labels
    • Mail Merge

• Module 3 - Access Control Tower

  • Maintaining Databases

    • Maintenance
    • Permissions and Security
    • Fixing Structural Flaws
    • Databases on the Web

  • Let Macros do the Work

    • Macro Basics
    • Conditional Macros
    • Tab Order Issues
    • More Events
    • Macro Interactions
    • User Forms with Macros
    • More Controls: ActiveX

  • Database Development

    • Divide and Rule
    • Switchboards + Toolbars
    • Splash Screens
    • AutoKeys + AutoExec

  • Basic Programming

    • Interaction: Input and Output
    • Controlling Controls
    • Using Variables
    • Creating Functions
    • Using Loops
    • Filter Forms
    • Forms for Interaction

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 1650 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 Slide Your Way Through Excel VBA and Excel for Scientists.