On-line training course catalogue

Access 2007 – Microsoft Certified Application Specialist in a Box

Type of course: Classroom

Course details

Fee	£395
Days	2
Course code	MSACMCAS

Course dates

Location	Aug	Sep	Oct	Nov	Dec	Jan
London King William Street	|-	|4	|-	|-	|-	|-

Booking: click a course date | View location: click location name | Print this page | Download as Word document |

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

Prerequisities

Delegates should have a good working knowledge of Microsoft Office Access 2007 before 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

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.