When you enroll through our links, we may earn a small commission—at no extra cost to you. This helps keep our platform free and inspires us to add more value.

Microsoft Access Level 2 - Intermediate Access
Powerup your Microsoft Access skills with more Advanced Access Tables, Queries, Forms and Reports

This Course Includes
udemy
4.4 (58 reviews )
5 total hours
english
Online - Self Paced
course
Udemy
About 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!
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.
- How to Filter and Sort records in Forms and Reports.
- Bring more functionality to Form with Tabs, Combo Boxes and Command Buttons.
- Quickly summarize the details of your records in Forms with Subforms.
- Quickly summarize the details of your records in Forms with Subforms.
- Taught by Certified Microsoft Office Access 2000, 2002, 2003, 2007, 2010, 2013 & 2016 Specialist with over 17 years of Access training.