Advanced Microsoft Access 2007™ Course
- Duration:2 Days
- Cost:On request
- Ref:ADA07
Suitable for those who have moved to the 2007 version of MS Access
Who is it for
Users with a fair understanding of Access who would like to explore the advanced features and what's new in Access 2007™. This course is an excellent follow up for delegates who have been on the Introduction to Microsoft Access 2007™.
Not sure if this level is right for you? Why don't you
take our quick online test to find out >Prerequisites
A working knowledge of Access introduction topics or attendance to our
Introduction to Access course.What is it about
Microsoft Access 2007™ is a powerful prgramme designed to make storing your information safely and securely a breeze. This course will give you the lowdown on all the useful features, shortcuts and techniques to make data retrieval easy and accurate.
Course Overview
- What's new in Access 2007™
- Creating relational databases
- Database normalising
- Adding referential integrity
- Defining data entry rules
- Using input masks
- Setting a property and validation rule
- Using advanced query features
- How to join a table in queries
- Creating a calculated field and advanced queries
- Summarise and group values
- Creating advanced form design
- Working with graphics, calculations and combo boxes
- Working with unbound controls
- Work with sub-reports
- PivotTables and PivotCharts
- Creating advanced forms and subforms
- Automating data entry
- Creating advanced macros
- Use AutoKeys and AutoExec macros
- Exploring Access SQL
- Work with hyperlink fields
- Work with data access pages
- Secure data by database replication
- Protect databases
What will I get out of it?
You'll learn a wealth of new techniques for manipulating information and the database that will make your life simpler, save you hours and enable you to do precisely what you want with Access 2007™.
Accredited by
