This two-day course is for beginners who want to create mission-critical Access databases. Make sure your database will be soundly built. Learn to design user forms, queries and reports. See how to mail merge information to MS Word.

You will learn to:

• Design databases
• Use the ribbon
• Create Access database and tables
• Create and modify tables and set a primary key
• Set up field properties
• Work witht multi-value fields
• Import and link to tables
• Add and edit data
• Modify datasheet layouts
• Create and edit relationships
• Design and modify forms
• Sort and filter data
• Create queries with single and multiple tables
• Create queries using criteria for multi-value fields
• Print reports
• Set upmail merge to Word

Who would benefit from the course?

This course is designed for new users of Access especially those wanting to leave the wizards behind and create business-critical databases.

Pre-requisites

Delegates should be familiar with the rudimentary PC keyboard and mouse.