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).
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 | |||
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
No Reviews found for this course.