Microsoft 77-885 : MS Access 2010

Pass 77-885 Exam Cram

Exam Code: 77-885

Exam Name: MS Access 2010

Updated: Oct 26, 2026

Q & A: 135 Questions and Answers

Already choose to buy "PDF"
Price: $59.99 

High quality 77-885 guarantee you to pass 77-885

Print it if you prefer paper. The 77-885 PDF from Pass4cram supports printing to meet different study habits, while the same expert-verified Microsoft MS Access 2010 content stays available across your devices in 2026.

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
Available Languages:German, Spanish, French, Japanese, Chinese (Simplified and Traditional), English
Real Exam Qty:Approximately 20–50 performance-based tasks
Related Certifications:Microsoft Office Specialist (MOS) Master
Microsoft Access Expert
Passing Score:700 (scaled score out of 1000)
Exam Duration:50 minutes
Certificate Validity Period:Does not expire (historically perpetual MOS certification)
Exam Price:Approximately 100–150 USD (varies by region)
Recommended Training:Microsoft Learn (MOS training resources)
Exam Registration:Microsoft Certification Portal
Sample Questions:Free Download Pass 77-885 Exam Cram
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:
SectionObjectives
Topic 1: Create tables- Define table structure
  • 1. Create primary keys
    • 2. Set field properties and data types
      - Modify tables
      • 1. Edit fields and records
        • 2. Set relationships between tables
          Topic 2: Create forms- Design forms
          • 1. Customize form layout and controls
            • 2. Create forms using wizards
              - Use form controls
              • 1. Add input controls
                • 2. Modify form properties
                  Topic 3: Create and manage databases- Create a new database structure
                  • 1. Import or link data
                    • 2. Create and save a database
                      - Manage database objects
                      • 1. Organize database components
                        • 2. Open, close, and navigate objects
                          Topic 4: Manage macros and basic automation- Run and manage macros
                          • 1. Assign macros to controls
                            - Create macros
                            • 1. Automate common tasks
                              Topic 5: Create reports- Build reports
                              • 1. Format report layout
                                • 2. Create reports using wizards
                                  - Enhance reports
                                  • 1. Apply calculations and summaries
                                    • 2. Add grouping and sorting
                                      Topic 6: Create queries- Build query structures
                                      • 1. Filter and sort data
                                        • 2. Create select queries
                                          - Advanced query operations
                                          • 1. Parameter queries
                                            • 2. Action queries (update, append, delete)

                                              The 77-885 Details You Actually Need

                                              Immediately and easily. Upon successful payment, our system sends the product file to your mailbox automatically — typically within about a minute — with an instant download link as well. If nothing arrives within two hours, check your spam folder and contact support. Installations are unlimited, the PDF supports printing for paper-based review, and your purchase includes 365 days of free updates: whenever the exam content changes, the latest version reaches you automatically, with a 50% renewal discount after the year ends.

                                              The Microsoft MS Access 2010 blueprint covers these principal domains:

                                              • Create reports
                                              • Manage macros and basic automation
                                              • Create queries

                                              The remaining domains appear in the full official outline, all of which our bank addresses.

                                              As of the latest information, the passing score for the 77-885 exam is 700 (scaled score out of 1000) and the fee is Approximately 100–150 USD (varies by region). Microsoft can revise both, so confirm the current figures on the official site before registering.

                                              Registration runs through the official channels below:

                                              Choose your center or online session, and reserve early for the most convenient dates.

                                              Documented and dependable. If you fail the corresponding exam within 60 days of purchase, email us a scanned copy of your enrollment slip and your official Score Report PDF within two days of the exam date; verified claims are refunded in full within seven days. Exclusions apply: exams taken within three days of purchase, candidate names that do not match the payer, and free or expired products. Alternatively, request a free exchange for two products of equal value.

                                              Microsoft recommends these official training options:

                                              Pick the course matching your experience, then reinforce it with regular question practice.

                                              Microsoft lists the following prerequisites for the Microsoft MS Access 2010: No formal prerequisites required, but familiarity with Microsoft Access 2010 is recommended.

                                              Confirm the details on the official certification page before you book.

                                              Per current exam information, the 77-885 exam includes Approximately 20–50 performance-based tasks questions and allows 50 minutes minutes. Timed practice beforehand makes the format feel routine on the day.

                                              Because every step respects your time. Buying is a simple, transparent procedure: choose your version or package, see the cost generated automatically, confirm, and order — then the materials arrive by email in about a minute. The 77-885 content is clear, the main points easy to acquire, and every answer expert-verified; the PDF prints for paper review. When the exam changes, our experts devote their energy to immediate research and revision, and critical comments trigger improvement measures as soon as possible. A free demo lets you run a mini-test and confirm quality first, and your personal information is protected on an integrity-based platform throughout.

                                              Microsoft MS Access 2010 Sample Questions:
                                              Question #1

                                              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 contains two databases named Shippers and Orders created in Microsoft Office Access 2010. A one-to-many relationship is created between both tables. You want to delete a Shipper. The shipper that you want to delete has orders in the Orders table. When you delete the Shipper record, these orders will become "orphans". The orders will still include a shipper ID, but this ID will not be valid. What will you do to prevent these orphans?

                                              • A. Cascade delete related records.
                                              • B. Enforce referential integrity.
                                              • C. Cascade update related fields.
                                              • D. Enforce domain integrity.
                                              Reveal Solution  Discussion  0

                                              Correct Answer: B  🗳️

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

                                              Question #2

                                              Choose the appropriate tasks that you can perform in the Design view of an Access form.

                                              Reveal Solution  Discussion  0

                                              Correct Answer:


                                              1 - Adjust the size of sections of design grid.
                                              2 - Apply a new theme to the form.
                                              3 - Modify the control's size.
                                              4 - Organize controls logically for assisting data entry.
                                              5 - Change the form elements' properties in the Property Sheet
                                              6 - Add fields from the Field List.
                                              7 - Add controls for limiting data entry selections.
                                              Explanation:
                                              Adjust the size of sections of design grid.
                                              Apply a new theme to the form.
                                              Modify the control's size.
                                              Organize controls logically for assisting data entry.
                                              Change the form elements' properties in the Property Sheet.
                                              Add fields from the Field List.
                                              Add controls for limiting data entry selections.

                                              Question #3

                                              You are working on a home computer with Microsoft Office 2010 installed on it. You have created a database named Database1 using Microsoft Access 2010. The database includes four database objects. You want to show and hide categories regardless of the settings in the Navigation Options dialog box. Which of the following objects will you use to accomplish the task?

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

                                              Correct Answer: C  🗳️

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

                                              Question #4

                                              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 ensure that the databases created in Microsoft Office Access 2010 save in the Microsoft Access 2003 format. Which of the following options will you choose in the Access Options dialog box to accomplish the task?

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

                                              Correct Answer: A  🗳️

                                              Explanation: Only visible for Pass4cram 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. Quick Access Toolbar
                                              • B. Object Designers
                                              • C. Current Database
                                              • D. Client Settings
                                              Reveal Solution  Discussion  0

                                              Correct Answer: D  🗳️

                                              Explanation: Only visible for Pass4cram 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%
                                              No help, Full refund!

                                              No help, Full refund!

                                              Pass4cram confidently stands behind all its offerings by giving Unconditional "No help, Full refund" Guarantee. Since the time our operations started we have never seen people report failure in the 77-885 exam after using our products. With this feedback we can assure you of the benefits that you will get from our products and the high probability of clearing the Microsoft 77-885 exam.

                                              We still understand the effort, time, and money you will invest in preparing for your certification exam, which makes failure in the 77-885 exam really painful and disappointing. Although we cannot reduce your pain and disappointment but we can certainly share with you the financial loss.

                                              This means that if due to any reason you are not able to pass theactual 77-885 exam even after using our product, we will reimburse the full amount you spent on our products. you just need to mail us your score report along with your account information to address listed below within 7 days after your unqualified certificate came out.

                                              What Clients Say About Us

                                              I bought two versions of 77-885 exam braindumps, the PDF and Online test engine, they assisted me pass the exam just one time, so exciting!

                                              Jim Jim       4 star  

                                              I took the 77-885 exam preparation course from you people few weeks back. I studied for few hours a day for 5 weeks period. The important thing is that I found your course very interesting and the best examples you have provided in the course always kept my concentration in the course.

                                              Larry Larry       4 star  

                                              Passed today with just a 85%, but a pass is a pass. If not for my general computer knowledge already I do not feel I would have passed. Appreciated!

                                              Rex Rex       5 star  

                                              I will recommend Pass4cram to other candidates.

                                              Brady Brady       4.5 star  

                                              All the credit of my success goes to 77-885 study material.

                                              Kim Kim       4.5 star  

                                              I have bought 77-885 exam materials and passed with the latest version. Big thanks!

                                              Sarah Sarah       4 star  

                                              I just knew that I passed the exam, and 77-885 exam materials helped me passed successfully. I have recommend Pass4cram to my friends.

                                              Mabel Mabel       4 star  

                                              Hello, my friends recommended 77-885 exam braindumps to me. Thanks to my friends and to Pass4cram!

                                              Suzanne Suzanne       4 star  

                                              The 77-885 study guide really helped me to study for the exam. I passed the exam on the first try using the guide. Thanks.

                                              Yedda Yedda       4.5 star  

                                              I just write to tell you that i passed the 77-885 exam with your help. I am really fond of you. You gays are so kind and considerate. Thank you so much!

                                              Bert Bert       5 star  

                                              I advise that you should buy dumps. It saves you much time and heart to play games and work. It is worthy this price.

                                              Tobias Tobias       5 star  

                                              Recently I passed the 77-885 exam and now just passed the 77-885 exam.

                                              Nancy Nancy       5 star  

                                              Wonderful 77-885 practice questons before exam! very useful for revising the key knowledge. Recommend to all of you!

                                              Camille Camille       5 star  

                                              Passed 77-885 exam today! Wonderful 77-885 exam study materials for sure! It is worthy to buy! Nice purchase!

                                              Olivia Olivia       4.5 star  

                                              Don't waste your time on finding other exam materials and just buy this 77-885 exam file! You can pass for sure. I just passed my 77-885 exam only with it as my study reference!

                                              Antoine Antoine       4.5 star  

                                              LEAVE A REPLY

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

                                              Why Choose Pass4cram

                                              Quality and Value

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

                                              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 Pass4cram 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

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

                                              Our Clients

                                              amazon
                                              centurylink
                                              earthlink
                                              marriot
                                              vodafone
                                              comcast
                                              bofa
                                              charter
                                              vodafone
                                              xfinity
                                              timewarner
                                              verizon