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.