Access Courses

In our Access courses you will learn how to plan, create, structure and report your databases. We cater for all versions and experiences, whether they’ve been self-taught, have been using Access for a while, or have no experience at all. All courses are hands-on, and you’ll learn lots of shortcuts and better ways to manage and report your Access data.

Lots of time-saving shortcuts and more importantly, best-practice and better ways to structure your databases are covered.

Microsoft Access

September 11th, 2021

  • Basics
  • Intermediate
  • Advanced

Access – Basics


Detailed Content

This is a 1-day hands-on, face-to-face session and participants will learn how to:

  • Describe the Access screen layout.
  • Plan a database.
  • State meanings of database terms – primary key, fields, relational.
  • Add fields to create a database.
  • Create simple forms.
  • Enter data to create records.
  • Import data from other programs.
  • Find, sort and navigate data.
  • Create and format simple reports.
  • Create simple queries to extract data.
  • Create reports based on queries.
  • Link tables together.
  • Create queries to combine tables.

Flexible Options

Courses are delivered in our training rooms, or can be conducted in your training room onsite, or as live, online sessions. And content/outcomes can be customised/tailor-made to your requirements.

See Benefits to the right for a list of services provided to all participants (depending on the course).

For more details or to inquire about a closed corporate or online program, use our inquiry form here or phone us on (02) 6041 2711.


Prerequisites

No experience in using Access is required nor assumed. Participants are expected to have some knowledge of and experience with a Windows PC.

Upcoming Dates


    No courses scheduled. Please inquire via phone (02) 6041 2711 or use our Contact Us page

More Dates
Download Course Guide

Benefits

Access – Intermediate


Detailed Content

This is a 1-day hands-on, face-to-face session and participants will learn how to:

  • Revise the basics and shortcuts in using an Access database.
  • Create more tables and link them.
  • Use queries to combine tables.
  • Create calculation queries.
  • Change the design of forms and reports.
  • Create forms and subforms.
  • Add calculations to forms and reports.
  • Format and validate data.
  • Add Windows features to forms (drop downs, check boxes).
  • Create a main menu system.
  • Implement simple security features.

Flexible Options

Courses are delivered in our training rooms, or can be conducted in your training room onsite, or as live, online sessions. And content/outcomes can be customised/tailor-made to your requirements.

See Benefits to the right for a list of services provided to all participants (depending on the course).

For more details or to inquire about a closed corporate or online program, use our inquiry form here or phone us on (02) 6041 2711.


Prerequisites

CLASS Training’s Access Basics course or proven experience with Access.

Upcoming Dates


    No courses scheduled. Please inquire via phone (02) 6041 2711 or use our Contact Us page

More Dates
Download Course Guide

Benefits

Access – Advanced


Detailed Content

This is a 1-day hands-on, face-to-face session and participants will learn how to:

  • Create mail merges with MS Word
  • Assign detailed controls to forms
  • Create automatic field population controls
  • Use report dialogue forms
  • Apply maintenance and security measures
  • Integrate databases with Web pages
  • Create and format macros
  • Use Visual Basic modules
  • Deploy databases to users without Access

Flexible Options

Courses are delivered in our training rooms, or can be conducted in your training room onsite, or as live, online sessions. And content/outcomes can be customised/tailor-made to your requirements.

See Benefits to the right for a list of services provided to all participants (depending on the course).

For more details or to inquire about a closed corporate or online program, use our inquiry form here or phone us on (02) 6041 2711.


Prerequisites

CLASS Training’s Access Intermediate Course or proven experience with Access.

Upcoming Dates


    No courses scheduled. Please inquire via phone (02) 6041 2711 or use our Contact Us page

More Dates
Download Course Guide

Benefits

Recent Reviews – Access Courses

I'm going to save LOTS of time now! (Access - Basics)

Rated 5 out of 5

January 12, 2021

What impressed me most about the course was simply – that I can work it out better!
This training is as good as it gets!

Lachlan (Mechanic)

I can safely say my productivity is going to jump! (Access - Basics)

Rated 4 out of 5

January 12, 2021

Loved the interaction and hands-on learning.
What initially ‘grabbed’ me was a desire to learn more about data systems and how to utilize them. I certainly got that!

Tricia (Program Manager)

My productivity will really jump from this training! (Access - Basics)

Rated 4 out of 5

January 12, 2021

What initially ‘grabbed’ me about this course was a desire to learn more about data systems and how to utilize them. I loved the interaction and hands-on learning very much! Thank you.

Tricia (Program Manager)

I will save so much time now ! (Access - Basics)

Rated 4 out of 5

January 12, 2021

The one big thing I learnt was the ability Access has to do everything from tables to forms to charts thanks to the knowledge of the Trainer!
I did the CLASS Training Excel course and that was of a great quality, hence why this course grabbed my attention.

Amy (Finance Officer)

Add Your Review Here














IT Training AND Courses
EDUCATE, ENHANCE & PERFORM
We are here to help you work smarter with your IT tools. Whether it's for business, work or fun, our services will increase your productivity and minimise your stress. Look around for info about our services and courses, dates, bookings, help desk, resources and more.
  • Analysis of your needs.
  • Face-to-face or live, online.
  • Our training rooms or yours.
  • Extensive training manuals.
  • Help desk support.
Our corporate video
Call (02) 6041 2711