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
- Designing databases
- How to use the ribbon
- Creating Access database and tables
- Creating and modifying tables and setting a primary key
- Field properties
- Importing and attaching tables
- Adding and editing data
- Datasheet layouts
- Creating and editing relationships
- Designing and modifying forms
- Adding controls
- Using properties
- Sorting and filtering data
- Queries and dynasets
- Printing Reports
- 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.
