The course is ideal for beginners and takes users to an advanced level of proficiency. Designated as Officially Approved Courseware for the Microsoft Office Specialist program, this course will help students prepare for the Access 2010 exam (77-885).
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.
- MOS Access 2010 Course Card:
Access the most important information you need quickly and easily with this new four-colour, tri-fold, six-sided Course Card! The Course Card contains vital information for both basic and advanced skills and offers something for students of all levels.
- 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 by this lesson: 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 by this lesson: 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 by this lesson: Querying with SQL; Advanced Queries; Macros; Advanced Macros; Importing, Exporting & Linking; Database Management; and Internet Integration.
A CD Rom is included in each course book which contains all of the exercise files required to successfully complete your study and aim towards your MOS examinations.
- CertBlaster Online Exam Preparation Software
The course also comes with DTI Publishing’s Online CertBlaster exam preparation software absolutely free. CertBlaster covers mock examination questions in multiple choice or multiple answer formats. This software is the perfect addition to help preparefor your exam.
Pre-Requirements:
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.
