Exam 77-605:

MOS: Using Microsoft Office Access 2007

Published:June 19, 2007
Language(s):English, Russian
Audience(s):Information Workers
Technology:Microsoft Office Access 2007
Type:Proctored Exam

How To Get It: Schedule your exam through the following exam provider:

Take exam

Show all itemsHide all items
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 CertificationWhen you pass Exam 77-605: MOS: Using Microsoft Office Access 2007, you complete the requirements for the following certification(s):
Microsoft Office Specialist: Microsoft Office Access 2007
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.
Skills Being MeasuredThis exam measures your ability to accomplish the technical tasks listed below.The percentages indicate the relative weight of each major topic area on the exam.
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.
Preparation Tools and ResourcesTo 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" tab.
Classroom Training There is no classroom training currently available.
Microsoft E-Learning
Microsoft Press Books There are no Microsoft Press books currently available.
Practice Tests There are no practice tests currently available.
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:
    • A six-month trial copy of Microsoft Office Professional 2007.
    • Textbooks that emphasize building skills to prepare students for workforce success by using an instruction strategy that provides:
      • Authentic business scenarios.
      • Immediate introduction of hands-on practice in each lesson.
      • Easy identification of skills that apply to the workplace and to the MCAS exam.
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.
Have Questions? For advice about training and certification, connect with peers: For questions about a specific certification, chat with a Microsoft Certified Professional (MCP): To find out about recommended blogs, Web sites, and upcoming Live Meetings on popular topics, visit our community site:
Exam index