Name: Microsoft Office 2016 Access Advanced
Price: 24.99 GBP
Rating: 4.9 (8 reviews)

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).

Certification:

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.

Requirements

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