Microsoft Access 2007 Specialist

2 Day Course
Hands On
Official Microsoft Curriculum

This course has been retired. Please view currently available User Microsoft Office Training Courses.


Collapse 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.

Course PDF