Access Creating Applications
Upcoming dates
Click a date to book online.
| Location | Sept 26 | Oct 26 | Nov 26 |
|---|---|---|---|
| Auckland | |||
| Hamilton | |||
| Wellington | |||
| Christchurch | |||
| Virtual |
Overview
This course is designed for competent users of Microsoft Access (referred to in this course as Access) wanting to make the transition into database development.
Our aim is to provide you with the basic skills necessary to develop new databases and maintain existing databases.
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: Essential Skills and Access: Data Analysis and Reporting covers the material examined in the MOS Access core exam.
Who should attend
Competent users of Microsoft Access wanting to make the transition into database development, who are currently using Microsoft Access.
Prerequisites
We require that students have either:
- Completed Access Essential Skills and Access Data Analysis And Reporting and practised recently with topics covered in these courses
Or
- Have equivalent experience of Access and a sound familiarity with other Microsoft packages
What you'll learn
This course is designed for competent users of Microsoft Access wanting to make the transition into database development. Our aim is to provide you with the fundamental skills necessary to develop new databases and maintain existing databases.
Course content
- Planning the Development
- Normalization
- Creating Tables
- Relationships, Foreign Keys and Integrity
- Creating Forms
- Creating the Combo Box
- Main and Sub Forms
- Option Groups
- The Tab Control
- Calculations on Forms
- Using Macro Button Wizard
- Switchboards and Startup
- Compacting a Database
- Analyze Performance
- Importing Data
- Analyze Table
- Database Documenter
Common questions
When does Access Creating Applications next run?
The next date is Mon, 28 Sept 2026, and there are 4 further dates scheduled. Delivered ACE Training Auckland, ACE Training Hamilton, ACE Training Wellington, ACE Training Christchurch. Every date and its format is listed on this page.
How much does Access Creating Applications cost?
From $925 + GST per person. Pricing can differ by date and location, so check the option you want before booking.
Can we pay by invoice instead of by card?
Yes. Choose 'Pay by invoice' when you book and we'll hold your place and send the invoice to your accounts address, with a purchase order number on it if you need one. You can also pay by card at the time of booking if that's easier.
Do I need any prior experience?
We require that students have either: Completed Access Essential Skills and Access Data Analysis And Reporting and practised recently with topics covered in these courses Or Have equivalent experience of Access and a sound familiarity with other Microsoft packages
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-Creating-Applications when you enquire.