Microsoft Access 2016 Beginner to Advanced

Microsoft Access 2016 Beginner to Advanced


The Microsoft Access 2016 Beginner to Advanced course is the ultimate online training program for mastering Excel, ideal for those who want to improve their proficiency and confidence in managing data-based tasks. Through step-by-step guidance, it covers Excel 2016’s most important features and functions, taking you through key topics such as conditional formatting, data validation, action queries, and data normalisation.

Through video material and expert tuition, you will also learn how to prepare reports for print, create a mail merge and automate specific data management tasks using macros to speed up everyday administrative duties. Gain in-demand transferable skills required for any office role and add valuable credentials to your CV with an internationally-recognised, accredited certificate of achievement.

Highlights of the Microsoft Access 2016 Beginner to Advanced:

  • Learn how to modify table data, create lookups, perform calculations in a query, and much more
  • Enhance the appearance of your reports and add controls to your report
  • Know how to create a relational database design and relate data within a table
  • Understand how data normalisation works and why it is important in data management
  • Get step-by-step guidance on how to create a mail merge and mailing label report
  • Learn how to apply data validation to cells or a range, including how to form and record validation
  • Apply conditional formatting to multiple cells and automate tasks using macros
  • Develop your proficiency in data management to improve your career prospects

Course design

The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace.

You are taught through a combination of

  • Online study materials

Who is this Course for?

This course is for anyone who wants to familiarise with the tools and features of Microsoft Excel 2016, designed for learners of all levels. It is ideal for professionals in office-based roles who have data management responsibilities. To provide you with ease of access, this course is designed for both part-time and full-time students. You can become accredited in just 20/30 hours, with the freedom to study at your own pace.

How is the course assessed?

To successfully complete the course you must pass an automated, multiple-choice assessment. The assessment is delivered through our online learning platform. You will receive the results of your assessment immediately upon completion.

Will I receive a certificate of completion?

Upon successful completion, you will qualify for the UK and internationally-recognised certificate and you can choose to make your achievement formal by obtaining your PDF Certificate at a cost of £9 and Hardcopy Certificate for £15.

Why Choose this Microsoft Access 2016 Beginner to Advanced:

  • 24/7 access to the course for an extensive period of 12 months
  • CPD accredited certification on successful completion
  • Ease of access to the course material from any device of your choice
  • No hidden fees or exam charges
  • Full tutor support on weekdays (Monday – Friday)
  • Efficient exam system, assessment and instant results
  • Develop professional skills and advance your career, thus increasing your potential to earn more


The Microsoft Access 2016 Beginner to Advanced is open to all, with no formal entry requirements. All you need is a passion for learning, a good understanding of the English language, numeracy and IT, and to be over the age of 16.

Career Path

Once you have successfully completed the course, you will have excellent proficiency in Microsoft Excel, with the skills and credentials to manage day-to-day data-based tasks confidently and efficiently. This qualification can be added to your CV to improve your job prospects for the following roles:

  • Data Entry Clerk (average annual salary of  £17,096 in the UK)
  • Office Administrator (average annual salary of £19,037 in the UK)
  • Data Analyst (average annual salary of £33,852 in the UK)
  • Accountant (average annual salary of £33,631 in the UK)

Course Curriculum

Module - 1
Orientation to Microsoft Access 01:00:00
Create a Simple Access Database 01:00:00
Get Help in Microsoft Access 00:30:00
Modify Table Data 00:30:00
Work with Records 01:00:00
Sort and Filter Records 00:30:00
Create Lookups 01:00:00
Join Data from Different Tables in a Query 01:00:00
Sort and Filter Data in a Query 01:00:00
Perform Calculations in a Query 00:30:00
Create Parameter Queries 00:30:00
Create Action Queries 00:30:00
Create Find Duplicate and Find Unmatched Queries 00:30:00
Summarize Data 00:30:00
Create a Report 01:00:00
Add Controls to a Report 00:30:00
Enhance the Appearance of a Report 00:30:00
Prepare a Report for Print 00:30:00
The Access Options Dialog Box 01:00:00
Relational Database Design 00:30:00
Create a Table 01:00:00
Modify a Table and Fields 00:30:00
Create Table Relationships 00:30:00
Create Query Joins 00:30:00
Join Tables That Have No Common Fields 00:30:00
Relate Data within a Table 00:30:00
Work with Subdatasheets 00:30:00
Create Subqueries 00:30:00
Data Normalization 01:00:00
Create a Junction Table 00:30:00
Import Data into Access 00:30:00
Export Data to Text File Formats 00:30:00
Export Access Data to Excel 00:30:00
Create a Mail Merge 00:30:00
Organize Report Information 00:30:00
Format Reports 00:30:00
Include Charts in a Report 00:30:00
Add a Calculated Field to a Report 00:30:00
Add a Subreport to an Existing Report 00:30:00
Create a Mailing Label Report 00:30:00
Publish a Report as PDF 00:30:00
Activities – Microsoft Access 2016 for Beginners 00:00:00
Module - 2
Add Controls to Forms 01:00:00
Set Form Controls 01:00:00
Create Subforms 00:30:00
Organize Information with Tab Pages 00:30:00
Enhance Navigation with Forms 00:30:00
Format a Form 01:00:00
Apply Conditional Formatting 00:30:00
Field Validation 00:30:00
Form and Record Validation 00:30:00
Create a Macro 01:00:00
Restrict Records Using a Condition 00:30:00
Validate Data Using a Macro 00:30:00
Automate Data Entry Using a Macro 00:30:00
Convert a Macro to VBA 00:30:00
Link Tables to External Data Sources 00:30:00
Manage a Database 00:30:00
Determine Object Dependency 00:30:00
Document a Database 00:30:00
Analyze the Performance of a Database 00:30:00
Split a Database for Multiple User Access 00:30:00
Implement Security 00:30:00
Set Passwords 00:30:00
Convert an Access Database to an ACCDE File 00:30:00
Package a Database with a Digital Signature 00:30:00
Create a Database Switchboard 01:00:00
Modify a Database Switchboard 00:30:00
Set Startup Options 00:30:00
Activities – Microsoft Access 2016 Advanced 00:00:00
Mock Exam
Mock Exam- Microsoft Access 2016 Beginner to Advanced 00:30:00
Final Exam
Final Exam- Microsoft Access 2016 Beginner to Advanced 00:30:00

COPYRIGHT © 2022 One Education

Home Search Cart
    Your Cart
    Your cart is emptyBrowse Courses

    Upgrade to get UNLIMITED ACCESS to ALL COURSES for only £49/year

    Claim Offer & Upgrade

    Membership renews after 12 months. You can cancel anytime from your account.

    Other Students Also Buy
      Apply Coupon