Microsoft Certified Application Specialist MCAS

Course Code: BA210

Gain your Microsoft Certified Application Specialist certification and make your CV stand out!

The course will cover Word (77-601), Access (77-605), Powerpoint (77-603), Excel (77-602) & Outlook (70-604).

It starts at a level that allows you to grasp concepts quickly and easily and build on this knowledge to give you a full understanding of Microsoft Office.

This course is suitable for; Office Administrators, Accounts staff, and people who would like to brush up on their computer skills.

Once the course has been successfully completed, student can gain access to a unique certification logo that can be displayed on your C.V and other business materials.

Course Content

Microsoft Certified Application Specialist - PowerPoint 2007 (Exam Number: 77-603)

Starting in Powerpoint
Planning a presentation
Formatting text
Formatting paragraphs
Preparing to deliver
Format slide text
Create a presentation
Change a placeholder
Create and print hand-outs
Adding tables
Charting in Powerpoint
Inserting multimedia objects
Working with Auto Shapes
Add and customise a table
Insert graphics in slides
Powerpoint masters
Special effects
Delivering a presentation
Collaborating in Powerpoint
Securing and distributing
Create and modify masters
Apply animation effects
Delivery a custom slide show
Use comments and mark-up

Microsoft Certified Application Specialist - Outlook 2007 (Exam Number: 77-604)

Using Outlook
Application window
Messages & contacts
Appointments & tasks
Moving, copying, & deleting items
Printing & finding items
Customise the navigation pane
Use the to do bar
Create an E-mail message
Use the reading pane
Attachments
Create a new contact
Add a contact from a message
Advanced management
Message settings
Task management
Item organisation
Assign categories to contacts
Apply a flag to mail messages
Customise a message view
Find a message using search
Save a message as text
Send a calendar via E-mail
Send a calendar as a web page
Use a distribution list
Options & customisations
Managing views
Sharing calendars
Managing Outlook
Security & privacy
Create a default signature
Schedule an appointment
Create a re-curring appointment
Schedule and respond to a meeting
Create, assign & respond to a task request
Create, delete and add a new note

Microsoft Certified Application Specialist - Word 2007 (Exam Number: 77-601)

The basic document
Editing a document
Formatting text and paragraphs
Adding/creating tables
Page appearance
Proofing and formatting a document
Lists & charts
Customised formatting
Drawing
Mail merge
Automating tasks
Document lay out
Word and other programs
Collaborating on documents
Versioning
Reference marks & notes
Table of contents
Secure a word document

Microsoft Certified Application Specialist - Excel 2007 (Exam Number: 77-602)

Creating and manipulating data
Formatting data and content
Creating formulas
Modifying formulas
Presenting data
Collaborating and securing data

Microsoft Certified Application Specialist - Access 2007 (Exam Number: 77-605)

Access basics
Designing and building a database
Non-numerical data types
Managing data types
Filters and queries
Using forms
Producing a report
Create a database
Create a table
Edit a relationship
Set field data type
Managing table data
Design a query
Controlling data entry
Creating flexible queries
Advanced queries
Customising reports
Sharing Access data
Add controls to a form
Creating and using macros
Setting start-up options
Database maintenance
Distributing and securing the database

Assessment

The MCAS course requires students to pass examinations taken at a local test centre to you. It is the students responsibility to book and pay for exams, these are around £75.00, however it is advised that you do check this with your chosen test centre. These exams can be sat at Certiport Microsoft test centres.

Study Method

The course is designed for study by distance learning at home or at work. Students receive a course manual, assignments and study guide plus tutor support by mail or email. You can start at any time and plan your studies over a period of up to one year from the time of registration.

Qualifications

On successful completion of your examinations and assessments you will receive the MCAS Certification; a leading industry recognised awarding body.

You can read more about Microsoft and our awarding bodies here: Awards.

Course Questions & Answers

Q: What skills are needed to enrol onto this course?

You do not need any previous knowledge to enrol onto this course.

Q: Is there a time limit for completion of this course?

You will spend around 130 hours studying on this course in your own time at home. Students are provided with a full 12 months to complete the course.

Q: What is included in the cost of my course?

You will receive your official course CD-ROM's
Unlimited tutor support via email

Q: Do I have to sit an exam?

Yes, to gain full MCAS certification you will need to take two online exams in a local test centre to you. It is the students' responsibility to arrange the exams. The exams can be done at Certiport Microsoft test centres. These cost around £75.00, however it is advised that you do speak to your chose exam centre about the cost of the exams.