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 FilteringFinding 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 QueriesCreating 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.