Microsoft Access 2007 Specialist

2 Day Course
Hands On
Official Microsoft Curriculum

Book Now - 1 Delivery Method Available:

Scheduled Virtual Onsite


This certification course provides a complete training solution to fully prepare students to achieve Microsoft Office Specialist (MOS) Microsoft Office Access 2007 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 2007. MOS exams are also available for Word, Excel, PowerPoint and Outlook 2007.

Included are:

  • 2-days Instructor Led Training using MOS Official Courseware
  • MOS Practice Exam Voucher
  • MOS Exam Voucher
  • Free Exam Re-take (where required)

Training Partners

We work with the following best of breed training partners using our bulk buying power to bring you a wider range of dates, locations and prices.


Hide all

Structuring a Database (4 topics)

  • Define data needs and types
  • Define and print table relationships
  • Add, set, change or remove primary keys
  • Split databases

Creating and Formatting Database Elements (7 topics)

  • Create databases
  • Create tables
  • Modify tables
  • Create fields and modify field properties
  • Create forms
  • Create reports
  • Modify the design of reports and forms

Entering and Modifying Data (5 topics)

  • Enter, edit and delete records
  • Navigate among records
  • Find and replace data
  • Attach documents to and detach from records
  • Import data

Creating and Modifying Queries (2 topics)

  • Create queries
  • Modify queries

Presenting and Sharing Data (6 topics)

  • Sort data
  • Filter data
  • Create and modify charts
  • Export data
  • Save database objects as other file types
  • Print database objects

Managing and Maintaining Databases (2 topics)

  • Perform routine database operations
  • Manage databases


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.

Additional Learning

The courses below may help you meet the knowledge level required to take this course. If you are unsure please ask a training advisor .

  • Access 2007 Level 1

    Examine the basic database concepts, and create and modify databases and their various objects with the Access 2007 Level 1 training course

    1 Day Course Hands On Training Course Code DAC07L1
    Scheduled Virtual Onsite
  • Access 2007 Level 2

    Maintain data consistency, customise database components, and share Access data with other applications on the Access 2007 Level 2 training course

    1 Day Course Hands On Training Course Code DAC07L2
    Scheduled Virtual Onsite
  • Access 2007 Level 3

    Access 2007 Level 3 is a 1-day training course providing delegates with the skills to create complex Access databases and perform database maintenance

    1 Day Course Hands On Training Course Code DAC07L3
    Scheduled Virtual Onsite

Course PDF


Share this Course


Recommend this Course