Microsoft Access Level 2 - Intermediate Access

  • Course provided by Udemy
  • Study type: Online
  • Starts: Anytime
  • Price: See latest price on Udemy

Course Description

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!

Expected Outcomes

  1. Get more accurate data entry by controlling a user’s input with controls
  2. Find unique values and records, and using wildcards
  3. Create prompts and do mass record updates with Action Queries
  4. How to Filter and Sort records in Forms and Reports
  5. Bring more functionality to Form with Tabs, Combo Boxes and Command Buttons
  6. Quickly summarize the details of your records in Forms with Subforms
  7. Quickly summarize the details of your records in Forms with Subforms
  8. Taught by Certified Microsoft Office Access 2000, 2002, 2003, 2007, 2010, 2013 & 2016 Specialist with over 17 years of Access training