Microsoft - Training and Certification Courses

Microsoft Access 2016

Course Overview

If you’ve ever needed to store and analyse data, you have probably come across Microsoft Access. Microsoft Access is a widely used database management application.

Databases are used to collect and manage information and Microsoft Access helps you do this reliably and efficiently.

Key features
  • Delivery Method: Online
  • Assessment Included
  • Tutor Support Included
  • Course Access: 12 months
  • Freedom & flexibility to learn in your own time
  • 24/7 access
£36£25Inc. VAT
Add to Cart Divide Buy 0% Finance Options From £2.08 per month
Try a Soft Search now Fast check - will not affect your credit rating.
FREE Course Advice
Key features
  • Delivery Method: Online
  • Assessment Included
  • Tutor Support Included
  • Course Access: 12 months
  • Freedom & flexibility to learn in your own time
  • 24/7 access
About the Course
Youtube icon Youtube icon
Course Details

Is the Microsoft Office Access 2016 course suitable for me?

This course is perfect for you if you deal with data management on a regular basis, or just want to increase your knowledge on using Microsoft Access effectively.

The knowledge gained in this course will increase your employability as well as helping you in your job, your own business, or for when you use it at home.

Explore our full Microsoft range

How will the Microsoft Office Access 2016 course benefit me?

You will gain an in-depth understanding of Microsoft Access, which is a very popular data management software used by businesses worldwide.

Explore our other Microsoft courses

What jobs can I apply for after my Microsoft Office Access 2016 training?

If you are an Office Administrator or an IT Administrator who uses Microsoft Access regularly, managing databases for a business’s operations, this is the perfect course for you.

Typical salaries in these roles are:

  •  Office Administrator - £21k
  •  IT Administrator - £25k
  •  Database Manager - £40k

(Source: Glassdoor) 

Why choose to study the Microsoft Office Access 2016 course with e-Careers?

We have developed an expert team over the last 10 years since our inception. In that time, we have trained over 590,000 delegates globally, which has helped offer the highest quality training, and we have earned a 5-star rating on Trustpilot, from over 9,000 students. 

By refining our processes, partner relationships, and course materials, we can offer high-quality training solutions for our delegates. 

You will also benefit from: 

  • Advanced skills and knowledge of this area, starting at an entry-level and progressing through to advanced level to gain a succinct understanding of Microsoft Access.
  • This course will teach you all you need to know to be skilled in Microsoft Access, a widely used database software.

Explore our other Microsoft courses

Microsoft Office Access 2016 Syllabus

Modules

  •  Microsoft Access 2016: Introduction
  •  Microsoft Access 2016: Intermediate
  •  Microsoft Access 2016: Advanced

 Learning Outcome

  •  The basics of working in the Access program
  •  Key database terminology
  •  Various ways of creating tables and practice setting the properties of their fields
  •  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
  •  Create simple forms and reports
  •  Create calculated fields in queries that operate with functions
  •  Practice creating totals queries and parameter queries
  •  Properties of table joins and examine how they can affect the result of queries
  •  Create forms in the Design view and insert calculated fields into them
  •  Design and edit reports, and learn to perform various calculations in them
  •  Learn how to insert controls into forms and reports, including subforms and subreports.
  •  Action queries
  •  Different types of queries in the SQL view and get acquainted with the essential clauses of this language
  •  Create and use macros to automate your work with databases
  •  Importing and exporting of objects and their data
  •  Printing options of different objects in detail
  •  The normalisation of data
  •  The options of navigation in a database
We're Trusted by
Hundreds of thousands of individuals, small businesses and large corporations continuously put their trust in e-Careers.​
We are proud to have trained individuals who work for some of the world’s largest companies, including:​
Trusted by Trusted by