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.
- 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.
|Relational Database Design||FREE||00:16:00|
|Create a Table||00:09:00|
|Create Table Relationships||00:09:00|
|Create Query Joins||00:14:00|
|Relate Data Within a Table.avi||00:04:00|
|Work with Subdatasheets from||00:05:00|
|Use Field Validation||00:16:00|
|Use Form and Record Validation||00:14:00|
|Create Parameter Queries||00:12:00|
|Create Action Queries||00:05:00|
|Create Unmatched and Duplicate Queries||00:06:00|
|Create a Junction Table||00:04:00|
|Improve Table Structure||00:06:00|
|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 – Microsoft Office 2016 Access Intermediate||00:20:00|
|Final Exam – Microsoft Office 2016 Access Intermediate||00:20:00|
No Reviews found for this course.