Access Courses

Access

Access Introduction
(1 day or 2 evenings)

General Outline
This course concentrates on the basics in creating, editing and formatting a database. The meanings of database terms such as ‘field’, ‘record’, ‘query’ and so on, are covered. You are taken through the planning process in setting up a database, and then how to set it up in Access. How to create and format the database fields, how to enter data and create records, and the important aspects of importing data are covered.

You are then taken through creating and formatting forms and reports, as well as their uses and applications. Queries, what they are, and how they work, are then covered in a number of exercises, including creating basic and more advanced examples. The last exercise looks at the merging of data with Microsoft Word documents to create mailing labels and form letters.

Main Skills Acquired

Describe the Access screen and how it works
Plan a database
Create tables, define fields
Create and format forms
Enter data to create records
Import data from other applications
Find and sort data
Create and format reports
Create and apply simple queries
Link tables and form relationships

Access Intermediate
(1 day or 2 evenings)

General Course Outline

This course builds on the Introductory level and concentrates on creating linked tables and how to work with them. The concepts of linking tables, relationships, and creating queries to combine and extract data are covered in the hands-on exercises. Creating and editing forms and reports is revisited but this time in terms of the linked tables and data relationships. Forms and subforms are covered to show you how to extend the functionality of your database.

You are then taken through other powerful ways of validating data and improving the user-friendliness of your database. Extending from this is the addition of Windows forms on the database to create drop downs, check boxes, and so on, for easy selection and manipulation of data.

Main Skills Acquired

Revise Access shortcuts and basics
Add more tables and create relationships
Use queries to combine tables
Format and design forms and reports
Create forms and subforms
Create calculation queries
Add calculations to forms and reports
Apply data formatting and validating to forms
Add Windows features to forms (drop downs, etc)
Create ‘front-end’ menus and ‘Switchboards’
Control database ‘start-up’ options

Access Advanced
(1 day or 2 evenings)

General Course Outline
This course is designed for the power-user or administrator of Access databases. Detailed implementation of database security features, advanced queries that 'make tables' and 'update tables' and setting up web pages that a database are all covered in the exercises.

Important database deployment issues are covered as well, including what's meant by 'splitting ' a database and when you should consider it.

There's also an introduction to macros and VBA (Visual Basic for Applications) for Access, which allows you to implement more advanced controls and features into your databases.

Main Skills Acquired

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

Access General Information

Previous Experience Recommended
Introductory Course: Experience with a mouse and Windows is recommended.
Intermediate Course: CLASS Training Introductory Course or proven experience with Access.
Advanced Course: CLASS Training Intermediate Course or proven experience with Access.

Class Size
The number of trainees is restricted to a maximum of 10, or as required by your organisation. Each trainee is trained on a Pentium 4 PC with 17" flat-screen monitor and access to broadband Internet, printing and demonstration facilities.

What You'll Receive

Training manual: Our training manual contains hands-on exercises that are easy-to-follow, and are practical and relevant. The training manual will also serve as an excellent reference tool back at the office or home long after the course. Our training manuals are developed and produced in-house by our experienced tutors, who have used the software in real-world situations. All exercises follow a logical sequence and show you how to tackle your typical projects. A list of keyboard shortcuts and other important information is included.

Refreshments: For full-day courses, you will receive a comprehensive lunch and refreshments.

Customisation of courses: We can redesign our courses to cover other or additional outcomes and so make our courses even more relevant for you. Please inquire about this if you have any specific needs.

Support: Free unlimited phone support on the material covered is provided for all courses. The support means that you can phone us during business hours or e-mail us anytime to get answers about any specific problems you might have. If we can't solve your problem immediately we will do some research and get back to you.

Please note: This free support only covers your specific questions that relate back to the material covered in the course you attended. We can provide you with consultancy for additional help you might need beyond that.

Complimentary Follow-up: When the course is running again later and there is a seat available, you'll be invited back for a free refresher. This can be used for fine-tuning your skills or for asking any specific questions you might have. You can come for the whole course or just part of it, and it's a great way to ensure that you maintain your momentum in using the program.

Certificate: You'll receive a certificate of achievement which details the outcomes you achieved for the particular course attended.

Booking Your Place
If relevant, check with your training coordinator for availability of places and dates. Alternatively, you can check our course calendar, then book online to secure your place on one or more of these courses. You can also fax us on (02) 6041 4811 or e-mail at office@classtraining.com.au. If you have any specific queries, or would like to discuss your needs, please phone Mark or Jenny on (02) 6041 2711.

Copyright © CLASS Training 1999-2008
All product names, icons, logos and screenshots are registered trademarks of their respective copyright owners.
Web site designed and produced inhouse by CLASS Training.
All rights reserved. No information displayed in this web site is to be reused nor copied using any means whatsoever without the express written permission of the copyright owner. Please contact office@classtraining.com.au for any inquiries about the web site.