MS Access 2016 Package – Introduction, Intermediate and Advanced with Vizual Coaching AcademyMerchant Name Location
Become proficient and confident in the creation and management of relational databases, including designing tables, data entry, queries and calculations.
Working through this three course package will see learners become proficient and confident in the creation and management of relational databases, including designing tables, data entry, queries and calculations. You’ll also learn to create macros and become familiar with importing and exporting data options.
This course package is for anyone who wants to quickly get to grips with Microsoft Access 2016, whether that’s for a potential job, promotion, running their own business or for personal use.
What’s the deal?
MS Access 2016 Package – Introduction, Intermediate and Advanced – R499 (valued at R5472)
Key Learning Points:
MS Access 2016 Introduction
Begin with the basics of working in the Access program.
Familiarise yourself with the key database terminology.
Try various ways of creating tables and practise setting the properties of their fields.
Learn to further analyse the data in a table through select queries, including the creation of calculated fields.
Understand how to set relations between tables and ensure their referential integrity.
Discover an easy way to create simple forms and reports.
MS Access 2016 Intermediate
Learn to create calculated fields in queries that operate with functions.
Practise creating totals queries and parameter queries.
Study the properties of table joins and examine how they can affect the result of queries.
Learn to create forms in the Design view and insert calculated fields into them.
Design and edit reports, and learn to perform various calculations in them.
Continue on to learn how to insert controls into forms and reports, including subforms and subreports.
MS Access 2016 Advanced
Begin the advanced course by familiarising yourself with action queries.
Examine different types of queries in the SQL view and get acquainted with the essential clauses of this language.
Learn to create and use macros to automate your work with databases.
Explore the importing and exporting of objects and their data.
Look at the printing options of different objects in detail.
Study the normalisation of data.
Examine the options of navigation in a database.
Units of Study
MS Access 2016: Introduction
MS Access 2016: Intermediate
MS Access 2016: Advanced
Valid until 31 December 2021.
Redeem online: www.vizualcoaching.com/redeem-voucher
Redeem course within 1 month from date of purchase.
No refunds on online courses.
No-shows forfeit Hyperli voucher.
Technical support available 24/5 via email, telephone and online chat.
Access to course material for 12 months.
Training runs on any Compatibility: Windows, Mac, iPhone, iPad, Android.
Training material available in English only.
Course log-in details and instructions will be emailed to you within three working days of redemption.
Course completion certificate included.
Browser settings need to be changed when using a Mac.
Software not included.
Information found https://www.vizualcoaching.com/faqs.