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
Youll 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.