Courses
Access Essential Skills
Length: 1 Day Cost: $425 + GST Version: Access
= Scheduled class 
= Guaranteed to run 
= Fully booked| Centre | Mar | Apr | May | Jun |
|---|---|---|---|---|
| Auckland | 23 | -- | -- | -- |
| Hamilton | -- | -- | 03 | -- |
| Christchurch | 18 | -- | 03 | -- |
| Wellington | 25 | -- | -- | -- |
| Virtual Class | -- | -- | -- | -- |
Can't find a class in your area? Contact our sales team and request a class date.
Not sure about the version of your software? Click here to find out.
Want to know if this course is right for you? Assess your skills level with our online Skills Assessment tool.
About this Course
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.
Prerequisites
Personal computer skills, Microsoft Windows and file handling skills. Excellent knowledge of Excel or Word fundamentals. (Excel is preferred)
At Course Completion
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 Outline
- 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
