Name: Mastering MS Access 2016 - Intermediate - Online Training Course - CPDUK Certified
Brand: MTG
SKU: 39341378699333
Price: 24.99 GBP
Availability: InStock

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

The Mandatory Training Group is the leading UK provider of accredited statutory and mandatory training courses for all sectors, including health and social care, education, local government, private and charity sectors.

We have supported over one million learners to reach their potential through e-learning courses and qualifications using our interactive online learning portal.

£24.99

Overview
How it works
Certification
Why choose us
FAQs
Reviews

Overview

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 - The Mandatory Training Group UK -

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

How it works

Instant Access

✓ Gain instant access to your course(s) upon purchasing through our website

✓ Login credentials are sent immediately to the customer to the email address provided during the checkout process

✓ We also advise all customers to check their spam and junk mail folders in case your mail server has diverted the email there

Learn Anytime, Anywhere, On Any Device

✓ Learn at your own pace, at a time and place convenient to your circumstances

✓ Individual learners can access their course material(s) 24/7 for 365 days from the date of purchase

✓ In the case of organisations that order multiple licences for future use, the countdown will start when learners are allocated to the training course(s)

Assessment and Certification

✓ Unlimited attempts to complete end of course assessments

✓ On successful completion, download, print/save quality-assured CPD certificate

Online Support 24/7

✓ Customer service teams interact with clients through email and live chat support

100% Money-Back Guarantee

✓ We want you to be completely satisfied with your training. We offer a 14-day money-back guarantee if you are not 100% satisfied

Refund policy

✓ To request a refund, you should email our support team with your receipt stating why you would like to be reimbursed

✓ You, or your learners, must not complete the training to make a valid refund claim. Any courses that have been completed and those with certificates achieved will not be valid for a refund

The Mandatory Training Group - CPDUK Accredited E-Learning Providers.

Certification

End of course assessment

At the end of this course, learners are required to complete an online end of course assessment. On successful completion of the assessment (80% pass mark), learners may download a FREE CPD certificate from their profile page.

Certification

On successful completion of this e-learning course and end of course assessment, the learner may download, save and/or print a quality assured CPD certificate (recognised internationally). Our CPD certificate can be used to provide evidence for compliance and audit or Continuing Professional Development (CPD).

Course accreditation

The CPD Certification Service accredits all our online training courses and programmes as conforming to universally accepted Continuous Professional Development (CPD) guidelines.rses meet the latest guidance and best practice recommendations.

The Mandatory Training Group - CPDUK Accredited E-Learning Providers.

Why choose us

Why choose our accredited e-learning courses and programmes?

The benefits of using our accredited e-learning courses in the workplace include:

✓ CPDUK accredited e-learning provider
✓ Ofqual approved training centre (UK qualifications)
✓ Internationally recognised CPD and Ofqual approved certificates
✓ Wide range of courses and qualifications that meet UK legislation and guidelines
✓ Over 500 online courses and programmes that cover multiple sectors
✓ Free blended learning environment for individuals and organisations
✓ Immediate access to online courses and programmes
✓ Highly interactive e-learning portal
✓ Substantial cost reductions (no travel fees and other expenses)
✓ Self-paced online learning
✓ Low carbon footprint through e-learning
✓ Repository of online learning materials and assessments
✓ Fully qualified and experienced trainers, instructors and assessors
✓ Experienced subject matter experts and content developers
✓ Conversion of existing classroom courses to e-learning courses
✓ All training courses meet the latest guidance and best practice recommendations.

The Mandatory Training Group - CPDUK Accredited E-Learning Providers.

FAQs

Frequently Asked Questions

To enrol on this e-learning course, please add the course to your basket. From there, you will be redirected to our secure checkout page to complete your booking.

If you are booking the course for someone else, please click the ‘Buy For Others’ button at the upper right hand of this page.

Once your payment has been confirmed, you will receive a booking confirmation email with a receipt. Immediately after purchase, you will receive an email with further instructions and unique login credentials to access your learner account. Next, you will need to follow the instructions and login to your learner account.

Our courses are divided into six units. You can either read or listen to the course materials. At the end of each unit is a ‘knowledge check’ section. This section helps the learners remember what they have learnt.

Our online training courses can be completed on your desktop computer/Mac, laptop, tablet or mobile device. These online courses are easily accessible as long as there is an internet connection.

These online training courses are self-paced. Therefore, learners have full control and flexibility on when they wish to complete the material.

There is no deadline for completion. The course will expire from a learner’s account after 365 days, whether it has been accessed or not.

Yes. All end of course assessments are completed online.

Learners are required to achieve a passing rate of 80% or more to complete the course and gain a CPD certificate.

To obtain your certificate, you need to complete the end of course assessment first. A passing rate of 80% or more is required to gain a CPD certificate.

Obtained certificates can be downloaded from the learner’s profile page.

We want you to be completely satisfied with your training. Thus, we offer a 14-day money-back guarantee if you are not 100% satisfied.To request a refund, you should email our Support Team with your receipt stating why you would like to be refunded. Any courses that have been completed and those with certificates will not be valid for a refund.

Yes, you can access the learning materials from any electronic device that has an internet connection. However, we recommend that you use a desktop or laptop device for the best learning experience. These online courses can also be taken on tablets and mobile devices, such as iPads, iPhone and Android mobile phones.

For the best possible experience, we recommend that learners use Google Chrome, Microsoft Edge, Internet Explorer 11 or Firefox. Please ensure no updates are pending on your browser.

There is no estimated completion time for this course. Learners can study in their own time at their speed. Learners may pause, leave and come back to the system to continue the training at any time.

The CPD hours depend on how long each learner takes to complete the course materials and assessments. Each course will indicate the anticipated completion time. This gives a general indication of the CPD hours for those who are required to submit their continuing professional development hours.