Access 2016 Intermediate


1 Day

Experience Needed

Access 2016 Introduction, or applicable experience


This class builds on a reasonable level of database design experience that may have been gained from the Introduction course.

Who Should Attend

People who intend to design databases at an advanced level or improve existing Access databases. Also conversion of databases made in other applications and spreadsheet (flat file) databases.

Course Content

Action Queries

  • Types of Query
  • The Crosstab Query
  • The Make Table Query
  • The Append Query
  • The Delete Query
  • The Update Query


  • The Report Wizard
  • Creating a Report with Summary Totals
  • Using the Label Wizard
  • Modifying and Redesigning the Report.
  • Publishing Access Data on the Web

Customizing Forms

  • Manipulating Data in the Form
  • Creating A New Form
  • Using the Form Wizard
  • Creating a Form with a Sub form
  • Modifying and Redesigning the Form

Protecting Desktop Databases with Backup and Restore Process

  • Why do I need a backup?
  • Creating a database backup
  • Creating a Split Database
  • Backing up back-end database and front-end database
  • Restoring a database
August 10, 2021 8:00 am - 1:00 pm Register Now
September 15, 2021 8:00 am Register Now
October 13, 2021 8:00 am Register Now
October 28, 2021 8:00 am Register Now

Learnsoft has a 30-year track record of delivering results – learn what we can do for you

Speak to a product specialist or register for a class

Back To