Advanced Microsoft Access 2007 - Masterclass
Who should do this course?
This course is designed for people who already have a good understanding of Microsoft Access, and need to upgrade their skills to creating secure, multi-user systems. This course assumes a thorough knowledge of database design, tables, queries, forms and reports.
About the course
The skills and knowledge covered in this course build on the skills covered in the Fast Track to Microsoft Access 2003 course. Upon completion participants should be able to effectively design a secured, multi-user database.
At the completion of the formal sessions a workshop is conducted where the participants will be encouraged to use their own database model and ideas.
Learning outcomes:
Upon successful completion of this course, participants will be able to:
- Create effective, formula driven validation (on table data)
- Create a split database system, and describe the advantages gained by using Split Model
- Normalise a database to ensure optimal performance
- Use Action queries to manage datasets
- Analyse data using Aggregate and Cross Tab queries
- Create queries to locate orphan records
- Understand the difference between Inner/Left/Right Joins, Union Queries and Cartesian products
- Be familiar with Access SQL syntax
- Design and deploy pivot tables and charts within Access
- Be able to determine an appropriate security/logon regime and understand the differing models that may be applied
- Use basic Access VBA commands with Access Forms and Reports
- Design and modify complex forms and reports
- Build a Report Generator, forming part of a larger Access GUI
- Understand the limits of Access and how to upsize to a server model
Quick Facts
| Level: | Advanced | Price: | $990.00 incl GST | You will receive: |
| Duration: | 2 Days | Discounts*: | 2 Students - 10% | - Certificate of completion |
| Size: | 10 | 3 Students - 15% | - Training Manual | |
| Times: | 9.00am - 5.00pm approx | 4 Students - 20% | - 12 months FREE email support* | |
| Pre-requisites: | Refer to course description | Bonus: | 2 FREE | - FREE class re-sit (if necessary)* |
| Movie Tickets | Course Brochure: | |||
| Access2007_Mstr.pdf | ||||
| * Conditions apply. | ||||
Upcoming Courses
|
Sydney Level 11, 32 Walker Street |
|
|
Melbourne Level 12, 379 Collins Street |
|
|
Brisbane C/- Support Technology, Level 6, 371 Queen St |
|
|
Canberra C/- Training Choice, Level 12, 15 London Circuit |
Date: upon demand |
|
Adelaide C/- Mindfull Computer & Seminar, Level 4, 74 Pirie Street |
Date: upon demand |
For more information on dates or locations, please call 1300 888 724 or enquire online.
Course Units
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|

