Microsoft Access Level 2 - Intermediate Access

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!

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

Url: View Details

What you will learn

• Get more accurate data entry by controlling a user’s input with controls
• Find unique values and records, and using wildcards
• Create prompts and do mass record updates with Action Queries

Rating: 4.55

Level: Intermediate Level

Duration: 5 hours

Instructor: Kirt Kershaw