book a course

Our Training

Build the confidence and skills you need to succeed with our practical professional development and IT courses, led by expert trainers with ongoing support.
See all courses

Explore our courses

IT & Digital Skills

Professional Development

PD Training

Build confidence, leadership, and workplace skills with our practical professional development courses. Delivered in Perth or live online, with expert trainers and ongoing support included.

read more

Explore our programs

Communication

Leadership

Project Management

Qualifications

Advance your career with nationally recognised qualifications and practical training. Delivered in Perth or live online, with expert trainers and ongoing support.
Learn More

Explore our Qualificationss

Microsoft Access Introduction

Microsoft Partner Access Logo
Free Post-course Support
100% Quality
Guarantee
Interactive
Learning
eCertificate of Attendance

Microsoft Access Introduction

In Person Virtual

This course is available as a private group session or 1-on-1 training only. Enquire today to learn more!

Location: Training can be delivered at our Perth CBD training centre, at your site or virtually for added convenience
Duration: 1 Day

Our Perth CBD venue is easy to access by public transport.

Course Overview

Course Overview

Learn the skills to create and maintain database tables, queries, screen forms and reports using this powerful database management program.

Dates

No upcoming dates available.

Book a course

This course is available as a private group session or 1-on-1 training only. Enquire today to learn more!

Course Information

Course Content

Access Screen Elements

  • The Ribbon & the backstage area
  • The quick access toolbar

Database Concepts

  • Designing and scoping your database
  • Relational database concepts
  • Database objects

Database Tables

  • Design and create database tables
  • Working with lookup tables
  • Working with table structure
  • Using the primary key
  • Creating calculating fields in a table
  • Working with transactional records
  • Sorting and filtering data on a table

Select Queries

  • Query concepts
  • Designing a select query
  • Setting query criteria
  • Using wildcards in query criteria
  • Create calculations in queries

Working with Forms and Reports

  • Create a form using the form wizard
  • Create a report using the report wizard
  • Working with grouped reports
  • Creating statistical reports
  • Printing reports

By the end of the workshop, participants will be able to:

  • Understand important database management concepts
  • Create and maintain database tables, queries, screen forms and reports

A familiarity with the computer keyboard and Windows is desirable.

“Thank you for a great introduction to Access and I look forward to learning more about building queries in the intermediate course.” – Jessica from Dept of Education

“The facilitator’s knowledge, skills and experience and the handouts to assist in the learning of Access were the best features” – Karen from Dept of Health

“I did not have any knowledge of Access and feel confident with what I have learnt to move to the next level.” – Suzanne from Public Transportation Authority

“Great intro to access, easy to follow” – Sharlene from Home Chef

“Great Trainers, modern facilities, caters to small class sizes.” – Paul from Chevron

“Hands-on and able to ask questions where required. Well paced and very helpful presenter.” – Caryn from Dept. of Health

“The best features were the pace and clarity of the presenter, and the course material.” – Michael from City of Melville

“The presenter was great for working through some further examples based on our workplace requirements.” – Amanda from Public Transport Authority

“The best features were the instructor’s knowledge, patience and great ability to explain.” – Josephine from Perth Cathedral

FAQs

No FAQs found.