Microsoft Access

Microsoft Access TrainingEasyPC Training provides Microsoft Access training in Brisbane, Gladstone and Cairns, and customised training for groups and individuals across Australia, from beginners to advanced, using Microsoft Access 2010, 2013, 2016 and 2019.

Create spreadsheets to collect, analyse, share and manage information to make the most informed decisions.

Microsoft Access Training Courses available

Choose from our standard Microsoft Access training courses:

…or make your own Customised Course

Microsoft Access Level 1

Duration: Groups: 1 day   |   Individuals: 3-4 hours

Aimed at: those who want to be able to create database systems, enter, edit and delete data in database files, produce information in forms and reports and generate queries on the data.

Pre-requisites:

  • Basic computer experience, including keyboard and mouse skills
  • Familiarity with Microsoft Windows
  • If you are not familiar with using a computer or Microsoft Windows, the Introduction to computers course will give you the skills to take this Access course.
Course Overview:

  • Getting to Know Access
  • Designing a Lookup Database
  • Creating a Lookup Database
  • Modifying Table Structures
  • Adding Records to a Table
  • Adding Transactional Records
  • Working With Records
  • Sorting and Filtering
  • Creating Queries
  • Creating and Using Reports
  • Creating and Using Forms

View Course Outline >>

Microsoft Access Level 2

Duration: Groups: 1 day   |   Individuals: 3-4 hours

Aimed at: those who want to ensure that data is entered correctly, how to create more sophisticated and complex queries, and is introduced to some basic automation techniques involving macros.

Pre-requisites:

  • Some knowledge of creating basic databases and generating reports
  • Alternatively, completion of Access Level 1 training course
Course Overview:

  • Data Validation
  • Formatting Tables
  • Querying Techniques
  • Parameter Queries
  • Calculations in Queries
  • Modifying Forms
  • Using a Navigation Form
  • DIY Forms
  • Creating and Using Macros
  • Macro Techniques
  • Macros on Forms
  • Navigation Pane Protection

View Course Outline >>

Microsoft Access Level 3

Duration: Groups: 1 day   |   Individuals: 3-4 hours

Aimed at: those who want to design and create a multi-table database and automate operations using macros and have a general understanding of the programming environment in Microsoft Access.

Pre-requisites:

  • Significant knowledge of Microsoft Access
  • Alternatively, completion of Access Level 2 training course
Course Overview:

  • Relational Database Design
  • Creating a Relational Database
  • Setting Table Relationships
  • Importing and Exporting Records
  • Multi Table Queries
  • Aggregation Queries
  • Action Queries
  • Database Security
  • Database Wellness
  • An Introduction to VBA

View Course Outline >>

Customised Microsoft Access Training

Mix and Match topics from any of the levels above to create your own customised training course…

  • For full day courses, choose between 10 and 12 topics
  • For half day courses, choose between 5 and 6 topics

We will discuss your training requirements with you, and can recommend a selection of topics suitable for your specific needs.

Get a Quote for your Microsoft Access Training