For information on course costs and booking onto a course, please click here. For any queries please contact us on business@nptcgroup.ac.uk or call: 0330 81 88 100Welcome, Guest

Access 2021 - Level 3 - Queries and Records

About the course

The Access 2021 - Queries and Records course covers topics included in the Microsoft Office Specialist (MOS) exam. 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

  • Finding Text in Records;
  • Finding Numbers in Records;
  • Finding Dates in Records;
  • Replacing Data;
  • Applying Filters;
  • Removing Filters;
  • Filter By Selection;
  • Filter By Form;
  • Closing Forms.

Sorting Records

  • Sorting Data;
  • Sorting Tables;
  • Sorting Queries;
  • Sorting Forms.

Creating and Managing Queries Creating Basic Queries

  • Queries;
  • Creating Queries;
  • Adding Fields to Queries;
  • Removing Fields from Queries;
  • Clearing the Query Grid;
  • Adding Fields as One Entry;
  • Deleting Columns from Query Grid;
  • Adding Fields to Queries;
  • Showing and Hiding Fields;
  • Sorting Fields in Queries;
  • Viewing Query Results;
  • Moving Fields in Queries;
  • Running Queries;
  • Closing Queries;
  • Renaming Queries;
  • Deleting Queries.

Multiple Table Queries

  • Multiple Table Queries;
  • Joining Tables in a Query;
  • Adding Multiple Fields;
  • Running the Query;
  • Adding Selection Criteria;
  • Using Logical Operators;
  • Modifying Criteria;
  • Deleting Criteria;
  • Creating Parameter Queries;
  • Or and Like Operators;
  • Using Wildcards.

Additional Query Options

  • Grouping in Queries;
  • Removing Tables;
  • Joining Tables in a Query;
  • Using the Expression Builder;
  • Entering Expressions Manually;
  • Top Values Queries;
  • Formatting Calculated Fields;
  • Renaming Expressions;
  • Creating Crosstab Queries.

Action Queries

  • Query Types;
  • Creating Make Table Queries;
  • Creating Update Queries;
  • Creating Append Queries;
  • Modifying Queries;
  • Creating Delete Queries.