Search Our Site

We have 3,754,973 registered online learners.
9 new learners so far today.
MS Access Cover
Ms Access advanced screenshot
Intermediate screenshot
MS access intro

Designed for all abilities, our courses are broken down into three levels – introductory, intermediate and advanced, so you can be sure to find the level you require.

In the three courses dedicated to this program, you will learn step by step to create such databases and to process their data, ensuring you become familiar with the program environment and terminology.

  • Online, self-paced training
  • Three courses
  • The study-time required for one lesson is approximately 20-30 minutes
  • The study-time required for one course is approximately 8 hours
  • 24-hour learner support
  • Instant digital certificate on completion
Description

Overview

Microsoft Access is a database management system which allows users to analyse large amounts of information and manage data more efficiently than Excel or other spreadsheet applications. 

Designed for all abilities, our courses are broken down into three levels – introductory, intermediate and advanced, so you can be sure to find the level you require.

In the three courses dedicated to this program, you will learn step by step to create such databases and to process their data, ensuring you become familiar with the program environment and terminology.

Course Description

These three courses will help you develop your skills from a beginner’s level to an advanced one. With these three courses you will cover:

  • How to design tables, set the properties of their fields and try the entry of data to them
  • How to link the individual tables with each other via relations and set the relation properties.
  • How to structure the entire database to be able to use it efficiently
  • How to select specific data from the created tables via queries, in combination with calculations to achieve new data
  • How to use special action queries
  • How to arrange the data from tables and those derived by queries using forms and reports in order to print them or to make the entry of new data easier
  • How to create macros that will automate the work in a database and will control whether the entered data comply with the set rules
  • The options of importing and exporting data in databases and saving their individual objects

Why take this course?

This online training will help learners who may or may not have previous experience with Microsoft Access to develop their skills and understanding of each software and how it works, and create digital documents to improve their work or employability.

Who should take this course?

These courses are aimed at anyone who uses Microsoft Office, whether that is in study, at home or at work. As our courses are tailored to all abilities with introductory, intermediate and advanced levels, they are suitable for all learners. This ranges from beginners to those learners who want to refresh and update knowledge they already have.

Elearning content

MS Access 2016: Introduction

MS Access 2016: Intermediate

MS Access 2016: Advanced

Certificate

All learners who successfully complete the course will be able to download and print a certificate. As this is an excellent indication of your skills, we suggest you keep it for your own records in order to show current or future employers.

How It Works

Frequently asked questions

Do I need an e-mail address to buy this course?

Yes, you will need an e-mail address to buy this course. This is because we use your e-mail address to create an account for you in our learning management system - where you will take the training. We also need your email address to send your purchase receipt.

If you buy more courses in future using the same e-mail address during checkout, then these will automatically be added to your system account.

If you pay by PayPal, we will use your PayPal email address to create your system account.

Can I buy this course and give it to other people?

Yes, you can buy the training using your own email address and then give it to other learners from your system account.

Each learner will need to have their own email address. This is so that we can send them a link to the training and give them their own system account.

Is there a refund policy?

We want you to be completely satisfied with your training. We offer a 30 day, no hassle, no quibble, money-back guarantee if you are not 100% satisfied.

To request a refund, you should email our learner support team with your receipt stating why you would like to be reimbursed. You, or your learners, must not complete the training in order to make a valid refund claim.

Will the course work on a tablet or mobile phone?

We recommend using a desktop or laptop for the best learning experience. This course can also be taken on tablet and mobile devices - including iPads and iPhones.

Is a specific internet browser recommended?

For the best possible experience, we recommend learners use Google Chrome, Internet Explorer 11 or Firefox. Please ensure there are no updates pending on your browser.

How long do learners have to complete a course?

There is no set completion time for this course. Learners can study in their own time at their own speed and may pause, leave and come back to the system to continue the training at any time.

Does the course contain sound?

Yes, this course contains sound. For those without sound on their computer or device, the narration is covered in an optional text box at the bottom of the training.

How long is the certificate valid for?

There is no set time for how long this certificate is valid for. It is generally recognised that certificates are renewed every three years.

Discounts

Bulk discounts

Bulk discounts are available on purchases of more than 10 courses.

If you wish to discuss a large individual order for this course, and/or would like to be invoiced in advance, please call our sales team on 01943 885 085 to make an enquiry.

Frequently Bought Together

£25.00 + VAT
add add
0 Selected Total Price: £0 + VAT
CPD
investors-in-people-silver
ISO 9001:2015
bcs-accredited-training-partner
Crown Commercial Service Supplier
LPI Accredited Learning Technologies Provider

Contact

+44 (0)1943 605 976

Virtual College

Marsel House

Ilkley

West Yorkshire

LS29 8DD

Awards for footer
Gold and silver award winners at the Learning Technologies Awards 2017 - including gold for excellence in the design of learning content.

Login

We are in the process of moving to one Virtual College website. If you want to go back to a course, or start a course, bought from our old website then you may need to login to our original learning management system. Otherwise, please proceed to our new learning management system to return to your training.

LMS

You are already logged in. Click the button below to be taken to your LMS dashboard. Alternatively, click logout to leave the system.