Microsoft Access 2007 - Beyond the Basics
This one-day course is for users who have created Access databases. Covering primary and foreign keys, indexes, multi-table forms, calculated fields, action queries and multi-table reports.
Course Outline
- Working with forms
- Multi-table forms
- Calculated fields
- Showing lists on forms
- Display options on forms
- Advanced queries
- Changing query joins to show missing data
- Creating queries that ask for criteria at run-time
- Analysing information with pivot table queries
- How to find duplicates and unmatched records
- How to use queries to delete, add and update data
- Creating reports based on multiple tables
- Creating reports based on other reports and queries
Who would benefit from the course?
This course is designed for existing users of Access especially those wanting to leave the wizards behind and create business-critical databases.
Pre-requisites
Delegates should have used Access already, although this may be limited to using wizards.
