Home > Articles > Microsoft

Exam Profile 77-605: Microsoft Office Access 2007

  • Print
  • + Share This
This article profiles the Microsoft Office Access 2007 exam (77-605), intended to help candidates prove their competency with this complex product. Pearson IT Certification provides a variety of exam preparation tools to help our customers in their quest for certification. As part of our service to you, we have developed this Exam Profile series. Each profile is developed based on the testing experience of one of our trainers or authors. You won’t get exact questions or answers, but you will get a real feel for the exam. Each profile describes question forms, trouble spots, hints for exam preparation, and recommendations for additional study resources. Find out what you can expect to see on the exam and how you can better prepare for it.

Microsoft Access is probably the least understood product in the entire Microsoft Office 2007 suite. Passing Exam 77-605 will help candidates to prove their competency with this complex and often overlooked product. Furthermore, learning Microsoft Access is a great first step for those who want to eventually learn SQL Server.

Exam Details

  • Number of questions: Microsoft does not disclose the number of questions on their exams, but this exam is estimated to have about 50 questions.
  • Type(s) of questions: The questions are primarily multiple choice, but you might encounter build a tree, reorder, or simulation questions.
  • Passing score: 700 / 1000
  • Time limit: Microsoft does not disclose the exam’s time limit, but it is estimated to be about 90 minutes
  • How to Register: Certiport

In recent months, Microsoft has made a direct effort to limit access to the types of exam statistics listed above. The number of questions, types of questions, passing score, and time limit listed here are based on information found on various Internet message boards, but Microsoft could adjust these aspects of the exam at any time.

Trouble Spots

As database related exams go, Exam 77-605 is surprisingly straightforward. The entire exam is based on six primary objectives, none of which are really all that complicated. The vast majority of the skills measured on the exam have to do with basic product usage. Anyone who has spent a fair amount of time using Microsoft Access 2007 should have no trouble with most of the exam objectives.

There are really only two main trouble spots on this exam. The first trouble spot has to do with being overconfident. It is easy to look at a list of relatively simple exam objectives and dismiss the need for adequate preparation. However, failing to prepare for this exam would be a mistake. After all, the questions on the exam are designed to test your knowledge of Access 2007 as a whole, and therefore the exam probably contains questions related to features that you do not use on a daily basis.

The other potential trouble spot with this exam has to do with terminology. In the past, I have seen users master various Microsoft products without ever learning the Microsoft-approved terminology for the features that they use every day. Passing this exam absolutely requires you to be familiar with the basic database terminology. For example, you will need to know the difference between databases, tables, fields, and forms.

  • + Share This
  • 🔖 Save To Your Account

Related Resources

There are currently no related titles. Please check back later.