With Microsoft Access XP you will learn how to generate, analyse, and create reports on paper, online, or in HTML format without hours of work with the help of Microsoft Access XP. This title instructs the beginner, to the advanced user on getting the most out of the powerful relational database. Our instructor-based, interactive learning system will guide you through this powerful program and show you how to utilise all of the tools contained within the world's most popular database program.

Microsoft Access XP training comes to life with our full motion video, challenging labs, critical assessment and real-world insight from experts with vast experience in the subject matter. Our proven methodology provides an unequalled training experience with exceptional results.

Access Levels I, II and III: Microsoft Office Specialist (MOS) MOUS Certification Training Exam Objectives and skill sets for the Microsoft Access 2002 Expert Exam are provided below to assist in your exam preparation:

• Creating and Using Databases Create Access databases Open database objects in multiple views Move among records Format datasheets
• Creating and Modifying Tables
• Create and modify tables Add a predefined input mask to a field Create Lookup fields Modify field properties
• Creating and Modifying Queries
• Create and modify Select queries Add calculated fields to Select queries
• Creating and Modifying Forms
• Create and display forms Modify form properties
• Viewing and Organising Information
• Enter, edit, and delete records Create queries Sort records Filter records
• Defining Relationships
• Create one-to-many relationships Enforce referential integrity
• Producing Reports
• Create and format reports Add calculated controls to reports Preview and print reports
• Integrating with Other Applications
• Import data to Access Export data from Access Create a simple data access page