Last Updated: Sep 05, 2026
No. of Questions: 135 Questions & Answers with Testing Engine
Download Limit: Unlimited
Our Online Test Engine & Self Test Software of TestSimulate 77-885 actual study materials can simulate the exam scene so that you will have a good command of writing speed and time. Then multiple practices make you perfect while in the real Microsoft 77-885 exam. The package practice version will not only provide you high-quality 77-885 exam preparation materials but also various studying ways.
TestSimulate has an unprecedented 99.6% first time pass rate among our customers.
We're so confident of our products that we provide no hassle product exchange.
From your first practice test to the day you book the exam, TestSimulate covers the whole Microsoft MS Access 2010 journey: 135 regularly updated questions, three study formats, 365 days of free updates, and a conditional money back guarantee. For busy professionals in 2026, one reliable source of 77-885 preparation beats a dozen half-finished resources.
| Certification Vendor: | Microsoft |
|---|---|
| Exam Name: | Microsoft Access 2010 |
| Exam Number: | 77-885 |
| Passing Score: | 700 (scaled score out of 1000) |
| Exam Price: | Approximately 100–150 USD (varies by region) |
| Exam Format: | Performance-based tasks, Live Microsoft Access environment simulation |
| Related Certifications: | Microsoft Access Expert Microsoft Office Specialist (MOS) Master |
| Real Exam Qty: | Approximately 20–50 performance-based tasks |
| Available Languages: | English, French, Spanish, Chinese (Simplified and Traditional), German, Japanese |
| Certificate Validity Period: | Does not expire (historically perpetual MOS certification) |
| Exam Duration: | 50 minutes |
| Recommended Training: | Microsoft Learn (MOS training resources) |
| Exam Registration: | Microsoft Certification Portal |
| Sample Questions: | Microsoft 77-885 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/ |
| Section | Objectives |
|---|---|
| Topic 1: Create and manage databases | - Create a new database structure
|
| Topic 2: Create forms | - Use form controls
|
| Topic 3: Manage macros and basic automation | - Create macros
|
| Topic 4: Create tables | - Define table structure
|
| Topic 5: Create queries | - Advanced query operations
|
| Topic 6: Create reports | - Build reports
|
The 77-885 exam is the official Microsoft exam behind Microsoft MS Access 2010 — passing it earns you the Microsoft Office Specialist (MOS): Access 2010 certification, a credential positioned at the Associate level. It is built for candidates who want to validate the skills measured by Microsoft MS Access 2010. Depending on your track, the exam is also linked to the Microsoft Office Specialist (MOS) Master and Microsoft Access Expert certifications, so one pass can move you toward more than one Microsoft credential.
The 77-885 exam presents Approximately 20–50 performance-based tasks questions to be completed within 50 minutes. That pace leaves little room for second-guessing: read each question carefully on the first pass, flag the ones you want to revisit, and keep moving instead of stalling on a single item. Before exam day, run at least one full timed session in the TestSimulate desktop or online test engine with a comparable question load — a steady rhythm under the clock is a trainable skill, and it is often what separates a pass from a near miss.
To pass the 77-885 exam you need 700 (scaled score out of 1000), and the official registration fee is Approximately 100–150 USD (varies by region). Keep in mind that a failed attempt means paying that fee again in full — retakes are not discounted. Given the cost, self-test before you book: if you can score comfortably above the passing mark on two or three consecutive timed TestSimulate practice tests, your budget is far better spent on the exam itself than on a retake.
No formal prerequisites required, but familiarity with Microsoft Access 2010 is recommended Because Microsoft revises its certification programs from time to time, treat this as a starting point rather than the final word. Confirm the current eligibility requirements on the official Microsoft exam page before you register.
Registration for the 77-885 exam is handled through the official channels below:
Delivery method: Onsite or online proctored exam at authorized testing centers — pick the option that suits you best when booking your slot.
Microsoft points Microsoft MS Access 2010 candidates toward the following official courses:
Official courses build the foundation; pairing them with the 135 77-885 practice questions from TestSimulate turns that knowledge into exam-day readiness.
Yes. A free PDF demo of the 77-885 practice questions is available, so you can check the question style and answer quality before spending anything. Every purchase also includes 365 days of free updates — whenever Microsoft adjusts the Microsoft MS Access 2010 blueprint, your material is refreshed at no cost during that period. After the first year, you can extend the update service at a 50% discount from your member zone.
TestSimulate backs your purchase with a 100% Money Back Guarantee. If you take the corresponding exam within 60 days of purchase and do not pass, you can claim a full refund by submitting a scanned copy of your exam enrollment slip together with the official Score Report PDF within 2 days of your exam date; approved claims are processed within 7 days. The guarantee applies only to the exam matching your purchase, the candidate name must match the payer name, and it does not cover attempts taken within 3 days of purchase, candidates who downloaded the material but never sat the exam, expired orders, or free materials. If you would rather keep preparing, you can exchange the product for two free exam preparation packages of equal value and keep the update service on your original purchase.
Delivery is instant: your download is available right after payment, and a copy is emailed to you within one minute. If nothing arrives within 2 hours, check your spam folder and contact our support team. There is no limit on the number of computers you can install the software on.
The Microsoft MS Access 2010 syllabus is organized into 6 domains. Among the headline areas are Manage macros and basic automation, Create reports, Create forms. Rather than copying every subtopic here, we keep the complete, current outline in the Exam Topics section above — work through it domain by domain with the TestSimulate 77-885 practice questions so nothing on the blueprint catches you off guard.
You have opened an Access form in the Design view. The form has header and footer. You want to save the entire form as the report. What will you do?
Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).
You are working on a table named HumanResources created in Microsoft Access 2010. You need to insert a new field in the table in order to enter new information. Choose and reorder the steps that you will take to accomplish the task.


1 - Open the table in the Datasheet view.
2 - Put the cursor on the existing field
3 - Riqht-click on the field.
4 - Select the Insert Field option.
5 - Enter a new field definition.
Explanation:
1.Open the table in the Datasheet view.
2.Put the cursor on the existing field.
3.Right-click on the field.
4.Select the Insert Field option.
5.Enter a new field definition.
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 OrdersDatabase created in Microsoft Office Access 2010. The database contains several tables. You have created a report named OrdersReport, which is connected to a table named OrdersTable. After some days, you have renamed the table as OrdersInfo. How will this change affect the report?
Explanation: Only visible for TestSimulate 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.
Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).
Which of the following datatypes is used to attach Microsoft Office files, graphics files, sound files, and pdf files to a table?
Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).
Zachary
Breenda
Edwina
Hedda
Kristin
Mignon
Prudence
TestSimulate is the world's largest certification preparation company with 99.6% Pass Rate History from 74030+ Satisfied Customers in 148 Countries.
Over 74030+ Satisfied Customers
