Microsoft Certified Application Specialist (MCAS)

Microsoft Certified Application Specialist (MCAS)
If you’re looking to become a Microsoft Certified Professional in Office 2007, then this course is ideal for you. Through the teaching of data formatting, presentation and management, this course gives you the skills and knowledge necessary to excel in Microsoft Word, Excel, PowerPoint, Outlook and Access.







 
 
 

Delivery:	Distance
Category:	Microsoft Certification

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
E-books
Practice exams
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.

svp_clip_id = '28c7e0e51df7';
svp_player_color1 = '#a6a6a6';
svp_player_color = '#a6a6a6';
svp_player_height = '499';
svp_player_width = '640';
svp_transparent = 'false';
svp_pause='1';
svp_repeat='';
svp_bg_color='#FFFFFF';
svp_fs_mode='2';
svp_no_fullscreen='0';
svp_no_controls='';
svp_skin='0';
svp_start_img='0';
svp_use_div='v_player28c7e0e51df7';
svp_brand_new_window='1';

Your browser does not support JavaScript! JavaScript is needed to display this video player!






Related Courses
MCTS Microsoft Office SharePoint Server 2007, Configuration




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



Related CoursesPeople who viewed this course also viewed the following courses:








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.