Menu
Menu
  • No products in the basket.

Online Microsoft Access 2016 Advanced

4.8( 7 REVIEWS )
206 STUDENTS
ACCREDITED BY

Do you need to get to grips with Microsoft Access 2016?

Course Description:

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.

What are the requirements?

  • You must be 16 or over
  • You should have a basic understanding of English and basic IT knowledge
  • You will need a computer or tablet with internet connection (or access to one)
  • Learners must have Microsoft Access 2016 installed onto their computer

What skills will I gain?

  • Learners will be able to create, edit and update databases
  • Learn to master the key concepts of DBMS
  • Develop a full understanding of SQL
  • Learn how to create forms, queries & reports
  • Gain excellent database management skills
  • Learn about the mathematical calculations and functions of Microsoft Access
  • Successful candidates will have a full knowledge of the advanced features in MS Access
  • At the end of this course, you’ll be an expert user of Microsoft Access

What is the target audience?

  • Office Administrators & Office managers
  • Office clerk, Marketing assistant & Administration Assistant
  • Secretary or Executive
  • Web content writers & Bloggers
  • Technical, business & Report writers
  • Anyone who needs to use Microsoft Access 2016 as part of their job or personal life

How will I be assessed?

  • At the end of the course learners will take an online multiple choice question assessment test. This online multiple choice question test is marked automatically so you will receive an instant grade and know whether you have passed the course.
  • Those who successfully pass this course will be awarded a free e-certificate, and only need to pay £19 for your printed certificate.

What Certification am I going to receive?

If you pass the exam successfully then you will be awarded a  Advanced Microsoft Access 2016 Training Certificate.

Key Features

Gain an accredited UK qualification

Access to excellent quality study materials

Learners will be eligible for TOTUM Discount Card

Personalized learning experience

One year’s access to the course

Support by phone, live chat, and email

Course Curriculum Total Units : 28
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
WhatsApp chat
Up to 95% Off now!!! - MEGA DEALS.
Use code “MEGA95 for all | MEGA90 for Opera PMS | MEGA80 for BTEC & NCFE” at checkout
x