Practicing under time limits can make Microsoft MS Access 2010 feel more manageable on exam day. The CertkingdomPDF desktop and online test engines let you work through 77-885 practice questions in two modes, review your history, and repeat weak areas.
Choose Your 77-885 Study Format
- Printable PDF: prepared by experts, available for instant download, suitable for study anywhere, and supported by 365 days of free updates.
- Desktop Test Engine: installable Windows software with two practice modes, offline access, and an environment that simulates the exam experience.
- Online Test Engine: instant access through major web browsers on Windows, Mac, Android, and iOS, with test history and performance review.
Order Support from CertkingdomPDF
- Security and privacy protection backed by McAfee.
- A free PDF demo is available so you can review the format and quality before purchasing.
- Every purchase includes 365 days of free updates, with renewal available at a 50% discount after expiration.
- Products are delivered by instant download and by email within one minute after payment. Contact customer support if the message does not arrive within two hours.
- There is no restriction on the number of computers where the product can be installed.
Microsoft 77-885 Exam Overview:
| Certification Vendor: | Microsoft |
|---|---|
| Exam Name: | Microsoft Access 2010 |
| Exam Number: | 77-885 |
| Exam Price: | Approximately 100–150 USD (varies by region) |
| Available Languages: | Japanese, Chinese (Simplified and Traditional), French, Spanish, English, German |
| Exam Duration: | 50 minutes |
| Certificate Validity Period: | Does not expire (historically perpetual MOS certification) |
| Real Exam Qty: | Approximately 20–50 performance-based tasks |
| Exam Format: | Live Microsoft Access environment simulation, Performance-based tasks |
| Passing Score: | 700 (scaled score out of 1000) |
| Related Certifications: | Microsoft Office Specialist (MOS) Master Microsoft Access Expert |
| Recommended Training: | Microsoft Learn (MOS training resources) |
| Exam Registration: | Microsoft Certification Portal |
| Sample Questions: |  |
| Exam Way: | Onsite or online proctored exam at authorized testing centers |
| Pre Condition: | No formal prerequisites required, but familiarity with Microsoft Access 2010 is recommended |
| Official Syllabus URL: | https://learn.microsoft.com/ |
Microsoft 77-885 Exam Syllabus Topics:
| Section | Objectives |
|---|---|
| Topic 1: Manage macros and basic automation | - Run and manage macros
|
| Topic 2: Create queries | - Advanced query operations
|
| Topic 3: Create reports | - Build reports
|
| Topic 4: Create tables | - Modify tables
|
| Topic 5: Create forms | - Use form controls
|
| Topic 6: Create and manage databases | - Create a new database structure
|
Microsoft 77-885 Exam Questions Answered
The 77-885 exam leads to the Microsoft Office Specialist (MOS): Access 2010 certification from Microsoft. It is positioned at the Associate level. The exam validates the knowledge and skills expected of candidates preparing for Microsoft MS Access 2010.
Related certifications include:
- Microsoft Office Specialist (MOS) Master
- Microsoft Access Expert
The 77-885 exam includes Approximately 20–50 performance-based tasks questions and allows 50 minutes. Before test day, divide the available time by the number of questions in a timed practice set to establish a steady per-question pace. If a difficult item starts consuming too much time, mark it for review and move forward instead of losing momentum. A full timed practice session can help you decide when to move on, when to return, and how much buffer to reserve for a final check.
The passing score for 77-885 is 700 (scaled score out of 1000), and the official exam fee is Approximately 100–150 USD (varies by region). Because a retake requires paying the exam fee again, use timed practice results as a readiness check before scheduling your next attempt. If your performance remains inconsistent, continue reviewing weak domains and repeat a timed session before booking the exam.
No formal prerequisites required, but familiarity with Microsoft Access 2010 is recommended
Eligibility rules can change, so confirm the current requirements on the official exam page before registering.
You can register through the official channels listed below:
The available exam delivery method is Onsite or online proctored exam at authorized testing centers.
The official training options include:
After reviewing the recommended training, reinforce what you learned with CertkingdomPDF's 135 practice questions for 77-885.
Yes. CertkingdomPDF provides a free PDF demo so you can review the format, question style, and answer quality before placing an order. Your purchase includes 365 days of free updates, and expired products can receive continued update service at a 50% discount.
If you purchase the corresponding 77-885 preparation material and do not pass that exam within 60 days of purchase, you may apply for a full refund under the 100% Money Back Guarantee. The request requires a scanned exam enrollment slip and the official Score Report PDF, submitted within two days after the exam. Eligible requests are processed within seven days.
Claims are not eligible if the exam was taken within three days of purchase, the product was downloaded without an exam attempt, the order was free or expired, or the candidate name does not match the payer name. If you prefer an exchange instead of a refund, you can receive two free products of equal value while keeping the update service for your original purchase.
Delivery is immediate after checkout. The download is available right away, and the product is also sent to your email within one minute. Contact customer support if it has not arrived within two hours. You may install the product on an unlimited number of computers.
The current 77-885 outline is organized into 6 top-level domains. The first listed areas include:
- Create reports
- Create queries
- Create and manage databases
Review the Exam Topics section above for the complete outline and any nested subtopics.
Microsoft MS Access 2010 Sample Questions:
Which of the following datatypes cannot be filtered by using common filters?
Each correct answer represents a complete solution. Choose two.
- A. Hyperlink
- B. AutoNumber
- C. Calculated Field
- D. OLE Object
Correct Answer: C,D 🗳️
Explanation: Only visible for CertkingdomPDF members. You can sign-up / login (it's free).
Which of the following has a set of commands or functions (save, undo, and redo) that are independent of the tab on the ribbon currently displayed in MS Access 2010?
- A. Quick Access Toolbar
- B. Title bar
- C. Navigation Pane
- D. Module
Correct Answer: A 🗳️
Explanation: Only visible for CertkingdomPDF members. You can sign-up / login (it's free).
You work as a Database Designer for Tech Perfect Inc. The company has a Windows Vista-based computer with Microsoft Office 2010 installed on it. The computer contains a database named Order1 created in Microsoft Office Access 2010. You want to open the database in shared mode so that all users can insert, modify, and delete data from the database. In which of the following modes will you open the database to accomplish the task?
- A. Open exclusive read-only
- B. Open read-only
- C. Open
- D. Open exclusive
Correct Answer: C 🗳️
Explanation: Only visible for CertkingdomPDF members. You can sign-up / login (it's free).
You work as a Database Designer for Tech Perfect Inc. The company has a Windows Vista-based computer that has Microsoft Office 2010 installed on it. The computer has a database named Sales created in Microsoft Office Access 2010. The database contains a table named Products. Some records in the table are incomplete or missing. You need to complete the records. For this reason, you want to rearrange the table in such a manner that it displays the incomplete or missing records on the top of the respected column. What will you do to accomplish the task?
Each correct answer represents a complete solution. Choose two.
- A. Right-click on the column header and choose the Sort Smallest to Largest option.
- B. Select the column and click on the Toggle Filter button.
- C. Select the column and click on the Ascending button.
- D. Select the column and click on the Descending button.
Correct Answer: A,C 🗳️
Explanation: Only visible for CertkingdomPDF members. You can sign-up / login (it's free).
You work as a Database Designer for Tech Perfect Inc. The company has a Windows Vista-based computer with Microsoft Office 2010 installed on it. The computer has a database named Details. The database contains several tables. You open a table named Staffs which contains all information about employees working in 1997. The structure of the table is given in the image below:
Now, you want to delete this table from the database. You get an error while deleting the table. Which of the following is the most likely cause of the error?
- A. The table does not have a primary key.
- B. The table uses referential integrity.
- C. The table is opened in the Design view.
- D. The table is connected with another table.
Correct Answer: C 🗳️
Explanation: Only visible for CertkingdomPDF members. You can sign-up / login (it's free).
Elva 
Jacqueline 
Asa 
Sharon 
Todd 
August 
Isaac 
Dwight 
Hiram 
Peter 
Margaret 
Ella 
Fitch 
Lawrence 
Mandel 
Heather 
Brook 
