3: Sorting and Filtering Records and Creating and Managing Queries

Duration : 3 hours Course Level : Level 3 Delivery Method : Online
Course Cost : £29.99

Access 2010 is a database management program that makes it easy to store and find information, analyse data and create accurate reports. This course focuses on data manipulation within Access 2010. Together with our other Access 2010 courses, this course also supports the background learning for the Microsoft Office Specialist Exam 77-885.

Special offer: buy our full range of Access 2010 courses (all 5 levels) for only £119.96!

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're 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.
  • Lessons can be completed within 30 minutes so you can do your training in bitesize pieces.
  • Bookmarking allows you to dip in and out, so you can learn whenever suits you.
  • 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.

You’ll have access to this course for six months from the date of purchase – giving you plenty of time to finish your course.

How this course can help your business:

  • Make the most of your investment in IT
  • Use databases to store, manage, sort and analyse information
  • Make sound business decisions based on accurate information
  • Improve communication by providing staff with better access to information
  • Capitalise on and manage the knowledge, experience and information contained within your business