Microsoft Access 2016 - Introduction

I.T. Training

Course Duration: Two days

Course Overview

The Introduction to Microsoft Access 2016 training course covers how to use Access 2016 to manage data, including creating a new database; constructing tables; designing forms and reports and creating queries.


Getting started with Microsoft Access

  • Identify the components of the Access 2016 interface
  • Understanding database terminology and relationships
  • Using the new “tell me what you want to do” help and search feature of 2016
  • Using the new insights smart lookup feature to access definitions or web content
  • Planning and designing a database
  • Learn about security warnings

Building a database
  • Constructing a new database
  • Naming conventions
  • Using Database Templates – New Templates and themes Introduced in 2016
  • File formats

  • Creating a table - using the table wizard.
  • Field types and field properties
  • Table relationships
  • Formatting a table
  • Table views
  • Add, edit and delete records
  • Search, browse and print records
  • Format a table

Creating and formatting forms
  • Creating and modifying a form
  • Changing the theme of a form
  • Understanding bound and unbound controls
  • Adding fields, controls, images and logos to a form
  • Using a form

Creating and using Queries
  • Understanding types of queries
  • Creating a simple query – using the wizard
  • Using wildcards and operators
  • Running a query
  • Viewing, sorting and filtering results
  • Create and use multiple table queries
  • Create and use a parameter query
  • Exporting results to excel

  • Creating a Report – design view
  • Using the wizard
  • Modifying placement, colours, fonts, headers & footers
  • Create a report from an object
  • Preview results
  • Printing reports
  • Printing reports to PDF

Learning outcomes

Who should attend


Course benefits

Pre-course work

Further courses to consider


Looking For Pricing Information?

Call +44 (0) 28 9043 9624
Or Book Online

View Full Course List

View Full Course List

Microsoft Access 2016 - Introduction

Book Now

We are here to help!

For any queries regarding any of our courses please Contact us at enquiries@cosensa.co.uk

Please click here for more information on how we use cookies on this website