Access 2016 - Level 3 - Queries and Records

About the course

The Access 2016 - Queries and Records course covers topics included in the Microsoft Office Specialist (MOS) exam 77-730. You will learn how to create Select, Action, Crosstab, Parameter and Multiple table queries. You will also find records using various methods, apply filters and sort data.

Modules

There are 6 modules in this course

  • Finding and Filtering Data
  • Sorting Records
  • Creating Basic Queries
  • Multiple Table Queries
  • Additional Query Options
  • Action Queries

Course features

  • Simulation training replicates the software you are learning providing a realistic learning experience.
  • Learn how to perform tasks at your own pace and interactively by following easy step-by-step actions.
  • Reinforce your knowledge at the end of each lesson by completing interactive and multiple choice quiz questions.
  • Assess your skills at any time by undertaking the Course Test.
  • Lessons can be completed within 30 minutes so training can be undertaken in “bite” size pieces.
  • Bookmarking allows you to learn in multiple training sessions.
  • Course navigation features allow you to jump directly to specific topics of interest quickly and easily.
  • Designed for people who require initial and refresher training activities.
  • Available on-line 24 hours a day.
  • Version for Mobile Devices.
  • Review course content with eBooks

You’ll learn how to:

Finding, Sorting and Filtering
Finding and Filtering Data

  • Find Text in Records;
  • Find Numbers in Records;
  • Find Dates in Records;
  • Replace Data;
  • Apply Filters;
  • Remove Filters;
  • Filter By Selection;
  • Use Filter By Form;
  • Close Forms

Sorting Records

  • Sort Records;
  • Sort Data in Tables;
  • Sort Data in Queries;
  • Sort Data in Forms.

Creating and Managing Queries
Creating Basic Queries

  • Create Queries;
  • Add Fields to Queries;
  • Clear the Query Grid;
  • Show and Hide Fields;
  • Sort Fields in Queries;
  • Move Fields in Queries;
  • Run Queries;
  • Rename Queries;
  • Delete Queries.

Multiple Table Queries

  • Use Multiple Table Queries;
  • Join Tables in Queries;
  • Add Selection Criteria;
  • Use Logical Operators;
  • Modify Criteria;
  • Delete Criteria;
  • Create Parameter Queries;
  • Use Or and Like Operators;
  • Use Wildcards.

Additional Query Options

  • Use Grouping in Queries;
  • Remove Tables;
  • Join Tables in Queries;
  • Use the Expression Builder;
  • Enter Expressions Manually;
  • Create Top Values Queries;
  • Format Calculated Fields;
  • Rename Expressions;
  • Create Crosstab Queries.

Action Queries

  • Understand Action Queries;
  • Create Make Table Queries;
  • Create Update Queries;
  • Create Append Queries;
  • Modify Queries;
  • Create Delete Queries.