Microsoft Access course delivery options

Onsite Microsoft Access training course

Learn in the comfort of your own workplace, either individually or in small groups of colleagues. Courses are delivered by experienced, qualified instructors on hand to assist individual learners as well as guiding the group through hands on examples and exercises.

Duration: 1 day per level

 

Virtual Microsoft Access training course

Learn with the convenience of remote meeting technology such as Teams or Zoom. With the additional benefit of two screens, the learner can feel involved and watch demonstrations by the trainer on one screen whilst replicating the examples on their own screen to mimic the in-room experience of trainer/delegate interaction.

Duration: 1 day per level

About Microsoft Access

Storing large amounts of data? Wondering how to find what you need, and get the data into a presentable format? We’ll show you how to create, administer and extract data from Microsoft Access databases. Along the way you will learn how to optimise the databases you might already be using, protect them, get clearly presented output, and link the databases with other applications such as Excel and Word.

Each level of training takes one day to complete.

Microsoft Access course outlines

Microsoft Access Introduction
De-mystify the database world in the comfort of your own work place! Learn terminology and how to create a functioning database to store your information. Create simple, clean data input screens and find and display information in attractive on-screen and printed formats. Prevent incorrect or invalid data from being input, and to ensure consistency of data.

 

  • Creating a database
  • Understanding database terminology
  • Tables and properties
  • Importing data from Excel and other formats
  • Creating Forms to input and view data
  • Creating and running queries
  • Designing reports for printing
Microsoft Access Intermediate
Streamline databases by creating relationships between tables to cut down the amount of data required. Update or delete data in tables automatically. Automatically calculate other values in forms and reports. Make your database attractive, safe and easy to use by others, using a menu system. Prevent accidental deletion by others. Run powerful combined actions using menus.

  • Creating table relationships
  • Viewing database relationships
  • Advanced queries
  • Action queries
  • Calculated fields
  • Creating a menu system
  • Protecting important database elements
  • Macros
  • Assigning macros to menus and form controls
Microsoft Access Bespoke / Tailored

Build your own course by selecting topics from three levels, or adding your own!

Get in touch for more information.