Microsoft Access Level 2 – Intermediate Access

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!