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

June 24th, 2018

  • Basics
  • Intermediate
  • Advanced

Access – Basics


Detailed Content

By the end of this course, participants will be able 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

By the end of this course, participants will be able 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

By the end of this course, participants will be able 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

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