Access 2013 - Level 3 - Queries and Records

About the course

The Access 2013 - Queries and Records course is part of the MOS exam 77-424 range. 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

Modules

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.