Access Training Courses | Accredited Microsoft Access Training

Who Should Attend the Course?

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

Database Design Basics

• Database Normalisation • Relating Tables • Referential Integrity

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