About this Course

This certification course provides a complete training solution to fully prepare delegates 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.

Target Audience

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)

Learn from the UK's leading Microsoft training provider

  • Comprehensive curriculum

    We deliver over 20,000 Microsoft training courses in the UK each year

  • Experienced experts

    Our first-class learning specialists all have a minimum of 5 years training experience

  • Superb satisfaction scores

    99% of our delegates are satisfied with their Microsoft course

  • Trusted training

    We are the largest Microsoft Gold Learning Partner in the UK

  • Microsoft Partner Gold Learning

Why people choose QA


There are over 20 QA learning centres and many other sites spread across the UK, providing a convenient choice of learning locations and ensuring that over 90% of the population is within 45 minutes of a training destination. Learn more

  • London


    International House

  • Manchester


    Oxford Street

Delegate portal

Booking courses with QA has always been easy, but now we've made it even easier. With myQA you can book, administer and manage all your bookings online, in one place. Login / sign-up

Detailed Information

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

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.

Microsoft Certifications

Take the next step in your career by achieving certification in Microsoft Technologies.

Microsoft Azure
Microsoft Azure

Master Azure with QA, the 2015 Microsoft Worldwide Learning Partner of the Year.

Windows Server
Windows Server 2016

Learn to efficiently manage corporate IT infrastructures with Windows Server 2016.

MOC on Demand

Delivers Microsoft Official Curriculum (MOC) courses online straight to your device.