Microsoft Access 2016

How will the Microsoft Office Access 2016 course advance my career?

This course will help any Office Administrator or IT Administrator who utilises the Microsoft Access software to manage relational databases that are at the heart of business operations.

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

•    This great value three course package will take you from beginner to advanced level
•    If databases play a part in your current or potential job role, this course package contains all you need to achieve full proficiency
•    Take an official Microsoft exam, and match your skills to recognised standards

What are the Microsoft Office Access 2016 online course modules?

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

What does the Microsoft Office Access 2016 course cover?

•    The basics of working in the Access program
•    Key database terminology
•    Various ways of creating tables and practise 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
•    Practise 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