For information on course costs and booking onto a course, please click here. For any queries please contact us on business@nptcgroup.ac.uk or call: 0330 81 88 100Welcome, Guest

Access 2010 - Level 3 - Sorting and Filtering Records and Creating and Managing Queries

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