Microsoft 77-885 Exam : MS Access 2010

  • Exam Code: 77-885
  • Exam Name: MS Access 2010
  • Updated: Nov 17, 2026
  • Q & A: 135 Questions and Answers

Already choose to buy: "PDF"

Total Price: $59.99  

About Microsoft 77-885 Exam Questions

Choosing where to prepare for the 77-885 exam is easier when you can test the tools first. DumpsActual offers a free demo of the Microsoft MS Access 2010 materials, including a look at the online engine that tracks your weak spots — 135+ Q&As are waiting once you are satisfied.

Microsoft 77-885 Exam Overview:

Certification Vendor:Microsoft
Exam Name:MOS: Microsoft Access 2010
Exam Number:77-885
Passing Score:700
Available Languages:Japanese, Korean, Portuguese (Brazil), Spanish, Russian, English, Italian, Chinese (Traditional), German, French, Chinese (Simplified)
Real Exam Qty:Performance-based tasks
Exam Duration:50 minutes
Related Certifications:Microsoft Office Specialist Expert 2010
Microsoft Office Specialist (MOS) 2010
Microsoft Office Master 2010
Exam Price:USD 100
Certificate Validity Period:Does not expire
Exam Format:Live Application Tasks, Performance-Based
Sample Questions:Free Download real 77-885 actual tests
Exam Way:Delivered through Certiport authorized testing centers using a live Microsoft Access 2010 environment.
Pre Condition:No prerequisite exams required.
Official Syllabus URL:https://learn.microsoft.com/en-us/credentials/certifications/mos-access-2010/

Microsoft 77-885 Exam Syllabus Topics:

SectionWeightObjectives
Topic 1: Create Forms20%- Design and Format Forms
  • 1. Create forms
  • 2. Create navigation forms
  • 3. Modify form controls
  • 4. Apply formatting
Topic 2: Create Queries20%- Build and Modify Queries
  • 1. Run action queries
  • 2. Create select queries
  • 3. Create calculated fields
  • 4. Apply query criteria
Topic 3: Create Reports20%- Design and Format Reports
  • 1. Create reports
  • 2. Add calculated controls
  • 3. Group and sort data
  • 4. Format and print reports
Topic 4: Build Tables25%- Create and Modify Tables
  • 1. Create relationships
  • 2. Create tables
  • 3. Create primary keys
  • 4. Define field properties
  • 5. Import and export data
Topic 5: Manage the Access Environment15%- Create and Manage Databases
  • 1. Compact and repair databases
  • 2. Create a database
  • 3. Navigate database objects
  • 4. Print database objects

77-885 Exam Questions Answered: Format, Topics, and Prep

The 77-885 exam is the official assessment for the Microsoft MS Access 2010 certification offered by Microsoft. It checks whether you can apply the knowledge areas in the exam objectives to practical situations, and passing it earns a credential that employers across the industry recognize. For professionals who feel stuck in their current role, it is often the most concrete next step available.

The official outline for the 77-885 exam highlights these domains:

  • Create Reports (20%)
  • Create Forms (20%)
  • Create Queries (20%)

Weighting your study time toward the heavier domains first is a sensible strategy, and the Microsoft MS Access 2010 practice questions at DumpsActual follow the same objective structure.

The 77-885 exam gives you 50 minutes minutes to answer Performance-based tasks questions. That pace leaves little room for hesitation, which is why rehearsing under a timer — for example with the online test engine at DumpsActual, where you can set the session length just like the real test — is such a useful habit.

The online test engine is exclusive to DumpsActual and runs on any electronic device — phone, tablet, or computer — with no installation barriers. It recreates the atmosphere of the real 77-885 exam: you set the test time the way it will be on exam day, work through the Microsoft MS Access 2010 practice questions under that pressure, and at the end the engine marks the questions you got wrong and reminds you to practice them again next time. Over a few sessions, that loop turns weak areas into reliable ones.

To pass the 77-885 exam you need a score of 700, and the registration fee is USD 100. Since each attempt costs the full fee, arriving over-prepared is cheaper than arriving under-prepared — timed mock sessions and repeated review of missed questions are the usual ways candidates close that gap.

Right after payment you get instant access to the 77-885 exam product — 135 practice questions for the Microsoft MS Access 2010 exam with expert-verified answers — and the download link is also emailed to you automatically, typically within a minute. Your purchase includes 365 days of free updates; our team checks for exam changes daily, and when a new version is released the system sends it straight to your mailbox. A 50% renewal discount applies if you extend updates beyond the first year, and payment by Credit Card is handled through a secure checkout.

Microsoft MS Access 2010 Sample Questions:

Question #1

In which of the following views does the program window open when a user starts Microsoft Office Access 2010 without opening a database?

  • A. PivotTable view
  • B. Backstage view
  • C. Design view
  • D. PivotChart view
Reveal Solution  Discussion  0

Correct Answer: B  🗳️

Explanation: Only visible for DumpsActual members. You can sign-up / login (it's free).

Question #2

Which of the following datatypes is used to attach Microsoft Office files, graphics files, sound files, and pdf files to a table?

  • A. Memo
  • B. OLE object
  • C. Hyperlink
  • D. Text
Reveal Solution  Discussion  0

Correct Answer: B  🗳️

Explanation: Only visible for DumpsActual members. You can sign-up / login (it's free).

Question #3

You have created a table named Books in Microsoft Office Access 2010. You have created a new field to enter the Book ID. For this purpose, you need to set the Number datatype for the field. Which of the following actions will you perform to accomplish the task?
Each correct answer represents a complete solution. Choose all that apply.

  • A. Right-click the Field Header and choose the Number datatype.
  • B. Choose the Number datatype from the Formatting group.
  • C. Simply insert a number in the field.
  • D. Right-click the field and choose the Number datatype.
Reveal Solution  Discussion  0

Correct Answer: B,C  🗳️

Explanation: Only visible for DumpsActual members. You can sign-up / login (it's free).

Question #4

Where can a user add any Access command as a button in Microsoft Access 2010?

  • A. Macro
  • B. Quick Access Toolbar
  • C. Navigation Pane
  • D. Index
Reveal Solution  Discussion  0

Correct Answer: B  🗳️

Explanation: Only visible for DumpsActual members. You can sign-up / login (it's free).

Question #5

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 Sales created in Microsoft Office Access 2010. The database contains detailed information about thousands of orders. You want to summarize these orders to illustrate the rate of growth of the company's sales. Which of the following database objects will you generate to accomplish the task?

  • A. Query
  • B. Macro
  • C. Module
  • D. Report
Reveal Solution  Discussion  0

Correct Answer: D  🗳️

Explanation: Only visible for DumpsActual members. You can sign-up / login (it's free).

Viewing page 1 out of 27 pages.
Viewing questions 1-5 out of 135 questions.

4%

1202 Customer ReviewsCustomers Feedback (* Some similar or old comments have been hidden.)

Keep doing good work.My friend recommends me DumpsActual Real 77-885 exam.

Moore

Moore     4.5 star  

77-885 exam is accelerating the success rate of every student each day with asking for much of your efforts.

Matt

Matt     4.5 star  

DumpsActual made 77-885 exam extremely easy for me.

Duncan

Duncan     4 star  

I am very lucky. I pass the exam. Since the subject is difficult with high failure rate. thanks.

Malcolm

Malcolm     4.5 star  

This 77-885 study dumps is latest and valid. I have won my certificate already for your help. It is the best 77-885 exam files I do think.

Eden

Eden     4.5 star  

Sample exams help a lot to prepare for the 77-885 certification exam. I could only spare 3 hours a day to study and manage my professional career. DumpsActual helped me pass the exam with flying colours.

Jane

Jane     4.5 star  

Valid 77-885 certification practice exam questions! Valid as always! I am a loyal buyer.

Shirley

Shirley     5 star  

I have bought it and prepare it and passed it without any issue. Thanks a lot DumpsActual

King

King     5 star  

I passed 77-885 exam with score 96% today.

Dwight

Dwight     4 star  

I have recently done a very good job and passed with the 77-885 exam questions. Just after clearing my certification, the unlimited calls for interviews were knocking at my door. Good future is waiting for me!

Stev

Stev     4.5 star  

I passed the 77-885 exam by only studying the 77-885 exam materials for about one week, really appreciate!

Elroy

Elroy     4 star  

I didn't expect the 77-885 practice dumps could be so accurate until i finished the exam. Pass the 77-885 exam today and get a nice score. Valid 77-885 practice dump!

Toby

Toby     4 star  

I took the 77-885 exam just hours before and finished with a perfect score. I had only an hour or so a day to prepare for my 77-885 certification exam.

Andrew

Andrew     5 star  

I bought the DumpsActual material and started the revision for my course. I was feeling much confident about my preparation and that thing proved when I sat in the exam and attempted all the questions easily and passed the 77-885 exam. Thanks DumpsActual.

Basil

Basil     5 star  

Great, i passed 77-885 exam at last Friday. You can rely on thest valid 77-885 exam questions. They are really something great!

Eugene

Eugene     5 star  

Excellent exam testing software by DumpsActual for 77-885 exam. Studied for 3 days and gave the exam. Helped me a lot. Suggested to everyone taking this exam.

Gail

Gail     5 star  

I owe a lot to you DumpsActual!
Unique and Reliable Content!

Michelle

Michelle     4 star  

I bought the 77-885 online test engine, and I can have a general review before I start to practice, and I like this mode because it help me consolidate my knowledge.

Andy

Andy     4 star  

LEAVE A REPLY

Your email address will not be published. Required fields are marked *

QUALITY AND VALUE

DumpsActual Practice Exams are written to the highest standards of technical accuracy, using only certified subject matter experts and published authors for development - no all study materials.

EASY TO PASS

If you prepare for the exams using our DumpsActual testing engine, It is easy to succeed for all certifications in the first attempt. You don't have to deal with all dumps or any free torrent / rapidshare all stuff.

TESTED AND APPROVED

We are committed to the process of vendor and third party approvals. We believe professionals and executives alike deserve the confidence of quality coverage these authorizations provide.

TRY BEFORE BUY

DumpsActual offers free demo of each product. You can check out the interface, question quality and usability of our practice exams before you decide to buy.