Microsoft Certified Application Specialist (MCAS)

Call 0800 056 3983 to discuss payment options.

Prerequisites

There are no formal prerequisites associate with this course. 

Who is this course for?

This course is for those looking to show that they can meet globally recognised performance standards in using Microsoft Office 2007 and Windows Vista, acquiring the most up-to-date and demanded skills in the latest Microsoft technologies.

What will I learn?

Upon successful completion of the course, you will be able to:

PowerPoint 2007

• Create and format presentations
• Create and format slide content
• Work with visual content
• Collaborate on and deliver presentations

Outlook 2007

• Manage messaging
• Manage scheduling
• Manage tasks
• Manage contacts and personal contact information
• Organise information

Word 2007

• Create and customise documents
• Format content
• Work with visual content
• Organise content
• Review documents
• Share and secure content

Excel 2007

• Create and manipulate data
• Format data and content
• Create and modify formulae
• Present data visually
• Collaborate on and secure data

Access 2007

• Structure a database
• Create and format database elements
• Enter and modify data
• Create and modify queries
• Present and share data
• Manage and maintain databases

What certificate will I get?

After passing this course, you will receive the following certifications:

• MCAS PowerPoint 2007
• MCAS Outlook 2007
• MCAS Word 2007
• MCAS Excel 2007
• MCAS Access 2007

What course materials do I get?

To help you excel in your examinations through effective and efficient learning, ICS will provide you with all the learning materials necessary:

• Flash video tutorials led by a virtual instructor
• Interactive simulations and resources
• Microsoft-branded supporting textbook 
• Course and assessment guide to help you pass your exams.

What support do I get?

You will have access to our dedicated ICS Technology Student Community, which will allow you to share and collaborate with your peers, get interactive and expert feedback from tutors and browse our resource library.

You will also receive 6 months of email tutorial support.

Sample Course Material

You need to upgrade your Flash Player!

This web site makes use of the Macromedia Flash player version 8 or newer.

Related Courses

MCTS Microsoft Office SharePoint Server 2007, Configuration

Application Specialist (MCAS) Course Outline

EXAM 77-601

The Basic Document

• Editing a Document
• Formatting Text
• Formatting Paragraphs
• Adding Tables
• Controlling Page Appearance
• Proofing a Document
• Format Document Text
• Format a Paragraph
• Create a New Style
• Insert or Create a Table
• Change the Page Appearance

Managing Lists

• Customizing Tables and Charts
• Customized Formatting
• Automating Data Entry
• Controlling Text Flow
• Drawing
• Performing Mail Merges
• Automating Common Tasks
• Sort and Format a List
• Customize a Table
• Create Themes and Templates
• Create and Use Building Blocks
• Change the Document Layout
• Use the Mail Merge Wizard

Word & Other Programs

• Collaborating on Documents
• Versioning
• Reference Marks & Notes
• Working in Long Documents
• Securing a Document
• Creating Forms
• Using XML in Word
• Creating Web Pages
• Link or Embed Content
• Compare and Merge Documents
• Reference Marks and Notes
• Create a Table of Contents
• Secure a Word Document 

EXAM 77-602

• New Features
• Starting in Excel
• Basic Navigation
• Working with Data
• Formulas and Functions
• Formatting Data
• Working with Worksheets
• Printing
• Level Summary
• Use AutoSum and AutoFill
• Use the Vlookup Function
• Use Themes, Styles and Formats
• Use Table Styles
• Insert Cells, Rows and Columns
• Cut, Copy and Paste Cells
• Manage Worksheets
• Adjust Page Layout

Templates

• Sorting and Filtering
• Navigating in Excel
• Working with Comments
• Using Name Box
• Controlling and Validating Data Entry
• Controlling What You See
• Using Drawing Tools
• Charting
• Level Summary
• Create a Hyperlink
• Use AutoFilter
• Sort Data in a Range or Table
• Use the Subtotal Command
• Use Advanced Filter
• Create a Custom List
• Use the Name Box and Go To
• Add, Edit, and Delete Comments

Advanced Data Tools

• Advanced Formula and Function Tools
• Protecting and Reviewing Your Work
• Merging and Consolidating
• Working with External Data
• Macros
• XML
• Trusting and Privacy in 2007
• Excel Options
• Level Summary
• Use Scenarios
• Audit a Formula
• Use a PivotTable Report
• Consolidate Data
• Track and Review Changes
• Use Goal Seek
• Validate Data
• Use Conditional Formatting

EXAM 77-603

• Starting in PowerPoint
• Beginning a Presentation
• Formatting Text
• Formatting Paragraphs
• Preparing to Deliver
• Format Slide Text
• Create a Presentation
• Change a Placeholder
• Create and Print Handouts
• Adding Tables
• Charting in PowerPoint
• Inserting Multimedia Objects
• Working with AutoShapes
• Add and Customize 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
• Deliver a Custom Slide Show
• Use Comments and Markup 

EXAM 77-604

• Using Outlook
• Application Window
• Messages
• Appointments
• Contacts
• Tasks
• Moving, Copying, and Deleting Items
• Printing and Finding Items
• Customize the Navigation Pane
• Use the To-Do Bar
• Create an Email Message
• Use the Reading Pane
• Attach a File to a Message
• Open and Preview Attachments
• Create a New Contact
• Add a Contact from a Message

Advanced Management

• Message Settings
• Task Management
• Item Organization
• Assign Categories to Contacts
• Apply a Flag to Mail Items
• Customize a Message View
• Find a Message using Search
• Save a Message as Text    
• Send a Calendar via Email
• Save a Calendar as a Web Page    
• Use a Distribution List

Options and Customization

• Managing Views
• Sharing Calendars
• Managing Outlook
• Security and Privacy
• Create a Default Signature
• Schedule an Appointment
• Create a Recurring Appointment     
• Schedule a Meeting
• Respond to a Meeting Request
• Create and Assign a Task    
• Respond to a Task Request
• Create, Delete, and View Notes    

EXAM 77-605

• Access Basics
• Designing a Database
• Building a Database
• Non-Numerical Data Types
• Managing Table Data
• Filters and Queries
• Using Forms
• Producing Reports
• Create a Database
• Create a New Table
• Edit a Relationship
• Set Field Data Type
• Manage Table Data
• Filter a Datasheet
• Design a Query
• Create a Form
• Design a Report
• Controlling Data Entry
• Finding and Joining Data
• Creating Flexible Queries
• Enhancing Forms
• Customizing Reports
• Sharing Access Data
• Create a Validation Rule
• Join Tables in a Query
• Create a Parameter Query
• Add Controls to a Form
• Create a Grouped Report
• Get External Data

Structuring Existing Data

• Writing Advanced Queries
• Creating and Using Macros
• Making Forms More Effective
• Improving Reports
• Setting Startup Options
• Database Maintenance
• Distributing and Securing the Database

Assessment

Your knowledge of the course materials will be assessed by five examinations. These can be sat at your local authorised Prometric test centre:

• PowerPoint 2007: Exam 77-603
• Outlook 2007: Exam 77-604
• Word 2007: Exam 77-601
• Excel 2007: Exam 77-602
• Access 2007: Exam 77-605

Please note that examination fees are additional to course fees.

Hours of Study

90 hours

Minimum System Requirements

• 600MHz Intel Pentium III processor or equivalent
• Windows 98, Windows 2000, Windows XP or Windows Vista
• 128MB RAM (256MB RAM recommended)
• 128MB available disc space
• CD-ROM drive
• Microsoft Internet Explorer 5.01SP2.
• Microsoft Office