Microsoft Access 2016

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: Payscale) 

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 600,000 delegates globally, which has helped offer the highest quality training, and we have earned a 5-star rating on Trustpilot, from over 10,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