Access 2007 - Microsoft Certified Application Specialist In A Box

Course Overview

This certification course provides a complete training solution to fully prepare students to achieve MCAS Accreditation.

Included are;

• 2-days Instructor Led Training using MCAS Official Courseware
• MCAS Practice Exam Voucher
• MCAS Exam Voucher + FREE Retake
• MCAS A4 Pad
• MCAS Pen
• MCAS Mouse Mat
• Branded MCAS Carry Case

Examinations

During the course, you will have the opportunity to test your knowledge and complete a full practice exam before taking the final exam at the end of day 2.

Prerequisites

Delegates should have a good working knowledge of MicrosoftOffice Access 2007before taking this certification course.

Course Outline

During the 2 day course you will cover the following topics to prepare you for exam 77-605 Using Microsoft Office Access 2007;

Structuring a Database

• Define data needs and types
• Define and print table relationships
• Add, set, change, or remove primary keys
• Split databases

Creating and Formatting Database Elements

• Create databases
• Create tables
• Modify tables
• Create fields and modify field properties
• Create forms
• Create reports
• Modify the design of reports and forms

Entering and Modifying Data

• Enter, edit, and delete records
• Navigate among records
• Find and replace data
• Attach documents to and detach from records
• Import data

Creating and modifying queries

• Create queries
• Modify queries

Presenting and Sharing Data

• Sort data
• Filter data
• Create and modify charts
• Export data
• Save database objects as other file types
• Print database objects

Managing and Maintaining Databases

• Perform routine database operations
• Manage Databases

Access 2007 - Microsoft Certified Application Specialist In A Box / MSACMCAS