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.

Learn how to:

• Work with forms
• Create sophisticated Multi-table forms
• Use calculated fields
• Show lists on forms
• Display options on forms
• Create advanced queries
• Change query joins to show missing data
• Create queries that ask for criteria at run-time
• Analyse information with pivot table queries
• How to find duplicates and unmatched records
• How to use queries to delete, add and update data
• Create reports based on multiple tables
• Create 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.