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.