Microsoft Access 2007 - A Running Start
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.
Course Outline
- Introduction to databases
- Learn how to design databases
- Understand how to use the ribbon
- See how to create Access database and tables
- Learn about creating and modifying tables and setting a primary key
- Cover field properties
- Learn about multi-value fields
- Understand importing and attaching tables
- Look at adding and editing data
- Cover datasheet layouts
- Learn to create and edit relationships
- Learn to design and modify forms
- Cover sorting and filtering data
- See how to create queries with single and multiple tables
- Learn to create queries using criteria for multi-value fields
- Understand how to print reports
- Cover mail 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.
