Home > Articles > Microsoft

  • Print
  • + Share This
Exam Objectives

Exam Objectives

The objectives for this exam, as stated by Microsoft include:

Managing the Access Environment

  • Create and manage a database.
  • This objective may include but is not limited to: using Save Object As, Open, Save and Publish, Compact & Repair Database, and Encrypt with Password commands, creating a database from a template, and setting Access options

  • Configure the Navigation Pane.
  • This objective may include but is not limited to: renaming objects, deleting objects, and setting Navigation options

  • Apply Application Parts.
  • This objective may include but is not limited to: using Blank Forms, Quick Start, and user templates

Building Tables

  • Create tables.
  • This objective may include but is not limited to: creating tables in Design View

  • Create and modify fields.
  • This objective may include but is not limited to: inserting a field, deleting a field, renaming a field, Hide or Unhide fields, Freeze or Unfreeze fields, modifying data types, modifying the field description, and modifying field properties

  • Sort and filter records.
  • This objective may include but is not limited to: using Find, Sort, and Filter commands

  • Set relationships.
  • This objective may include but is not limited to: defining Primary Keys, using Primary Keys to create Relationships, and editing Relationships

  • Import data from a single data file.
  • This objective may include but is not limited to: importing source data into a new table, appending records to an existing table, and importing data as a linked table

Building Forms

  • Create forms.
  • This objective may include but is not limited to: using the Form Wizard, creating a Blank Form, using Form Design Tools, and creating Navigation forms

  • Apply Form Design Tab options.
  • This objective may include but is not limited to: using the Themes, Controls, Header/Footer, and Tools groups

  • Apply Form Arrange Tab options.
  • This objective may include but is not limited to: using the Table, Move, and Position groups

  • Apply Form Format Tab options.
  • This objective may include but is not limited to: using the Background and Control Formatting groups

Creating and Managing Queries

  • Construct queries.
  • This objective may include but is not limited to: using Select, Make Table, Append, and Crosstab query types

  • Manage source tables and relationships.
  • This objective may include but is not limited to: using the Show Table and Remove Table commands, and creating ad hoc relationships

  • Manipulate fields.
  • This objective may include but is not limited to: adding, removing, and rearranging fields, and using Sort and Show options

  • Calculate totals.
  • This objective may include but is not limited to: using the Total row and using Group By

  • Generate calculated fields.
  • This objective may include but is not limited to: performing calculations, using the Zoom box, and using Expression Builder

Designing Reports

  • Create reports.
  • This objective may include but is not limited to: creating a Blank Report, using Report Design Tools, and using the Report Wizard

  • Apply Report Design Tab options.
  • This objective may include but is not limited to: using the Themes, Grouping & Totals, Controls, Header/Footer, and Tools groups

  • Apply Report Arrange Tab options.
  • This objective may include but is not limited to: using the Table, Move, Position, and Sizing & Ordering groups

  • Apply Report Format Tab options.
  • This objective may include but is not limited to: adding color, background images, and conditional formatting

  • Apply Report Page Setup Tab options.
  • This objective may include, but is not limited to: using the Page Size andPage Layout groups

  • Sort and filter records for reporting.
  • This objective may include but is not limited to: using the Find, Sort, and Filter commands, and using view types

Where to Go from Here

Those candidates who successfully pass exam 77-885 qualify for the Microsoft Office Specialist (MOS): Access 2010 certification. Although this exam does not count as credit toward any additional Microsoft certifications, candidates who pass this exam typically end up taking one or more of the other Microsoft Office exams as a way of proving their expertise with the Microsoft Office 2010 suite as a whole.

Microsoft offers a variety of exams based on Microsoft Office 2010. Most of the available exams have about the same degree of difficulty as the 77-885 exam, but Microsoft does offer expert level exams for Word and Excel 2010. The exams that Microsoft offers for Office 2010 certifications include:

  • MOS: Microsoft Office Word 2010[md]Exam 77-881
  • MOS: Microsoft Office Word 2010 Expert[md]Exam 77-887
  • MOS: Microsoft Office Excel 2010[md]Exam 77-882
  • MOS: Microsoft Office Excel 2010 Expert[md]Exam 77-888
  • MOS: Microsoft Office PowerPoint 2010[md]Exam 77-883
  • MOS: Microsoft Office Outlook 2010[md]Exam 77-884
  • MOS: Microsoft Office Access 2010[md]Exam 77-885
  • MOS: Microsoft SharePoint 2010 [md]Exam 77-886
  • MOS: Microsoft Office OneNote 2010[md]Exam 77-853 (still under development)

You can find information about these exams at: http://www.microsoft.com/learning/en/us/certification/mos.aspx#certifications

  • + Share This
  • 🔖 Save To Your Account

Related Resources

There are currently no related titles. Please check back later.