Mastering MS Access 2016 - Intermediate - Online Training Course - CPDUK Certified

Mastering MS Access 2016 - Intermediate – Online Training Course - CPDUK Accredited.

Welcome to The Mandatory Training Group's online Mastering MS Access 2016 intermediate training course. All our online training courses, programmes and qualifications are accredited by the CPD Certification Service (CPDUK).

Mastering MS Access 2016 

Teacher - Kathy Jones 

Learner - Elizabeth Barrier

This online Mastering MS Access 2016 intermediate training course will cover everything you need to know about Microsoft Access. Starting with the basics of relational database design, Kathy Jones expands your Microsoft Access knowledge by covering topics such as table relationships, query joins, sub datasheets, field validation and parameter queries in this course.

Course Content

This online Mastering MS Access 2016 intermediate training course includes the following:

• Unit 1: Relational database design 
• Unit 2: Creating a table
• Unit 3: Creating table relationships
• Unit 4: Creating query joins
• Unit 5: Relating data within a table
• Unit 6: Working with sub data sheets
• Unit 7: Using field validation - Part 1
• Unit 8: Using field validation - Part 2 
• Unit 9: Using forms and record validation
• Unit 10: Creating parameter queries 
• Unit 11: Summarising data
• Unit 12: Creating subqueries
• Unit 13: Creating action queries 
• Unit 14: Creating unmatched/duplicate queries
• Unit 15: Data normalisation
• Unit 16: Creating a junction table
• Unit 17: Creating a table structure
• Unit 18: Including control formatting in a report
• Unit 19: Adding calculated fields to a report
• Unit 20: Adding a sub-report to an existing report.

Who is the course for?

This online Mastering MS Access 2016 intermediate training course is suitable for all Microsoft Access users who want to develop powerful apps customised for their business needs.

Course aims

This Mastering MS Access 2016 intermediate e-learning course aims to:

• Expand your knowledge of Microsoft Access
• Help you develop powerful apps customised for your business needs.

Learning objectives

On completion of this Mastering MS Access 2016 intermediate eLearning course, the learner will be able to:

• Design a relational database
• Join tables to retrieve data from unrelated tables
• Validate data entered into a database
• Use advanced queries to manipulate one’s data
• Organise a database for efficiency and performance
• Outline how to maintain data integrity
• Customise reports to organise the displayed information and produce specific print layouts.

Learning outcomes

Once you have completed this online Mastering MS Access 2016 intermediate training course, the learner will be able to:

• Use action queries to manage table data quickly and efficiently
• Create table relationships to maintain data integrity
• Outline how to make forms easier to use
• Describe Subqueries 
• Apply the use of date functions in one’s designs 
• Create a report dialogue box to run database reports based on criteria the user selects dynamically
• Add custom commands to the report dialogue box
• Prepare a database for use by others.

Download Full Course Description (PDF)

Mastering MS Access 2016 - Intermediate – Online Training Course - CPDUK Accredited.