• No products in the basket.


Access included in Microsoft Office suite and it is a database management system that stores data in its format based on the Access Jet Database Engine. It can also import or link directly to data stored in other applications and databases.

If you have basic knowledge of Microsoft Access 2016 and want to enhance your skills of using Assess 2016, then enrol in this Microsoft Office 2016 Access Intermediate right now.

With the help of this course, you will equip yourself with adequate knowledge to create tables, queries, forms and reports efficiently. Apart from these, learn how to create, alter or update databases, sort and filter data in a query. Furthermore, you will learn performing calculations, data normalization, summarization of data, and advanced reporting skills.

Learning outcomes:

  • Familiarise with top new and improved features for Access 2016.
  • Get into a new way of learning Microsoft Access 2016.
  • Learn easy-to-use tool for creating browser-based database.
  • Learn to store information for reference, reporting, and analysis efficiently.

Method of Assessment:

Upon conclusion of the course, there’s an online multiple-choice quiz assessment, which will determine whether you have passed the course. The test is marked immediately and results are published instantly (60% pass mark).


Certificates can be obtained at an additional cost of £9.99 for PDF, £16.99 for Printed Hardcopy format and £24.99 for Both for Both PDF and Hardcopy Certificates.


There are no academic entry requirements for this course, and it is open to students of all academic backgrounds.

Course Curriculum

Module 01
Relational Database Design FREE 00:16:00
Create a Table 00:09:00
Create Table Relationships 00:09:00
Module 02
Create Query Joins 00:14:00
Relate Data Within a Table.avi 00:04:00
Work with Subdatasheets from 00:05:00
Module 03
Use Field Validation 00:16:00
Use Form and Record Validation 00:14:00
Module 04
Create Parameter Queries 00:12:00
Summarize Data 00:06:00
Create Subqueries 00:07:00
Create Action Queries 00:05:00
Create Unmatched and Duplicate Queries 00:06:00
Module 05
Data Normalization 00:10:00
Create a Junction Table 00:04:00
Improve Table Structure 00:06:00
Module 06
Include Control Formatting in a Report 00:04:00
Add a Calculated Field to a Report 00:05:00
Add a Subreport to an Existing Report 00:07:00
Mock Exam
Mock Exam – Microsoft Office 2016 Access Intermediate 00:20:00
Final Exam
Final Exam – Microsoft Office 2016 Access Intermediate 00:20:00

Course Reviews


8 ratings
  • 5 stars0
  • 4 stars0
  • 3 stars0
  • 2 stars0
  • 1 stars0

No Reviews found for this course.

  • £24.99
  • 1 year
  • Course Certificate
  • Number of Units19
  • Number of Quizzes2
  • 3 hours, 19 minutes