courses / products
View Complete List...
View Complete List...
View Complete List...
View Complete List...
View Complete List...
View Complete List...
View Complete List...
View Complete List...
View Complete List...
View Complete List...
View Complete List...
View Complete List...
View Complete List...
SUBSCRIBE
Subscribe to Receive Special Offers & New Release Updates
100% Satisfaction Guaranteed

CareerVision is committed to providing our customers with the best service and products available.

We back our training products with a 100% Satisfaction or Your Money Back Guarantee, so you can buy worry free. More....



FAST UK DELIVERY
Order Today, Learn Tomorrow!

Pay as You Learn

SECURE PAYMENT
PROCESSING


We Accept All Major Credit Cards, PayPal and Google Checkout

Credit Cards Accepted
PayPal Accepted



Follow us on Facebook

Microsoft Certified Application Specialist (MCAS)

 
Bookmark and Share
Microsoft Certified Application Specialist (MCAS)
Single CD £79.00  £75.00 + VAT
Buy Now
Multi User Network CD £395.00  £375.00 + VAT
Buy Now
 

More on Single User & Multi User Networkable CDs


Author - Lauri Matson
Duration - 9.5 Hours
 

COURSE INTRODUCTION

Microsoft Office is the foundation of most business computer systems; understanding its power and utilizing its productivity is crucial in today's environment. The Microsoft Certified Application Specialist (MCAS) certification is a series of performance-based exams of the Microsoft Office Suite. The exams focus on the use of these programs in a "real world" enviroment: Microsoft Office Word 2007, Excel 2007, PowerPoint 2007, Access 2007, Outlook 2007, and Windows Vista. Acquiring MCAS Certification places a candidate above the rest when searching for new positions and advancement opportunities. This course prepares you for MCAS exams 77-600 through 77-605 by teaching the skills you need to master in each of the programs to achieve the highest standards of performance and efficiency. To begin learning today, simply click on the movie links.


 

COURSE OUTLINE


Introduction
MCAS Certification
Getting Started
Understanding IRM
Using the Work Files

Windows Vista Exam (77-600)
Manage Windows Firewall
Internet Explorer Security
Securing User Accounts

Remote Computing
Network Terminology
Network Connections
Collaboration with Meeting Space
Managing Remote Access

Customizing Devices
Devices & Drivers
Personalize Display Settings/Appearance
Personalize Other Settings
Start Menu/Taskbar/Notification Area
Sidebar

Files & Folders
Windows Explorer
Manage & Secure Folders
Advanced Searching
Sharing Files
77-600 Review Questions

Word 2007 Exam (77-601)
Create & Customize Documents
Page Layout: Personalization
Page Layout: Columns/Arrange/Headers/Footers
Pagination/Options/Settings

Visual Content
Illustrations: Pictures & Shapes
Illustrations: SmartArt Diagrams
Format Text Graphically
Insert & Modify Text Boxes

Organizing Content
Structure Content by Using Quick Parts
Tables & Lists
Margins & Tabs
References & Captions

Reviewing Documents
Navigating Your Documents
Tracking Changes & Comments
Compare & Combine Documents

Sharing & Collaboration
Prepare Documents for Sharing
Access & Security
Permissions/Information Rights Manager
77-601 Review Questions

Excel 2007 Exam (77-602)
Manipulating Data pt. 1
Manipulating Data pt. 2
Data Validation & Integrity
Using Auto-fill
Themes & Styles

Formulas & Functions
Reference Data in Formulas
Working with Formulas
Summarize Data with Functions
Conditional Logic (IF Statements)

Presenting Data Visually
Conditional Formatting
Create & Format Charts
Charting Continued
Sort & Filter
Outlining & Subtotals

Collaborating & Securing Data
Track Changes
Preparing for Distribution
Print Options

Advanced Features
External Data
Saving & File Formats
77-602 Review Questions

PowerPoint 2007 Exam (77-603)
PowerPoint Views
New Presentations
Using Masters
Elements & Arrangements

Slide Content
Insert & Format Text Boxes
Manipulate Text
Linking Content

Working with Visual Content
SmartArt Diagrams
Picture Styles
Formatting Pictures
Shapes & Other Techniques
Charts & Tables

Collaborating & Delivering Presentations
Review Presentations
Secure & Share Presentations
Printing Presentations
Timing & Rehearsal

Animation
Applying Animation to Text
Applying Animation to SmartArt
Working with Transitions
77-603 Review Questions

Outlook 2007 Exam (77-604)
Navigation
Outlook Today & Mail
Attachments
Signatures
Security & Digital Signatures

Scheduling
Appointments & Events
Meetings & Recurring Items
Calendar Settings
Sharing Calendar

Tasks
Task Terminology
Create/Modify/Complete Tasks
Assign/Update/Respond to Tasks

Contact Information
Terminology: Books/Lists/Folders
Create & Modify Contacts
Working with Business Cards
Creating a Distribution List

Organizing Information
Customizing Views
Using Instant Search
Folders & Junk Mail
Rules to Organize Messages
77-604 Review Questions

Access 2007 Exam (77-605)
Database Design: Data Needs & Types
Primary Keys
Table Relationships
Split Databases

Database Elements
Getting Started
Security Settings
Tables & Fields
Creating Forms
Forms Continued
Using Reports
Designing Reports

Advanced Features
Navigation Pane
View Relationship
Import Files
Export Tables/Queries
Pivot Charts & Tables

Queries
Create Queries
Modify Queries
Macros & Coding

Managing Databases
Print Database Objects
Splitting a Database
Database Administration
77-605 Review Questions

Conclusion
Tips for Taking the Exam
Exam Objectives & Questions
About the Author

 
 
Print Image Printer friendly version   
Top of page
A-Z COURSE LIST   PROVIDERS   CBT TRAINING  CVISION NEWS  CONTACT US   SITEMAP  

MCITP Training Courses  MCPD Training Courses  MCTS Training Courses
MCITP Database Developer Training Courses  MCITP Database Administrator Training Courses
Flash Tutorials & Training Courses  MCSE CBT Training Adobe Photoshop Tutorials & CBT Training Microsoft Certification Training

CareerVision
61 Caroline Street, Birmingham, B3 1UF, UK
Tel: 0121 248 2400, Fax: 0121248 2800,
Email: sales@cvision.co.uk |Web: www.cvision.co.uk

red arrow Website design by Aimpro UK red arrow Terms