We can teach you to get the most out of Microsoft Access during this course. Microsoft Access is a database management application. Learning how to use Microsoft Access is an investment in both your personal and professional life. You learn to develop and support robust Access systems, manipulate and query data, develop forms, and design sophisticated data analysis reports.
Our learning material is available to students 24/7 anywhere in the world, so it’s extremely convenient. These intensive online courses are open to everyone, as long as you have an interest in the topic! We provide world-class learning led by IAP, so you can be assured that the material is high quality, accurate and up-to-date.
If you pass the exam successfully then you will be awarded a Advanced Microsoft Access 2016 Training Certificate.
Learners who successfully complete the course will be awarded a Certificate in Online Microsoft Access 2016 Advanced by CPD and iAP.
Learners who successfully complete the course will be awarded a Certificate in Online Microsoft Access 2016 Advanced by CPD and iAP.
Microsoft Access 2016 - Beginner | |||
Introduction to MS Access | |||
Creating Tables & Setting up Properties | |||
Queries | |||
Creating Forms & Reports | |||
Working with Macros, Integrating Access with Office Suite | |||
Database Management | |||
Exercise Files- Microsoft Access 2016 | |||
Microsoft Access 2016 - Advance Questions in Depth | |||
Introduction to Access 2016 Advance Questions in Depth | |||
Understanding Queries | |||
Query Criteria | |||
Parameters Queries | |||
Use Mathematical Operations and Functions | |||
Summarise Data with Aggregate Functions | |||
Dates, Time and Numbers Functions | |||
IF Function and Calculations | |||
Records and Database | |||
Explore the Basics of SQL | |||
Values, Database and Markup | |||
Exercise Files- ACCESS 2016 – ADVANCE QUESTIONS IN DEPTH | |||
Microsoft Access 2016 - Advance Tricks and Tips | |||
Introduction to Trick and Tips of Access 2016 | |||
Explore Startup Options | |||
Embed Queries in Reports | |||
Create a Back End and Front Ends | |||
Build the Forms and Reports | |||
Add Customised Functions and Visual Basics | |||
Exercise Files- Access 2016 Advance Tips & Tricks | |||
Mock Exam | |||
Mock Exam: Advanced MS Access 2016 Training – Online | |||
Final Exam | |||
Exam: Advanced MS Access 2016 Training – Online |