Microsoft Access 2007 Intermediate

Course Aims
This intensive, hands-on one-day training course has been designed to give delegates a solid understanding of more advanced Access tools and concepts in order to increase their knowledge and productivity.
Who Should Attend?
Users with a basic understanding of Microsoft Access 2007 who want to consolidate and expand on their knowledge of the basic features in a short space of time. Delegates should have a good working knowledge and understanding of the concepts covered in the Introduction course.
Course Outline: Microsoft Access 2007 Intermediate
Database Design Basics
· Database Design
Advanced File Tasks
· Using My Computer Within Access · Database Management · Saving Your Files · Exporting Files
Working with Tables
· Customizing Tables · Formatting Tables · Controlling Table Data Entry · Managing Table Data Entry
Working with Forms
· Basic Form Controls · Advanced Form Controls · Formatting Your Form · Formatting Controls · Formatting Records
Working with Reports
· Organizing Report Data · Formatting Reports · Common Report Tasks
Working with Queries
· Basic Queries · Multiple Table Queries · Advanced Queries