Access 2016 - Level 3 - Queries and Records eLearning Course

Return to category list

Overview

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.

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.
Language
UK
Date last updated
3/27/2018
Duration
2 Hours 45 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
Languages
  • English
Accreditation or Endorsements
  • No
Customisation Available
  • No

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

Request a quote

Cookies

We use cookies to help make our site easier and better for you. We'd appreciate a quick Accept please, to help us continue these efforts.

You can check out the full details in the Privacy Policy.

Saving, please wait...

Your preferences are being saved. This page will reload with your chosen preference.