Access 2010

This complete MOS certification package includes everything you need to achieve your Access 2010 MOS certificate, including the official Microsoft online training and reference material, practice tests and your exam voucher¹.

Microsoft Office Specialist (MOS) is the only performance-based certification that validates the skills needed to get the most out of Microsoft Office. Earning a MOS certification can help you stand out in today's competitive job market, broaden your employment opportunities by displaying your advanced skills, and support higher earning potential.

Please note, the courses and practice tests require Office 2010 to be installed on your PC.

You'll learn how to:

Beginner Skills in Microsoft Access 2010

This Beginner course contains four sections.

• The first section is about creating and editing a database, from exploring the Access 2010 interface, reviewing access 2010 fundamentals, creating and viewing a database, importing and exporting data, editing and formatting table data, creating and managing indexes and events database.
• The second sections helps you with creating and using a query by using Query Wizard, creating an expression by using expression builder, creating a criteria-based query and performing calculations by using a query.
• The third section shows you more about working with a report, from creating and editing reports and labels, to grouping and sorting data in a report and performing calculations.
• The fourth section covers creating and editing a form by using Form Wizard or the form tool, and editing a form in design view.

Intermediate Skills in Microsoft Access 2010

This Intermediate course contains two sections.

• The first section covers modifying a database, including creating and modifying a table, defining a primary key, reviewing table fundamentals, creating datasheet relationships, validating data in a table, using lookup fields, creating a default database template, and compacting and editing a database.
• The second section is about working with complex queries, showing you more about creating and editing a complex query, creating a totals query, working in SQL View, and creating pivot objects.

Advanced Skills in Microsoft Access 2010

This Advanced course contains two sections.

• The first section is about creating programmed elements, from exploring the macro environment, creating and editing a macro, creating an embedded macro, handling errors in a macro, and creating and editing a module.
• The second section covers sharing database information, like creating an execute-only database, encrypting and packaging a database, Using the Access 2010 Runtime program, synchronizing a database with a SharePoint List, and importing data from and exporting data to SharePoint Lists.

Course features:

This package includes:

• Microsoft’s official Access 2010 MOS e-learning courses: Three online courses (approximately 4 hours of learning) taking you from Introduction to Advanced level using Access 2010 – the complete training package to prepare for MOS: Microsoft Office Access 2010 Exam 77-885.
• Microsoft’s official Access 2010 Study Guide (PDF): The Access 2010 MOS Study Guide is the companion to the courseware and provides instant access to the exam reference material and step by step task instructions. The Study Guide is provided as a PDF file for access via your PC.
• Practice exams: To maximize your success, access to practice exams is provided (with either feedback mode or simulation mode). The practice exams are delivered through a dedicated website which closely mirrors the actual exam experience.
• Exam Voucher: Your exam voucher (worth £65) entitles you to sit your MOS exam at an accredited test centre.

¹ An additional £15 invigilation fee is payable directly to the exam centre when you sit the test.

How you’ll access these resources:

You'll access the MOS e-learning courses and study guide via their eCourses “my courses” page. The instructions to access the practice exams, requiring registration on a separate website, are provided with the exam voucher in an email following your purchase.

Access to the resources is provided for 12 months from date of purchase.

To book your exam, simply contact your nearest test centre. You need to sit your exam within 12 months of purchase, so please allow time to book your exam before your voucher expires.

Course Code: 104505BT001