|
Summary
![]()
![]() |
|
|||||||||||
The MOS (Microsoft Office Specialist) Microsoft Access 2010 Course will help students to master Microsoft Access 2010.
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.
Please Note: This course is not compatible with Apple Mac Computers.
The Course Consists of the Following Items:
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.
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.
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.
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.
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.
Qualification:
On Completion of Course, you can apply for your Microsoft MOS Access 77-885 Examination.
The Distance
Learning Centre is one of the leading and longest established
suppliers of
distance learning courses, open learning, home study, and correspondence
courses in the UK. Providing distance
learning courses since 1994, the Distance Learning Centre has grown to
be one
of the UK’s leading distance learning
providers.
The Distance Learning Centre offers a wide variety of subjects which you can study at your own pace from home or work. Each year, thousands of students sign up for our distance learning courses and gain relevant nationally-recognised qualifications to assist their career and improve their employability. Become one of them. Contact The Distance Learning Centre.
As well as our large range of Contemporary Distance Learning Courses, a small range of Online E Learning Courses are provided.
It's all really very simple. The Distance Learning Centre supplies you with appropriate study materials to head for a particular qualification or exams. You receive your course materials in one go so you know exactly what you are getting for your money. You then receive support through a personal tutor to help you get through the course materials.
|
There are many advantages to Distance Learning, but the main advantages have to be cost and flexibility. When studying via Distance Learning, there is no need to attend a classroom, so there is no waste of time or other resources spent commuting to specific location for each class. Distance learning is also a great advantage for those with restricted mobility. Distance Learning allows you to study at own pace, as quickly or slowly as you please, and of course the costs are also a lot less! |
|
Distance Learning allows smaller fees for you because we do not have the large overheads that some over companies have. We do not spend thousands of pounds on expensive television and radio campaigns and do not employ a large sales team.
You can get help from your dedicated tutor 7 days a week by email, or post. Some courses also come with telephone support.
Interested in taking a distance learning course? Request Information and our advisors will help you
To request information from Mos Access 2010 Course, please fill out the following details: