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