One purchase should cover the whole journey from first download to exam day, not just a stack of questions. CertkingdomPDF bundles 135 verified practice questions for the 77-885 exam with 365 days of free updates, a free demo, and support that stays reachable throughout.
Microsoft 77-885 Exam Overview:
| Certification Vendor: | Microsoft |
|---|---|
| Exam Name: | Microsoft Access 2010 |
| Exam Number: | 77-885 |
| Exam Format: | Performance-based tasks, Live Microsoft Access environment simulation |
| Exam Price: | Approximately 100–150 USD (varies by region) |
| Exam Duration: | 50 minutes |
| Available Languages: | English, Japanese, Spanish, Chinese (Simplified and Traditional), German, French |
| Real Exam Qty: | Approximately 20–50 performance-based tasks |
| Certificate Validity Period: | Does not expire (historically perpetual MOS certification) |
| Related Certifications: | Microsoft Access Expert Microsoft Office Specialist (MOS) Master |
| Passing Score: | 700 (scaled score out of 1000) |
| 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: Create tables | - Define table structure
|
| Topic 2: Create forms | - Design forms
|
| Topic 3: Manage macros and basic automation | - Run and manage macros
|
| Topic 4: Create queries | - Build query structures
|
| Topic 5: Create and manage databases | - Create a new database structure
|
| Topic 6: Create reports | - Enhance reports
|
77-885 Exam: Frequently Asked Questions
This package includes 135 practice questions for the Microsoft MS Access 2010 exam. Every answer is verified by an experienced team of experts, so you can trust what you study.
The Microsoft MS Access 2010 exam requires a score of 700 (scaled score out of 1000) to pass, and the official registration fee is Approximately 100–150 USD (varies by region). Factoring in both before you start helps you plan the full cost of certification.
Many candidates combine practice questions with official training. Recommended options include:
One purchase covers the full journey: three versions of the material (PDF, PC test engine, and online version), a free demo to try before buying, 365 days of free updates delivered automatically, and customer service you can reach whenever a question comes up. Nothing essential is sold separately.
The Microsoft MS Access 2010 practice questions are organized around the official exam objectives. Key topics include:
- Create tables ()
- Create forms ()
- Create and manage databases ()
Keeping your revision mapped to these objectives makes every session productive.
Yes. Candidates who come back for additional certifications receive discounts when they buy further practice packages. If you already hold one of our products, ask our staff about the current returning-customer offer before your next purchase.
You can register for the Microsoft MS Access 2010 exam through the official channels:
No formal prerequisites required, but familiarity with Microsoft Access 2010 is recommended
You can confirm the current eligibility requirements on the official 77-885 exam page before you register.
The Microsoft MS Access 2010 exam contains Approximately 20–50 performance-based tasks questions, and you will have 50 minutes minutes to complete them. Training against the same volume of questions prepares both your knowledge and your pace.
Microsoft MS Access 2010 Sample Questions:
Which of the following types of query is commonly useful when queries are used as the basis for a report that is run periodically, but with different values at different times?
- A. Parameter query
- B. Crosstab query
- C. Action query
- D. Select query
Correct Answer: A 🗳️
Explanation: Only visible for CertkingdomPDF members. You can sign-up / login (it's free).
You have a form named Assets created in Microsoft Office Access 2010. You have to make some changes in the formatting of the form. For this reason, you have opened the form in the Design view. Now, you want to display ruler and grid for making the formatting easy. Which of the following steps will you take to accomplish the task?
- A. Right-click on Form Header, and choose the Ruler and Grid options.
- B. Click on the Design contextual tab and choose the Tools option.
- C. Right-click on the form name and choose the Format option.
- D. Click on the Format contextual tab and choose the Conditional Formatting option.
Correct Answer: A 🗳️
Explanation: Only visible for CertkingdomPDF members. You can sign-up / login (it's free).
You want to hide the Navigation Pane using a macro while working on Microsoft Office Access 2010. Choose and re-order the steps that you will take to accomplish the task.
Correct Answer:
1 - Click on the Create tab.
2 - Click the Macro button in the Macros & Code group.
3 - Click on the Design tab.
4 - Click the Show All Actions button in the Show/Hide group
5 - Select the RunMenuCommand option from the drop-down list
6 - Select the WindowHide option from the Command box.
Explanation:
1.Click on the Create tab.
2.Click the Macro button in the Macros & Code group.
3.Click the Show All Actions button in the Show/Hide group on the Design tab.
4.Select the RunMenuCommand option from the drop-down list.
5.Select the WindowHide option from the Command box.
James works as a Database Designer for Tech Perfect Inc. He wants to prevent the Navigation Pane from appearing by default in Microsoft Office Access 2010. Which of the following steps will James take to find the option for this task?
- A. Create > Options > Templates
- B. New > Options > Current database
- C. Home > View > Options
- D. Database Tools > Options > Access Database
Correct Answer: B 🗳️
Explanation: Only visible for CertkingdomPDF members. You can sign-up / login (it's free).
You have a table named Products created in Microsoft Access 2010. You want to calculate the total price of all products. Choose and re-order the steps that you will take to add the Total row in the table.
Correct Answer:
1 - Open the table in the Datasheet view.
2 - Click the Home tab.
3 - Click the Totals button in the Records group.
4 - In the Total row, choose the Sum operation.
Explanation:
1.Open the table in the Datasheet view.
2.Click the Totals button in the Records group on the Home tab.
3.In the Total row, choose the operation required to perform.
Viewing page 1 out of 27 pages.
Viewing questions 1-5 out of 135 questions.
Ada 
Mabel 
Burke 
Bess 
Mark 
Dunn 
Maxine 
Reginald 
Georgia 
Quennel 
Vita 
Quintion 
Chester 
Patrick 
Natividad 
Christian 
Christ 
Derrick 
