Microsoft MS Access 2010 : 77-885

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

PDF Version

PC Test Engine

Online Test Engine

Total Price: $59.98

About Microsoft 77-885 Exam Cram

Good questions teach; verified answers anchor. The 135 practice questions Test4Cram maintains for Microsoft MS Access 2010 give 77-885 candidates both.

Microsoft 77-885 Exam Overview:
Certification Vendor:Microsoft
Exam Name:Microsoft Access 2010
Exam Number:77-885
Exam Price:USD $90–$115
Exam Duration:50 minutes
Passing Score:700 / 1000
Real Exam Qty:40-45 performance-based tasks
Available Languages:Spanish, Italian, Chinese Simplified, German, English, French, Korean, Russian, Japanese, Portuguese
Related Certifications:MOS: Access 2016
MOS: Office 2010
MOS: Access 2013
Exam Format:Hands-on simulation, Project-based, Performance-based
Certificate Validity Period:Lifetime (no expiration)
Recommended Training:Microsoft Access 2010 Training Resources
Microsoft Official Academic Course (MOAC) Access 2010
Exam Registration:Certiport (retired)
Sample Questions:Free Download 77-885 Test Exam Cram
Exam Way:Proctored on-site at Certiport authorized testing centers; retired, no longer available for registration
Pre Condition:No formal prerequisites; recommended working knowledge of Access 2010
Official Syllabus URL:https://learn.microsoft.com/en-us/previous-versions/office/mos-2010/77-885
Microsoft 77-885 Exam Syllabus Topics:
SectionWeightObjectives
Creating Forms20%- Modify form controls and layout
- Apply formatting and themes
- Create forms using tools and wizards
- Add navigation and subforms
Creating Queries25%- Create basic and parameter queries
- Modify query design and criteria
- Create calculated fields and totals
- Create action and join queries
Creating Reports15%- Format and modify report layout
- Create reports with wizards and design view
- Group, sort, and summarize data
- Print and export reports
Managing the Access Environment15%- Apply application parts and templates
- Create and manage databases
  • 1. Use templates
    • 2. Compact and repair databases
      • 3. Configure database properties
        - Configure navigation pane
        Building Tables25%- Sort, filter, and validate records
        - Import and export data
        - Manage table relationships and keys
        - Create tables
        • 1. Set field properties
          • 2. Define fields and data types

            Microsoft 77-885 Exam — Asked and Answered

            Think of the 77-885 exam as Microsoft asking for proof, not promises: pass it, and you hold the Microsoft Office Specialist (MOS): Access 2010 certification, a credential at the Core / Specialist level. The questions are built to measure applied skill across the Microsoft MS Access 2010 objectives — the kind employers hire for. It also sits within a broader certification family covering MOS: Office 2010, MOS: Access 2013, MOS: Access 2016, so one exam's effort keeps paying into the next.

            The same 135 expert-written questions ship in all three — you're choosing how you want to live with the material:

            • PDF version — the most popular choice: printable, instantly downloadable, ready for handwritten notes anywhere.
            • Desktop Test Engine — for Windows users: recreates the real exam atmosphere with two practice modes and full offline access.
            • Online Test Engine — app-like access from any browser on Windows, Mac, Android, or iOS, with test history and performance review.

            Each version has its own strengths; many candidates mix them — PDF for reading, an engine for timed rehearsal.

            The figures in the overview table above turn into strategy once you treat them as a budget: total time divided by total questions is your per-item allowance, and anything costing double gets flagged for a final sweep instead of a mid-exam standoff. Build the habit under a live timer — Test4Cram's engine sessions enforce one — so the real clock feels like a rehearsal, not a surprise.

            The fee shown above is the price of one attempt — and of every retake, at full price. So the passing score is best treated as a floor you clear with margin: work through Test4Cram practice questions until your timed results sit comfortably above it several sessions in a row, then register. Hours of over-preparation are cheaper than a second registration.

            First-line service, around the clock: free online consultation whenever a question stalls you, remote guidance for installation or usage issues, and clear answers to content questions by email. On privacy, the rules are rigid — transactions are secured by McAfee security services, purchase information is never disclosed to third parties, and no spam or telemarketing follows your order.

            Work in passes, not one grind. First pass: untimed, through all 135 questions, marking weak domains against the blueprint above. Second pass: timed engine sessions, reviewing every error the same day while the reasoning is fresh. Final pass: re-test only your flagged items until they stop being wrong. Book the exam when your timed scores hold steady — not when your calendar gets impatient.

            Yes. Test4Cram's free Microsoft MS Access 2010 PDF demo contains genuine sample questions with verified answers, so you can judge the quality with your own eyes. Every purchase includes 365 days of free updates, and renewing after expiry costs 50% of the regular price from your member zone. Judge first — material this confident has nothing to hide.

            Delivery first: your Microsoft MS Access 2010 practice questions are downloadable immediately and emailed within one minute of payment — if 2 hours pass, check spam and contact support. Install on as many computers as you need. If the exam goes wrong, the 100% Money Back Guarantee applies under clear conditions: take the corresponding exam within 60 days of purchase, and if you don't pass, submit a scanned enrollment slip and your official Score Report PDF within 2 days after the exam — full refunds process within 7 days. Not eligible: attempts within 3 days of purchase, exams never actually taken, free items, and expired orders; candidate name must match payer name. Prefer to keep going? Exchange for two free products of equal value and keep your update service.

            The blueprint above spans 5 domains — treat its weightings as a budget. A domain worth 25% of the score earns a matching share of your week, while lighter areas like Creating Reports get maintained, not marathoned. Walk the full topic list domain by domain, and let the percentages decide where your practice hours land first.

            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. Backstage view
            • B. Design view
            • C. PivotTable view
            • D. PivotChart view
            Reveal Solution  Discussion  0

            Correct Answer: A  🗳️

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

            Question #2

            Which of the following parts of the Access Window provides a command interface by consolidating all tasks or entry points in one place?

            • A. Navigation Pane
            • B. View selector
            • C. Tabbed document
            • D. Ribbon
            Reveal Solution  Discussion  0

            Correct Answer: D  🗳️

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

            Question #3

            Fill in the blank with the appropriate Access tool name.
            The has a set of commands or functions (save, undo/redo, and print) that are independent of the tab on the ribbon currently displayed in MS Access.

            • A. Quick Access Toolbar
            Reveal Solution  Discussion  0

            Correct Answer: A  🗳️

            Question #4

            You have a datasheet named Datasheet1 created in Microsoft Office Access 2010. You need to calculate the sum, average, and count for data. This data is grouped by two types of information, one down the left side of the datasheet and another across the top of the datasheet. You want to display the results of the query's calculation in the cell at the junction of each row and column. Which of the following types of Query wizard will you use to accomplish the task?

            • A. Crosstab
            • B. Find Duplicates
            • C. Find Unmatched
            • D. Simple
            Reveal Solution  Discussion  0

            Correct Answer: A  🗳️

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

            Question #5

            You are working on a home computer with Microsoft Office 2010 installed on it. You want to always open Microsoft Office Access 2010 with the database that you used the last time. Which of the following Access options will you choose to accomplish the task?

            • A. Client Settings
            • B. Quick Access Toolbar
            • C. Current Database
            • D. Object Designers
            Reveal Solution  Discussion  0

            Correct Answer: A  🗳️

            Explanation: Only visible for Test4Cram 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%

            What Clients Say About Us

            The 77-885 exam questions are up to date and the best. They are easy to be downloaded and worked well for me. I passed my 77-885 exam only for them. Thanks!

            Jared Jared       4 star  

            I found Test4Cram material very comprehensive, effective and easy to understand. I did not use anyone material as I did not feel of any need of other materials. Test4Cram was the right choice for me!

            Timothy Timothy       5 star  

            I passed 77-885 exam with your help.

            Marcus Marcus       4 star  

            I passed 77-885 exam! Your 77-885 dumps are the real questions.

            Chad Chad       4 star  

            I bought five exam materias at one time and the pass rates are said to be 100%. I successfully passed the 77-885 exam today. I have confidence to pass the rest. Many thanks!

            Selena Selena       4.5 star  

            There are some wrong answers, but still helped me passed 77-885 exam. You can trust it.

            Kerr Kerr       4.5 star  

            It didn’t cost much but help me a lot especially for the key points. Very accurate! Buy the 77-885 training dumps and you will pass too!

            Amanda Amanda       4 star  

            The 77-885 exam questions are very good questions, though i found there were a few questions that i can't understand but definately a great aid toward passing with confidence. I just remembered the questions and answers together to pass the 77-885 exam. Thanks!

            Jeff Jeff       4.5 star  

            I am just going through some 77-885 dumps….you know what? they are very ideal for exam prep.

            Tony Tony       5 star  

            Today, i present my 77-885 exam, i bought the 77-885 training questions and my score is 97%. Thanks, Test4Cram!

            Norton Norton       4 star  

            I bought the pdf version of 77-885 exam materials, I was confident to write the 77-885 exam and passed it. Truly great study materials to refer to!

            Anna Anna       5 star  

            Your 77-885 questions are all covered in the actual exam.

            Sebastian Sebastian       4.5 star  

            I would recommend Test4Cram for your 77-885 exam prep study guides and practice tests. My experience with them has been wonderful. I passed highly.

            Nicholas Nicholas       5 star  

            LEAVE A REPLY

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

            Quality and Value

            Test4Cram 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.

            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.

            Easy to Pass

            If you prepare for the exams using our Test4Cram 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.

            Try Before Buy

            Test4Cram 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.