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.
There is no waiting around with TestSimulate: your 77-885 study material reaches your inbox within a minute of payment, ready to download right away. You can start working through the 135 practice questions for Microsoft MS Access 2010 today.
| Certification Vendor: | Microsoft |
|---|---|
| Exam Name: | Microsoft Access 2010 |
| Exam Number: | 77-885 |
| Exam Price: | Approximately 100–150 USD (varies by region) |
| 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) |
| Exam Duration: | 50 minutes |
| Related Certifications: | Microsoft Access Expert Microsoft Office Specialist (MOS) Master |
| Certificate Validity Period: | Does not expire (historically perpetual MOS certification) |
| Available Languages: | Chinese (Simplified and Traditional), Spanish, English, French, Japanese, German |
| 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 tables | - Modify tables
|
| Topic 2: Create reports | - Build reports
|
| Topic 3: Manage macros and basic automation | - Run and manage macros
|
| Topic 4: Create and manage databases | - Create a new database structure
|
| Topic 5: Create queries | - Advanced query operations
|
| Topic 6: Create forms | - Design forms
|
The 77-885 exam, officially titled MS Access 2010, is the qualifying exam for the Microsoft Office Specialist (MOS): Access 2010 certification, which sits at the Associate level. Earning it shows employers that you have the skills the credential stands for, and it is a solid step forward on a Microsoft career path. It also connects to Microsoft Office Specialist (MOS) Master, Microsoft Access Expert, so the effort you put in now keeps paying off as you advance.
The 77-885 exam gives you Approximately 20–50 performance-based tasks questions to complete within 50 minutes. Do the math before exam day: divide the total time by the question count to set a steady per-question pace, and flag any item that stalls you so you can return to it after securing the easier points. The most reliable way to build that rhythm is a full timed practice test under the same limit, which is exactly what TestSimulate's test engines are designed for.
The passing score for Microsoft MS Access 2010 is 700 (scaled score out of 1000), and the official registration fee is Approximately 100–150 USD (varies by region). Keep in mind that a retake means paying that fee again in full, which makes an honest self-check worthwhile: before you book, sit a timed practice test and make sure you are consistently scoring above the passing line with some margin to spare.
According to the official requirements: No formal prerequisites required, but familiarity with Microsoft Access 2010 is recommended. Eligibility rules do change from time to time, so confirm the current details on the official exam page before you register.
Registration for the 77-885 exam is handled through the official channels below:
The exam is delivered in the following format: Onsite or online proctored exam at authorized testing centers. Pick a date that leaves room for at least one full timed practice test beforehand.
Microsoft recommends the following official training options for candidates preparing for Microsoft MS Access 2010:
Courses build the foundation, but they work best alongside question practice. That is where TestSimulate comes in: the 135 practice questions in our 77-885 package let you rehearse the exam format at your own pace and see exactly where you stand.
Yes — TestSimulate offers a free PDF demo of the Microsoft MS Access 2010 material, so you can review the question style and answer quality before you spend anything. After purchase, you also receive 365 days of free updates, and if your product expires you can extend the update service at a 50% discount from your member zone.
If you take the corresponding exam within 60 days of your purchase and do not pass, you are covered by the 100% Money Back Guarantee under clear conditions. To claim a full refund, submit a scan of your exam enrollment slip and your official Score Report PDF within two days of the exam; requests are processed within seven days. Note that sitting the exam within three days of purchase is not eligible, purchases that were never followed by an exam sitting do not qualify, free materials and expired orders are excluded, and the candidate name must match the payer name. Prefer an exchange instead? You can swap your product for two free exam packages of equal value and keep your update service. Delivery is immediate: your 77-885 material is ready for instant download and is also emailed to you within one minute of payment — contact customer service if nothing arrives within two hours. There is no limit on the number of computers you can install it on.
The current Microsoft MS Access 2010 syllabus is organized into 6 exam domains. The first three are:
For the full domain and subtopic breakdown, see the Exam Topics section above — that is the outline your TestSimulate practice questions are mapped to.
You are working on a home computer with Microsoft Office 2010 installed on it. You are creating a form in Microsoft Office Access 2010 in order to control the execution of Access database application. Which of the following capabilities does this object provide?
Each correct answer represents a complete solution. Choose all that apply.
Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).
You are working on an Access form named Form-A . You want to apply a new theme to the form to provide a consistent look and feel across all its elements. Choose and re-order the steps that you will take to accomplish the task.


1 - Click on the Design contextual tab.
2 - Click the Themes button in the Themes group.
3 - Select the desired theme effect from the drop-down list.
Explanation:
1.Click on the Design contextual tab.
2.Click the Themes button in the Themes group.
3.Select the desired theme effect from the drop-down list.
Which of the following types of Access queries performs operations on the records that match specified criteria?
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 with Microsoft Office 2010 installed on it. You want to create a blank report in the Design view. Which of the following tools will you use to accomplish the task?
Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).
You are working on a home computer with Microsoft Office 2010 installed on it. Two databases named Database1 and Database3 are created in Microsoft Access 2010. You need to share a common table between these two tables. In order to do this, you have to copy the table from the Database1 to Database3. Choose and reorder the steps that you will take to accomplish the task.


1 - Right-click the table name of Database1.
2 - Select the Copy option from the shortcut menu.
3 - Open the Database3.
4 - Select Edit Paste from the shortcut menu.
5 - Give the name of the new table.
6 - Choose one of the Paste options.
7 - Click the OK button.
Explanation:
1.Right-click the table name and select the Copy option from the shortcut menu.
Or,
Click the Copy button in the Clipboard group on the Home tab.
2.Open the other database and select Edit Paste from the shortcut menu.
Or,
Click the Copy button in the Clipboard group on the Home tab.
Over 74032+ Satisfied Customers

Julius
Max
Hilary
Kevin
Mike
Primo
Taylor
TestSimulate is the world's largest certification preparation company with 99.6% Pass Rate History from 74032+ Satisfied Customers in 148 Countries.