About the course

The Access 2019 - 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

  • 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.

 

This course has a minimum of 25 learner registrations for us to provide a quotation.

Request a Quotation
Language
UK
Date last updated
2/6/2020
Duration
3 Hours 5 Minutes
Suitable Devices
  • PC
  • Phone
  • Tablet
Audio is Required
  • Yes
Includes Video
  • No
Downloadable Resources
  • eBook
  • Hints and Tips
Completion Criteria
  • Multiple Choice Assessment
Pass Mark
  • 70% pass mark required
Course Technology
  • HTML5
  • SCORM 1.2
Can be customised
  • No
Accreditation or Endorsements
  • No
Languages
  • English
Image of a SkillStation dashboard

Let's get started

with a demo and a 30-day free trial.

Cookies

To provide you with the best experience, we use cookies. You can read the details on our

Privacy Policy.