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.

Udemy logo

Microsoft Access Level 2 - Intermediate Access

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

     
  • 4.4
  •  |
  • Reviews ( 58 )
₹2499

This Course Includes

  • iconudemy
  • icon4.4 (58 reviews )
  • icon5 total hours
  • iconenglish
  • iconOnline - Self Paced
  • iconcourse
  • iconUdemy

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.