Preparation Guide for Exam 77-605
MCAS: Using Microsoft Office Access 2007
On This Page
 | Exam news |
| Audience profile |
| Credit toward certification |
| Preparation tools and resources |
| Skills measured |
Exam news
The Microsoft Certified Application Specialist (MCAS) Exam 77-605: Using Microsoft Office Access 2007 is now available.
Audience profile
Successful candidates for this exam have the equivalent of six months to one year of hands-on experience using Microsoft Office Access 2007 and might have experience using previous versions of Microsoft Access. They are especially effective and efficient at structuring databases, creating and formatting database elements, entering and modifying data, creating and modifying queries, presenting and sharing data, and managing and maintaining the overall database. These candidates are the Office Access 2007 gurus within their organizations.
Credit toward certification
When you pass Exam 77-605: Using Microsoft Office Access 2007, you complete the requirements for the following certification:
| • | Microsoft Certified Application Specialist: Microsoft Office Access 2007 |
Preparation tools and resources
To help you prepare for this exam, Microsoft Learning recommends that you have hands-on experience with the product and that you use the following training resources. These training resources do not necessarily cover all of the topics listed in the "Skills measured" section.
Microsoft E-Learning
| • | Course 4622: What's New in Microsoft Office Access 2007: This e-learning course covers the differences between Microsoft Office Access 2007 and previous versions of the product. |
| • | Collection 5263: Core Training for Microsoft Office Access 2007: This e-learning course was crafted specifically to help prepare you for the exam topics. |
Microsoft Press books
| • | |
| • | Microsoft Certified Application Specialist Study Guide: 2007 Microsoft Office System Edition |
Microsoft Official Academic Course (MOAC)
| • | Course 77-605: Microsoft Office Access 2007 (Wiley.com): This comprehensive Microsoft Official Academic Course includes a textbook, lab manual, and software. The course provides students with the conceptual understanding and real-world experience they need to be ready for the work force and to pass the Microsoft Certified Application Specialist (MCAS) exams for Microsoft Office Access 2007. Each Microsoft Official Academic Course is aligned with existing MCAS exam objectives and includes:
|
Microsoft online resources
| • | 2007 Microsoft Office System – Learning Portal: Find special offers and information on training and certification. |
| • | Product information: Visit the Microsoft Office Access 2007 Web site for detailed product information and download a free trial version of the product. |
| • | Microsoft Learning Community: Join newsgroups and visit community forums to connect with your peers for suggestions on training resources and advice on your certification path and studies. |
| • | TechNet: Designed for IT professionals, this site includes how-to instructions, best practices, downloads, technical resources, newsgroups, and chats. |
| • | MSDN: Designed for developers, the Microsoft Developer Network (MSDN) features code samples, technical articles, downloads, newsgroups, and chats. |
Skills measured
This exam measures your ability to accomplish the following technical tasks by using Microsoft Office Access 2007.
| Skills measured by Exam 77-605 |
| 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. |
Note This preparation guide is subject to change at any time without prior notice and at the sole discretion of Microsoft. Microsoft exams might include adaptive testing technology and simulation items. Microsoft does not identify the format in which exams are presented. Please use this preparation guide to prepare for the exam, regardless of its format.
| • | Learn more and download samples |