Computers398x229
Immediate enrolment

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

£16.50

Price is per online user of this course. EU applicable VAT is added.

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.

 

In this online course you will 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

 

See below for further information.

Sold By: Core Learning Services

Product Description

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.

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
  • Store customer records securely
  • Improve communication by providing staff with better access to information
  • Capitalise on and manage the knowledge, experience and information contained within your business

The online course takes approximately 3 hours to complete and is available for 12 months from the date first accessed.

Discounts

10% discount for between 10 users purchased, 15% discount for between 20 users purchased and 20% discount for 30 or more purchased. For discounts on larger volumes please phone 0844 854 9218.

Discounts are calculated during the checkout process.

Payment Options

The most straight forward method of payment is to select the number of users you require and add the product to your shopping cart by selecting Add to Cart. You will then be able to make payment using most credit and debit cards or a Paypal account. If you would like to pay by BACs transfer or by invoice please contact a customer advisor on 0844 854 9218 or email [email protected]

Additional Information

Subject

Information Technology

level

Professional Development

guided-learning-hours

2 – 4.5 hours

mobile-compatible

No

resource-type

Online Course

online-access-duration

6 months

Available for immediate enrolment

Yes

Reviews

There are no reviews yet.

Be the first to review “Access 2010 – Level 3 – Sorting and Filtering Records and Creating and Managing Queries”

Your email address will not be published. Required fields are marked *

You may also like…