Microsoft Access Level 2 - Intermediate Access

Powerup your Microsoft Access skills with more Advanced Access Tables, Queries, Forms and Reports

Go Beyond Access Basics

Take your Microsoft Access skills to the next level and enroll now and receive step-by-step mentoring on mastering Microsoft Access at an intermediate level. You will learn how to work with more advanced Access features including: Lookup Fields, Parameter and Update Queries, Filter and Sort records, Combo Box and how to Keep Groups Together.

Using my 18+ years of Microsoft Access training and Certification I will guide you through these more advanced features used by many offices to more easily manage their databases and daily tasks.  Below are just a few of the topics that you will master:

• How to set data entry defaults and using Validation Rules

• Show a field’s history and create Lookup Fields

• Hide duplicate values and records in a Query

• How to use Action Queries: Update, Append, Delete and Make Table

• Create Form drop-down lists to lookup values, or Combo Boxes

• Add Form Option Groups that controls the list of choices available for a user

• Add more space to your Forms without scrolling with Tabs

• Jump around quickly to other Access Objects by creating Form Command Buttons

• Add, Sort and Filter records in a Report, as well as keeping groups together

• Add summary fields to your Reports and include SubReports

• And much, much more!