Contact

Microsoft Access 2016 (Fundamental & Intermediate)

Duration2 days
Timing9:00am to 5:00pm
Upcoming Session1–2 December 2026

Course Description

This course introduces the necessary skills for using Microsoft Access 2016 to design a simple database and be able to manage data in a table, select data using query, design forms and generate reports.

Prerequisites

Participants should have some basic knowledge of database terms.

Course Outline

Day 1

Lesson 1: Introduction to Databases

  • What is a Database?
  • Why Use a Database?

Lesson 2: Introduction to Access Objects

  • Tables
  • Forms
  • Queries
  • Reports
  • Putting It All Together

Lesson 3: Getting Started with Access

  • Opening a Database
  • To Close a Database
  • Getting to Know Access 2016
  • Working with Access Environment
  • The Ribbon
  • The Quick Access Toolbar
  • Backstage View
  • The Navigation Pane

Lesson 4: Working with Tables

  • To Open an Existing Table
  • Understanding Tables
  • Understanding Records
  • Navigating within Records
  • Adding Records and Entering Data
  • Editing Records
  • Sorting Records
  • Filtering Records

Lesson 5: Creating a Database

  • Creating Blank Database File
  • Creating a Database File from Template
  • Designing a Database
  • Creating a Table in Design View
  • Creating a Table in Layout View
  • Creating a Table by using Application Parts
  • Adding a Primary Key
  • Specifying the Type of Data
  • Understanding Field Properties
  • Defining Simple Field Validation Rules
  • Defining Input Masks
  • Creating Relationship by using the Lookup Wizard
  • Relationships
  • Understanding Types of Relationships
  • Adding Relationships
  • Viewing Relationships
  • Deleting Relationships
  • Importing Data and Objects from Access
  • Importing Data from Excel
  • Linking Data in Access
  • Linking Data in Excel

Day 2

Lesson 6: Queries

  • Planning a Query
  • Selecting All Columns from a Table
  • Selecting Individual Columns from One or More Tables
  • Sort by Selected Columns
  • Join Multiple Tables
  • Queries with Criteria
  • Returning the Top Matched Records
  • Eliminating Duplicate Values
  • Adding Calculations with the Expression Builder
  • Creating a Summary Calculation
  • Prompting to Filter Data with Parameters

Lesson 7: Forms

  • Create a Form
  • Adding Additional Fields to a Form
  • Adding Design Controls
  • Customizing Form Settings with the Property Sheet

Lesson 8: Reports

  • Create a Report
  • Deleting Fields
  • Printing and Saving Reports in Print Preview