About the course

The Access 2010 - Level 3 tutorial takes you through tasks associated with Sorting and Filtering Records and Creating and Managing Queries as specified in the Microsoft Office Specialist exam 77-885.

You’ll learn how to

• Find text, numbers and dates in records
• Sort data in tables, queries and forms
• Create, save and delete queries
• Use multiple-table queries, join tables and add selection data
• Use Grouping in queries and use the Expression Builder
• Create and modify Crosstab, Update, Append and Action queries

Modules

There are six 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