Overview

Office 2016 and 2019 – Please note that there are two versions of this course, 2016 and 2019.

This online course will give you a solid foundation in Microsoft Access, the world’s most widely-used database management system. Access is a powerful tool for storing large amounts of information and retrieving data for reports and analysis. In contrast to most other database programs, Access has its own Graphical User Interface and can be mastered without complex programming, so it is extremely popular with small to medium businesses who want to capture and analyse data in a competitive way.

Through your training with eCollege, you will learn how to manage large amounts of information and use this data to eventually deliver strategic reports.

You will learn to use the principle Access features to:

  • Create databases
  • Create tables
  • Create queries
  • Create forms
  • Create reports

What’s Included

  • All course content

  • Practice exercises and quizzes

  • A practice exam

  • A certification exam voucher

Course Handbook

Download Course Handbook 2019
Download Course Handbook 2016
For privacy reasons Vimeo needs your permission to be loaded.
I Accept

Course Topics – 2019

Topic 1

Manage Databases

Topic 2

Create and Modify Tables

Topic 3

Create and Modify Queries

Topic 4

Modify Forms in Layout View

Topic 5

Modify Reports in Layout View

Course Topics – 2016

Topic 1

Creating and Modifying Databases

Topic 2

Creating Tables

Topic 3

Creating Queries

Topic 4

Creating Forms

Topic 5

Creating Reports

Prerequisites & Requirements

Students must have previous IT knowledge as the MOS Core courses are intermediate courses. This is not a beginners course.

Learners should have the ICDL course completed.

If you have the ambition to create professional databases and learn new skills in business strategy and analysis, this course will suit your needs.

  • All students should have access to a PC or laptop running a supported version of Windows (e.g Windows 10).
  • Mac operating system devices can not be used for this course.
  • Apple/Android devices (Smart Phone/Tablets) are not supported and cannot be used for this course.
  • A broadband connection is essential to stream video content.

You require a web browser to view the content and access web platforms. Microsoft Access requires an Office 365 licence, which eCollege provides for the duration of the course.

Employment

After earning your Microsoft Specialist accreditation in Access, you’ll demonstrate proficiency in one of the most important applications used by businesses worldwide. Potential employment opportunities range from data entry positions, to database design and administration.

Academic

All Microsoft Office 365 programs can be seamlessly integrated to form a full suite of powerful skills and tools. ECollege provides the following recommended courses:

  • Microsoft Excel
  • Microsoft Excel Expert
  • Microsoft Word
  • Microsoft Word Expert
  • Microsoft PowerPoint

Course Code: NC 12398 – Microsoft Access 2019

Course Code: NC 09875 – Microsoft Access 2016

There are multiple ways to apply for this course, please check out the different options below.

FETCH is the further education and training course finder. To apply for this course use the button below.

Apply Now (2019)
Apply Now (2016)

If you are currently unemployed, you will find the contact details for your local Intreo office by using the button below. An Intreo officer will be able to guide you through your application.

Learn More

Skills to Advance is the further education and training initiative for people in employment.

Find out more

Related Courses