The MOS (Microsoft Office Specialist) Microsoft Access 2010 Course will help students to master the Microsoft Access 2010 database software package.

The course is ideal for beginners and takes users to an advanced level of proficiency. Designated as Officially Approved Course materials for the Microsoft Office Specialist program, this course will help students prepare for the MOS Access 2010 77-885 Exam.

This Microsoft certification credential demonstrates proficiency in the newest standard of the world's foremost desktop computing applications. MOS certifications are primarily for anyone who uses Microsoft Office programs as a vital part of their job functions. These certifications cover the entire Microsoft Office Suite.

SPECIAL OFFER: Purchase 3 MOS 2010 Courses for only £450.00. Check out using the following code to apply your £75.00 discount: DLCMOS10.

The Course Consists of the Following Items:

  • MOS Access 2010 Basics Course Book:

This course book covers the basic functions and features of Access 2010. After an introduction to database concepts and the Access environment and Help systems, students will learn how to design and create databases. Then they will work with tables, fields, and records; sort and filter data; and set field properties and data entry rules. Students will then learn to create queries, forms, and reports.

The following topics are covered in this book: Getting Started; Database & Tables; Fields & Records; Data-Entry Rules; Basic Queries; Using Forms; and Working with Reports.

  • MOS Access 2010 Intermediate Course Book:

This Course Book builds on the skills and concepts taught in Access 2010: Basic. Students will learn how to normalize data, manage table relationships, and enforce referential integrity; work with Lookup fields and subdatasheets; create join queries, calculated fields, and summary values; add objects to forms and create advanced form types; print reports and labels; create and modify charts; and use PivotTables and PivotCharts.

The following topics are covered in this book: Relational databases; Related tables; Complex queries; Advanced form design; Reports and printing; Charts; and PivotTables and PivotCharts.

  • MOS Access 2010 Advanced Course Book:

This course book builds on the skills and concepts taught in the Intermediate Course Book. Students will learn how to query with SQL; create crosstab, parameter, and action queries; create macros; import, export, and link database objects; work with XML documents; work with Windows SharePoint Services; optimize databases; password-protect and encrypt databases; set Access options and properties; create hyperlink fields; and use Outlook 2010 to update data.

The following topics are covered in this book: Querying with SQL; Advanced Queries; Macros; Advanced Macros; Importing, Exporting & Linking; Database Management; and Internet Integration.

  • Student Exercise Files:

Once enrolled students will receive a support email giving them access to their student files and to PowerPoint presentations relevant to the content of each unit. These files are also available through a student page and can be sent on disk on request.

  • GMetrix Exam Preparation Software:

The course also comes with GMetrix exam preparation software. The GMetrix Skills Management System provides everything you need to prepare for the Microsoft Office Specialist (MOS) Certification.

Overview of Test features:

  • Practice tests map to the Microsoft Office Specialist (MOS) exam objectives
  • All tests are in-application or performance-based simulations to provide the best assessment of real-world experience
  • All tests have both a testing and a training mode providing step-by-step help on each question
  • Progress at own pace, save test to resume later, return to skipped questions
  • Detailed, printable score report highlighting areas requiring further review

Please Note: You will need a version of Microsoft Office 2010 to be able to use the GMetrix software package.

Prerequisites:

There are no particular entry requirements as the course is set out for beginners although students will require their own version of Microsoft Access 2010 to complete the course.

Course Duration & Support:

Students may register at any time. The courses are designed as self-study courses but if you have any problems you can email our email support. As the course is self study you can complete in as little or as long a time as you prefer, and we do not impose a cut-off date for study.

Assessment:

Assessment is in the form an MOS Examination. Examinations are in a multiple choice/multiple answer format. Earning a Microsoft Office Specialist certification can help you differentiate yourself in today's competitive job market, broaden your employment opportunities by displaying your advanced skills, and result in higher earning potential. Microsoft Office Specialist certification can also lead to increased job satisfaction. Research indicates that certified individuals have increased competence, productivity, and credibility with their employers, co-workers, and clients.

Qualification:

MOS Access 2010 CourseOn Completion of Course, you can apply for your Microsoft MOS Access 2010 - 77-885 Examination.

Exams must be sat at a registered Certiport testing centre. Exam vouchers (Valid for 12 Months) can be purchased via our website for £65.00. We advise buying this when you are ready to sit your test, although you can add this to your order when you purchase your course.

Please Note: Exam Centres will usually charge an additional proctoring fee (Approximately £20.00) for sitting exams.

View Testimonials
Submit a Testimonial