Access Essential Skills
Overview
This course is designed for new users of Microsoft Access (referred to in this course as Access).
Our aim is to provide you with the basic skills necessary to retrieve information from an existing Access database and present that data in a report.
It is important that you use your new skills as soon as possible on completion of this training course. We encourage you to take your own notes and to review this Course Guide once you are back at your workplace.
This course in conjunction with Access: Data Analysis and Reporting and Access: Creating Applications covers the material examined in the Microsoft Office Specialist Access exam.
Who should attend
New users of Microsoft Access who want to gain the skills to retrieve information from an existing Access database and present that data in a report.
Prerequisites
Personal computer skills, Microsoft Windows and file handling skills. Excellent knowledge of Excel or Word fundamentals. (Excel is preferred)
What you'll learn
Our aim is to provide you with the skills necessary to use an existing Access database. We will look at maintaining records and accessing their information to generate reports.
Course content
- Relational Databases
- The Access Window
- Navigating Data
- Entering Data
- Editing Data
- Finding Data
- Select Queries
- Parameters in Queries
- Summary Totals Queries
- Using Reports
- Access and Other Applications
Common questions
When does Access Essential Skills next run?
The next date is Mon, 14 Sept 2026, and there are 5 further dates scheduled. Delivered ACE Training Auckland, ACE Training Wellington, ACE Training Christchurch, live online. Every date and its format is listed on this page.
How much does Access Essential Skills cost?
From $475 + GST per person. Pricing can differ by date and location, so check the option you want before booking.
Do I need any prior experience?
Personal computer skills, Microsoft Windows and file handling skills. Excellent knowledge of Excel or Word fundamentals. (Excel is preferred)
Can I attend online, or does it have to be in a classroom?
Both. Some dates run live online and others in-class — each date on this page shows its format, so pick whichever suits.
Can you run this course for my team?
Yes. Any ACE course can be delivered in-house at your workplace and tailored to your team's tools and goals — quote course code Access-Essential-Skills when you enquire.