Microsoft Access Intermediate

The topics listed under this level of training are a snapshot only of the skills which fall under the Access Intermediate category. If you are interested in this level of training, please contact us to register your interest using the form below. As we provide customised training, for multi-student training sessions the next step after you contact us involves us assessing your current skills to determine exactly which topics you require training in. After you have completed this level of training, you may want to up-skill to the next level: Microsoft Access Advanced. If this level of training is too complex for you, you can view the Microsoft Access Basics course.

This level includes:

Tables

  • Correctly relating Tables
  • Linking Tables
  • Changing Field position
  • More data properties
  • Freezing/unfreezing Columns
  • Spellchecking/proofreading data

Forms

  • Filtering with Forms
  • Combo Boxes
  • Lists
  • Tabs
  • Command Buttons
  • Distributing & Aligning Fields evenly
  • Basic formatting of Controls
  • Stacking & Layouts

Queries

  • Grouping records in a Query
  • Summarising and Total Fields
  • Formulas in Queries
  • Date range Queries
  • Formatting Fields
  • Modifying existing Queries
  • Beginner Formula Expressions
  • Functions using Expression Builder

Reports

  • Changing design & format Report
  • Changing orientation
  • Consolidating formatting commands
  • Creating professional Reports with Logos
  • Adding Page headers & footers
  • Adding Report headers & footers
  • Managing space to enable Printing

Databases

  • Sort multiple Database Fields
  • Reversing & removing a Sort
  • Creating a built-in template Database
  • Importing Data
  • Importing Excel files
  • Compact & Repair a Databaes

Request for Training

Your Name (required)

Your Email (required)

Your Contact Number (required)

Any prior experience with Access?

Motivation for Training? (upskilling / applying for a job...)

How soon do you need this Access Intermediate training?

How many people require this training?