• Technical IT

    Solutions delivered throughout the UK
  • Business Applications

    Solutions delivered throughout the UK
  • Professional Best Practice

    Solutions delivered throughout the UK
  • Professional Development

    Solutions delivered throughout the UK

Microsoft Access Specialist 2007

  • Price £410.00
  • Duration 2 day(s)
All major credit cards accepted


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.

This is a replacement course for the Access 2007 MCAS in a Box 2 day course (DACMCAS).

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.


See Course Content

Course Content

During the 2 day course you will cover the following topics to prepare you for exam 77-605: Using Microsoft Office Access 2007. 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.

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

Creating and Formatting Database Elements
•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
•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
•Create queries
•Modify queries

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

Managing and Maintaining Databases
•Perform routine database operations
•Manage databases

Please note : these certifications used to be called Microsoft Certified Application Specialist (MCAS). From June 2010 they are now known as Microsoft Office Specialist 2007 (MOS 2007).

Make Enquiry

Course Enquiry

Book Now

Course Enquiry

Find your local training centre