Exam 77-885: Access 2010

The Access 2010 (77-885) examination is designed with the aim to assess candidates’ hands-on skills using Microsoft Office. It is a technical specialist examination. It measures the ability of the candidate to accomplish the technical tasks. Furthermore, it will help you develop relevant skills and knowledge to achieve greater heights in your career. To add on, it will be an amazing addition in resume.

Target Audience

It is best suitable for user support professional, trainer, teacher, professor, database user, or database creator who needs to create or maintain a basic Access database.

Skills Acquired

After successful completion of this certification, Users can create, modify, and extend the functionality of basic database objects, including tables, queries, forms, and reports. Users can also construct and modify basic relationships among database entities and can instruct others in basic Access functionality and usage. The Access 2010 user typically is effective in creating, modifying, and personalizing objects. Furthermore, the candidate is capable of working independently on database projects, and can often answer questions from others about databases. However, candidates should know and demonstrate how to create or modify a simple Access database and use templates to create basic objects.

Exam Pattern

	Exam time*	Seat time*
Fundamental exams delivered by Certiport	45 minutes	50 minutes
Fundamental exams delivered by Pearson VUE	45 minutes	75 minutes
Dynamics 365 exams	120 minutes	150 minutes
All other job role-based exams	150 minutes	180 minutes
MCSA exaMS	120 minutes	150 minutes
MCSE exams	150 minutes	180 minutes

Exam Details

The Access 2010 (77-885) examination consists primarily of multiple-choice questions, but you might also encounter build a tree, reorder, or simulation questions. Furthermore, the cost of the examination is $100 and you need to get at least a score of  700/1000 to clear the examination. You are approximately given 90 minutes to complete the examination but Microsoft does not disclose the exam’s time limit. Furthermore, it is available in Chinese (Simplified), Chinese (Traditional), Spanish, Japanese languages only.

Exam Registration

For Registering yourself for the Access 2010 (77-885) examination, follow the following steps:

• Go to the official website and click on the schedule now option.
• You will be redirected to the Certiport registration page.
• Follow the steps and complete your registration.
• Furthermore, you will be receiving a confirmation mail once you have made your payment.

Exam Policies

The candidate is recommended to read these policies so as to avoid any kind of confusion in the future.These policies contain information about registration options, learning credits, etc.

Exam Retake Policy

If the candidate failed to achieve the passing score, then he/she has to wait for 24 hours before reapplying to the examination. The candidate can go to their certificate dashboard and reschedule the exam themselves. The candidate can reappear for the examination only five times. Failure in the second attempt will result in a waiting time of 14 days before rescheduling your third attempt. The waiting period for the fourth and the fifth attempts will also be 14 days. 

Exam Cancellation Policy

Microsoft offers candidates to cancel or reschedule their exams within a minimum of 24 hours prior to the exam date. However, to prevent any cancellation fee, you must cancel or reschedule your exam, at least 6 business days prior to the date scheduled for your exam. Also, if you fail to appear in the exam, then you will not receive any refund of the exam fee.

Recertification Policy

Microsoft certification is expected to expire when the products are out of mainstream support although the person`s certification will be recognized. Officially, the certification will never expire.

You can read the full policies on the official website of Microsoft.

For more information, click on Access 2010 (77-885) FAQ.

Course Outline

Manage the Access environment

• Create and manage a database
  • use Save Object As, Open, Save and Publish Compact and Repair Database, and Encryptnwith Password commands, create a database from a template, and set Access options.

• Configure the Navigation pane
  • rename objects, delete objects and set Navigation options

• Apply Application Parts
  • use Blank Forms, Quick Start, and user templates

Build tables

• Create tables
  • tables in Design view

• Create and modify fields
  • insert a field, delete a field, rename a field, Hide or Unhide fields, Freeze or Unfreeze fields, modify data types, modify the field description, and modify field properties

• Sort and filter records
  • use Find, Sort, and Filter commands

• Set relationships
  • define Primary Keys, use Primary Keys to create Relationships, and edit Relationships

• Enter and format text
  • use text effects; change the indentation, alignment, line spacing, and direction of text; change the formatting of bulleted and numbered lists; enter text in a placeholder text box; convert text to SmartArt; copy and paste text; use Paste Special, and use Format Painter.

• Import data from a single data file
  • import source data into a new table, append records to an existing table, and import data as a linked table.

Build forms

• Create forms
  • use the Form Wizard, create a blank form, use Form Design tools, and create Navigation forms.
• Apply Form Design Tab options
  • use the Themes, Controls, Header/Footer, and Tools groups

• Apply Form Arrange Tab options
  • use the Table, Move, and Position groups

• Apply Form Format Tab options
  • use the Background and Control Formatting groups

Create and manage queries

• Construct queries
  • use Select, Make Table, Append, and Crosstab query types

• Manage source tables and relationships
  • use the Show Table and Remove Table commands, and create ad hoc relationships

• Manipulate fields
  • add, remove, and rearrange fields, and use Sort and Show options

• Calculate totals
  • use the Total row, and use Group By

• Generate calculated fields
  • perform calculations, use the Zoom box, and use Expression Builder

Design reports

• Create reports
  • create a blank report, use Report Design tools, and use the Report Wizard

• Apply Report Design Tab options
  • use the Themes, Grouping & Totals, Controls, Header/Footer, and Tools groups
• Apply Report Arrange Tab options
  • use the Table, Move, Position, and Sizing & Ordering groups
• Apply Report Format Tab options
  • add color, background images, and conditional formatting
• Apply Report Page Setup Tab option
  • using the Page Size and Page Layout groups
• Sort and filter records for reporting
  • use the Find, Sort, and Filter commands, and use view types

Preparatory Guide for Access 2010 (77-885)

To help you in your preparation, we have prepared a guide which you can refer. Furthermore, following this preparation guide will help you learn and understand every exam’s objectives. Here we are providing you with the best learning resources to qualify for the exam. Moreover, here we are going to illustrate a detailed description to help you prepare for the exam. Let’s start with expert learning resources and a study guide.

Refer the Exam Guide

It is important to know the topics beforehand. Significantly, this is the most important step in the preparation guide. Furthermore, exam objectives are very important when it comes to preparing the exam strategy. So, let’s take a quick look:

• Manage the Access environment
• Build tables
• Build forms
• Create and manage queries
• Design reports

Microsoft Books

Microsoft provides reference books that can be helpful while studying for the exam. Furthermore, these books contain various useful resources that can be used while studying. Visit Microsoft Press books, to find relevant books to get a deeper insight into the exam objectives, and hence crack the test, and earn your certification. You can also buy these books from Amazon. These books will help you prepare for the examination in a structural way.

• Exam 77–885 Microsoft Access 2010 (Microsoft Official Academic Course) by Microsoft Official Academic Course

Join Microsoft Community

A healthy discussion is always beneficial, no matter where it is done. The prospects of getting resolutions to an issue increase steeply when a greater number of people are involved. These discussions make the studies more comprehensive. Forums work really well to build a community that is essential for understanding others. Interacting with people with the same goal puts you one step forward in achieving those goals. Furthermore, it is suggested that you should join Microsoft Community.

Evaluate yourself with Practice Test

It is very important to practice what you have learned so that you are in a position to analyze your practice. Furthermore, by practicing you will be able to improve your answering skills that will result in saving a lot of time. Moreover, the best way to start doing practice tests is after completing one full topic. It will work as a revision part for you. Furthermore, practicing you will be able to improve your answering skills that will result in saving a lot of time. Moreover, the best way to start doing practice tests is after completing one full topic as this will work as a revision part for you. Moreover, the best way to start doing practice tests is after completing one full topic. Furthermore, it will work as a revision part for you. Start practicing now!