Microsoft Access 2010 Specialist


This certification course provides a complete training solution to fully prepare students to achieve Microsoft Office Specialist (MOS) Microsoft Office Access 2010 accreditation. It concentrates on getting delegates from knowledgeable to ‘exam ready’ in a 2 day course. The course is aimed at delegates who already have the raw skills to take the exam, but wish to hone those skills and practice with assistance from an experienced MOS qualified instructor, prior to taking the exam.

Please note this is the only level of exam available for Microsoft Access 2010. MOS exams are also available for Word, Excel, PowerPoint and Outlook 2010.

Included are :

2-days Instructor Led Training using MOS Official Courseware

  • MOS Practice Exam Voucher
  • MOS Exam Voucher
  • Free Exam Re-take (where required)




This course has strict prerequisites – delegates should have already attended the relevant Levels 1, 2 and 3 courses or have equivalent knowledge. This course is NOT a fast track course for learning the exam material, but a course for turning knowledge in to exam readiness.


Course Outline


During the 2 day course you will cover the following topics to prepare you for exam 77-885: Using Microsoft Office Access 2010. During the course, you will have the opportunity to test your knowledge and complete a full practice exam before taking the final exam at the end of day two.

Managing the Access Environment

Create and manage a database

  • 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

  • Renaming objects, deleting objects, and setting Navigation options

Apply Application Parts

  • Using Blank Forms, Quick Start, and user templates

Building Tables

Create tables

  • Creating tables in Design View

Create and modify fields

  • 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

  • Using Find, Sort, and Filter commands

Set relationships

  • Defining Primary Keys, using Primary Keys to create Relationships, and editing Relationships

Import data from a single data file

  • Importing source data into a new table, appending records to an existing table, and importing data as a linked table

Building Forms

Create forms

  • Using the Form Wizard, creating a Blank Form, using Form Design Tools, and creating Navigation forms

Apply Form Design Tab options

  • Using the Themes, Controls, Header/Footer, and Tools groups

Apply Form Arrange Tab options

  • Using the Table, Move, and Position groups

Apply Form Format Tab options

  • Using the Background and Control Formatting groups

Creating and Managing Queries

Construct queries

  • Using Select, Make Table, Append, and Crosstab query types

Manage source tables and relationships

  • Using the Show Table and Remove Table commands, and creating ad hoc relationships

Manipulate fields

  • Adding, removing, and rearranging fields, and using Sort and Show options

Calculate totals

  • Using the Total row and using Group By

Generate calculated fields

  • Performing calculations, using the Zoom box, and using Expression Builder

Designing Reports

Create reports

  • Creating a Blank Report, using Report Design Tools, and using the Report Wizard

Apply Report Design Tab options

  • Using the Themes, Grouping & Totals, Controls, Header/Footer, and Tools groups

Apply Report Arrange Tab options

  • Using the Table, Move, Position, and Sizing & Ordering groups

Apply Report Format Tab options

  • Adding colour, background images, and conditional formatting

Apply Report Page Setup Tab options

  • Using the Page Size and Page Layout groups

Sort and filter records for reporting

  • Using the Find, Sort, and Filter commands, and using view types