Microsoft Office 2016 Access Intermediate

Microsoft Office Access 2016 is an application created for your data organization and management needs. From designing a relational database to organizing a database for efficiency, you will only learn if you know how to do it using Access 2016. All of these are some of the key topics in Access 2016 that this Microsoft Office 2016 Access Intermediate - Complete Video Course will provide to ensure you will use the application efficiently.

Microsoft Access 2016 was created to help you with your database with the added feature in sharing and reporting; it has been widely recognized as more efficient than other applications available in the market. Learn how to hasten your skills in data organization using this application through this course now.

Microsoft Office 2016 Access Intermediate - Complete Video Course is certified by CPD Qualifications Standards and IAO. This makes it perfect for anyone trying to learn potential professional skills.

As there is no experience and qualification required for this course, it is available for all students from any academic background.

CPD

COURSE CURRICULUM

Module 01

• Relational Database Design
• Create a Table
• Create Table Relationships

Module 02

• Create Query Joins
• Relate Data Within a Table.avi
• Work with Subdatasheets from

Module 03

• Use Field Validation
• Use Form and Record Validation

Module 04

• Create Parameter Queries
• Summarize Data
• Create Subqueries
• Create Action Queries
• Create Unmatched and Duplicate Queries

Module 05

• Data Normalization
• Create a Junction Table
• Improve Table Structure

Module 06

• Include Control Formatting in a Report
• Add a Calculated Field to a Report
• Add a Subreport to an Existing Report

Assessment and Certification:

Upon completion of the course, you will be required to sit an online multiple-choice test. Your test will be assessed automatically and the results will be given to you immediately. Before sitting your final exam you will have the opportunity to test your proficiency with a mock exam. After you have successfully passed the final exam, you will be able to order an Accredited Certificate of Achievement at an additional cost of GBP24 for a PDF copy and GBP39 for an original print copy sent to you by post.

We are a company who is best known for offering awarding body accredited online courses that are available for anyone who wishes to acquire a certification and take their professional life to the next level.

As an online learning site, we are aware of the fact that there are a lot of people out there who considers themselves to be a curious learner but the courses that they are interested in are not available in the area. So, we have decided to give them a chance to learn in a convenient way – in their own convenient place and time.