• No products in the basket.


The Microsoft Office 2016 Access Advanced highly recommended for individuals who have interest in learning Microsoft Access and all its advanced features.

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

In this course, you will explore how to link to other data sources and advanced options for the use of forms and queries. Apart from this, you will learn how to divide a database by splitting the frontend and backend. In addition to that, learn to create and maintain macros, and the use of Visual Basic for Applications.

Learning outcomes:

  • Introduce with the improved features for Access 2016.
  • Analyze large amounts of information, and manage related data more efficiently.
  • Get into a new way of learning Microsoft Access 2016.
  • Learn to store information for reference, reporting, and analysis in an adequate manner.

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
Add Controls to Forms FREE 00:11:00
Enhance Navigation and Organization of Forms 00:14:00
Apply Conditional Formatting 00:04:00
Module 02
Import Data into Access 00:08:00
Export Access Data 00:06:00
Link Tables to External Data Sources 00:05:00
Create a Mail Merge 00:02:00
Module 03
Create a Macro 00:08:00
Restrict Records by Using a Condition 00:04:00
Validate Data by Using a Macro 00:05:00
Automate Data Entry by Using a Macro 00:04:00
Module 04
Manage a Database 00:08:00
Determine Object Dependency 00:04:00
Module 05
Manage a Database 00:07:00
Determine Object Dependency 00:04:00
Document a Database 00:04:00
Module 06
Splitting a Database for Multiple User Access 00:05:00
Implement Security 00:03:00
Convert an Access Database to an ACCDE File 00:04:00
Package a Database with a Digital Signature 00:01:00
Module 07
Create a Database Switchboard 00:05:00
Modify a Database Switchboard 00:02:00
Set Start up Options 00:04:00
Mock Exam
Mock Exam -Microsoft Office 2016 Access Advanced 00:20:00
Final Exam
Final Exam – Microsoft Office 2016 Access Advanced 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 Units23
  • Number of Quizzes2
  • 2 hours, 42 minutes