Exam Profile 77-605: Microsoft Office Access 2007
- Exam Details / Trouble Spots
- Preparation Hints / Recommended Study Resources
- Exam Objectives / Where to Go from Here
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.