MCSEClasses Certification Training Boot Camp

MCSE MCSD MCDBA Cisco CIW Linux Oracle Java Security

MCAS - Microsoft Certified Application Specialist Boot Camp

Course Length:	12 days
Certifications:	MCAS
Number of Exams:	4

Class Schedule

13/09/10 - 24/09/10		Info/Enroll
18/10/10 - 29/10/10		Info/Enroll
06/12/10 - 17/12/10		Info/Enroll

Microsoft® Certified Application Specialists are a part of a global community of distinguished achievers. This Microsoft certification credential tells the world you have demonstrated proficiency in the newest standard of the world's foremost desktop computing applications. Microsoft certifications (based on globally recognized standards) demonstrate your computing skills and help advance your career prospects in a competitive job market.

Microsoft Certified Application Specialist certifications are primarily for office workers who use Microsoft Office programs as a vital part of their job functions. This 12 day boot camp covers certification for Word 2007, PowerPoint 2007, Excel 2007, and Access 2007. The course begins with Word training, exam prep, and the certification exam. It is followed by Excel 2007, Access 2007, and PowerPoint 2007.

Microsoft Word 2007 - Intermediate
Microsoft Word 2007 - Advanced
Microsoft Excel 2007 - Introduction
Microsoft Excel 2007 - Intermediate
Microsoft Excel 2007 - Advanced
Microsoft Access 2007 - Introduction
Microsoft Access 2007 - Intermediate
Microsoft Access 2007 - Advanced
Microsoft PowerPoint 2007 - Introduction
Microsoft PowerPoint 2007 - Advanced

The new Microsoft Certified Application Specialist (MCAS) credential is a globally recognized standard that validates skills with the 2007 Microsoft Office system as well as with the Windows Vista operating system. The successor to the Microsoft Office Specialist (MOS) credential, the Microsoft Certified Application Specialist credential meets the demand for the most up-to-date skills using the latest technologies from Microsoft.

The MCAS credential validates the skills that individuals and organizations depend on. Candidates who successfully complete the program by passing a certification exam prove they meet globally recognized performance standards and are able to work productively and efficiently.

In addition, organizations that use the MCAS credential as a tool for quantitative skills measurement to facilitate identifying, hiring, promoting, and retaining qualified individuals can benefit from a streamlined recruitment process, greater individual productivity, and increased employee satisfaction.

Microsoft Word 2007 - Intermediate

In the first course in this series you gained all the basic skills that you need to create a wide range of standardized business documents. If you use Microsoft® Office Word XP on a regular basis, then once you have mastered the basic skills, the next step is to improve your proficiency. To do so, you can customize and automate the way Microsoft® Word XP works for you, and you can improve the quality of your work by enhancing your documents with customized Microsoft® Word XP elements. In this course, you will increase the complexity of your Microsoft® Word XP documents by adding components such as customized lists, tables, charts, and graphics. You will also create personalized Microsoft® Word XP efficiency tools.

Course Objective: You will add complexity to Microsoft® Office Word XP documents and create personalized efficiency tools in Microsoft® Word XP.

Target Student: This course was designed for persons who can create and modify standard business documents in Microsoft® Word XP, and who need to learn how to use Microsoft® Word XP to create or modify complex business documents as well as customized Word efficiency tools. It will be helpful for persons preparing for the Microsoft Office Specialist exams for Microsoft® Word XP.

Prerequisites: Students should be able to use Microsoft® Word XP to create, edit, format, save, and print basic business documents that contain text, basic tables, and simple graphics.

Performance-Based Objectives

Upon successful completion of this course, students will be able to:

manage data in lists.
customize tables and charts.
customize formatting.
work with custom styles.
modify pictures in a document.
create customized graphic elements.
control text flow.
automate common tasks.
automate document creation.
perform mail merges.

Course Content

Lesson 1: Managing Lists

Sort a List
Restart a List
Create an Outline Numbered List
Customize List Appearance

Lesson 2: Customizing Tables and Charts

Sort a Table
Modify Table Structure
Merge or Split Cells
Position Text in a Table Cell
Apply Borders and Shading
Perform Calculations in a Table
Create a Chart from a Word Table
Modify a Chart

Lesson 3: Customizing Formatting

Modify Character Spacing
Add Text Effects
Control Paragraph Flow

Lesson 4: Working with Custom Styles

Create a Character or Paragraph Style
Modify an Existing Style
Create a List Style
Create a Table Style

Lesson 5: Modifying Pictures

Set Picture Contrast or Brightness
Crop a Picture
Wrap Text Around a Picture

Lesson 6: Creating Customized Graphic Elements

Draw Shapes and Lines
Insert WordArt
Insert Text Boxes
Create Diagrams

Lesson 7: Controlling Text Flow

Insert Section Breaks
Insert Columns
Link Text Boxes

Lesson 8: Automating Common Tasks

Run a Macro
Create a Macro
Modify a Macro
Customize Toolbars and Buttons
Add Menu Items

Lesson 9: Automating Document Creation

Create a Document Based on a Template
Create a Document by Using a Wizard
Create or Modify a Template
Change the Default Template Location
Insert a MacroButton Field in a Template

Lesson 10: Performing Mail Merges

The Mail Merge Process
Perform a Merge on Existing Documents
Merge Envelopes and Labels
Use Word to Create a Data Source

[ back to top ]

Microsoft Word 2007 - Advanced

You know how to use Microsoft® Office Word XP to create and format typical business documents. But you need to work on more complex documents. In this course, you will learn how to use Word to create, manage, revise, and distribute long documents, forms, and Web pages.

Course Objective: You will create, manage, revise, and distribute long documents, forms, and Web pages.

Target Student: This course was designed for persons with a basic understanding of Microsoft Windows who can create and modify standard business documents in Microsoft® OfficeWord XP, and who need to learn how to use the more advanced features of Word XP to create, manage, revise, and distribute long documents, forms, and Web pages. This course is intended for persons interested in pursuing Microsoft Office Specialist certification in Microsoft® Word XP.

Prerequisites: Students should be able to use Microsoft® Office Word XP to create, edit, format, save, and print business documents that contain text, tables, and graphics. Students should also be able to use a Web browser and an email program. A basic understanding of XML would also be helpful. In order to understand how Word interacts with other applications in the Microsoft Office System, students should have a basic understanding of how worksheets and presentations work.

Performance-Based Objectives

Upon successful completion of this course, students will be able to:

Use Word with other programs.
Collaborate on documents.
Add reference marks and notes to a document.
Make long documents easier to use.
Secure documents and document information.
Create Web pages.
Create a form.
Use XML in Word.

Course Content

Lesson 1: Using Microsoft Office Word XP with Other Programs

Link to a Microsoft® Office Excel XP Worksheet
Link a Chart to Excel Data
Send a Document Outline to PowerPoint
Extract Text from a Fax
Save a Document as a Different File Format
Look Up Information Using Research Sites
Send a Document as an Email Attachment

Lesson 2: Collaborating on Documents

Modify User Information
Create a New Version of a Document
Delete Old Versions
Send a Document for Review
Use Comments
Compare Document Changes
Merge Document Changes
Review a Document

Lesson 3: Adding Reference Marks and Notes

Insert Bookmarks
Insert Footnotes and Endnotes
Add Captions
Insert Cross-references

Lesson 4: Making Long Documents Easier to Use

Mark Text for Indexing
Insert an Index
Insert a Table of Figures
Mark Text for a Table of Authorities
Insert a Table of Authorities
Insert a Table of Contents
Create a Master Document
Automatically Summarize a Document

Lesson 5: Securing a Document

Update a Document's Properties
Save a Document without Personal Information
Hide Text
Limit Formatting Choices in a Document
Select Regions of a Document that Can Be Modified
Add a Digital Signature to a Document
Require a Password to Open a Document

Lesson 6: Creating Web Pages

Create a Web Page
Insert Hyperlinks
Insert a Movie Clip into a Web Page
Apply a Theme to a Web Page
Create a Framed Web Page
Save a Web Page to a Web Server

Lesson 7: Creating Forms

Add Form Fields to a Document
Protect a Form
Save Form Data as Plain Text
Automate a Form

Lesson 8: Using XML in Word

Tag an Existing Document
Save a Document as XML
Transform an XML Document

[ back to top ]

Microsoft Excel 2007 - Introduction

Upon successful completion of this course, students will be able to:

explore the Microsoft® Office Excel® 2007 environment and create a basic worksheet.
perform calculations.
modify a worksheet.
format a worksheet.
print workbook contents.
manage large workbooks.

Course Content

Lesson 1: Creating a Basic Worksheet

Explore the User Interface and the Ribbon
Navigate and Select in Excel
Obtain Help
Enter Data and Save a Workbook
Customize the Quick Access Toolbar

Lesson 2: Performing Calculations

Create Basic Formulas
Calculate with Functions
Copy Formulas and Functions

Lesson 3: Modifying a Worksheet

Manipulate Data
Insert and Delete Cells, Columns, and Rows
Search for Data in a Worksheet
Spell Check a Worksheet

Lesson 4: Formatting a Worksheet

Modify Fonts
Add Borders and Color to Cells
Change Column Width and Row Height
Apply Number Formats
Position Cell Contents
Apply Cell Styles

Lesson 5: Printing Workbook Contents

Print Workbook Contents Using Default Print Options
Set Print Options
Set Page Breaks

Lesson 6: Managing Large Workbooks

Format Worksheet Tabs
Manage Worksheets in a Workbook
Manage the View of Large Worksheets

[ back to top ]

Microsoft Excel 2007 - Intermediate

Upon successful completion of this course, students will be able to:

calculate with advanced formulas.
organize worksheet and table data using various techniques.
create and modify charts.
format charts.
analyze data using PivotTables and PivotCharts.
insert graphic objects.
Layer and group graphic objects.
customize and enhance workbooks.
create and use templates.

Course Content

Lesson 1: Calculating Data with Advanced Formulas

Manage Cell and Range Names
Calculate Data Across Worksheets
Use Specialized Functions
Analyze Data with Logical and Lookup Functions

Lesson 2: Organizing Worksheet and Table Data

Create and Modify Tables
Format Tables
Sort or Filter Worksheet or Table Data
Calculate Data in a Table or Worksheet

Lesson 3: Presenting Data Using Charts

Create a Chart
Modify Charts
Format Charts

Lesson 4: Analyzing Data Using PivotTables and PivotCharts

Create a PivotTable Report
Analyze Data Using PivotCharts

Lesson 5: Inserting Graphic Objects

Insert and Modify Pictures and ClipArt
Draw and Modify Shapes
Illustrate Workflow Using SmartArt Graphics
Layer and Group Graphic Objects

Lesson 6: Customizing and Enhancing Workbooks and the Excel Environment

Customize the Excel Environment
Customize Workbooks
Manage Themes
Create and Use Templates

[ back to top ]

Microsoft Excel 2007 - Advanced

Upon successful completion of this course, students will be able to:

increase productivity and improve efficiency by streamlining your workflow.
collaborate with others using workbooks.
audit worksheets.
analyze data.
work with multiple workbooks.
import and export data.
use Excel with the web.
structure workbooks with XML.

Course Content

Lesson 1: Streamlining Workflow

Create a Macro
Edit a Macro
Apply Conditional Formatting
Add Data Validation Criteria
Update a Workbook's Properties
Modify Excel's Default Settings

Lesson 2: Collaborating with Others

Protect Files
Share a Workbook
Set Revision Tracking
Review Tracked Revisions
Merge Workbooks
Adjust Macro Settings
Administer Digital Signatures
Restrict Document Access

Lesson 3: Auditing Worksheets

Trace Cell Precedents
Trace Cell Dependents
Troubleshoot Errors in Formulas
Troubleshoot Invalid Data and Formulas
Watch and Evaluate Formulas
Create a Data List Outline

Lesson 4: Analyzing Data

Create a Trendline
Create Scenarios
Perform What-If Analysis
Perform Statistical Analysis with the Analysis ToolPak

Lesson 5: Working with Multiple Workbooks

Create a Workspace
Consolidate Data
Link Cells in Different Workbooks
Edit Links

Lesson 6: Importing and Exporting Data

Export Excel Data
Import a Word Table
Import a Delimited Text File

Lesson 7: Using Excel with the Web

Publish a Worksheet to the Web
Import Data from the Web
Create a Web Query

Lesson 8: Structuring Workbooks with XML

Develop XML Maps
Import and Export XML Data
Manage XML Workbooks

[ back to top ]

Microsoft Access 2007 - Introduction

Performance-Based Objectives

Upon successful completion of this course, students will be able to:

design a simple database.
build a new database with related tables.
manage the data in a table.
query a database using different methods.
design forms
generate reports.

Course Content

Lesson 1: Exploring the Access Environment

Examine Database Concepts
Customize the Access Environment
Use an Existing Access Database

Lesson 2: Designing a Database

Describe the Relational Database Design Process
Review Existing Data
Determine Fields
Group Fields into Tables
Normalize Data
Designate Primary and Foreign Keys
Determine Table Relationships

Lesson 3: Building a Database

Create a New Database
Create and Manage a Table
Create a Table Relationship

Lesson 4: Managing Data in a Table

Modify Table Data
Sort Records
Work with Subdatasheets

Lesson 5: Querying a Database

Filter Records
Create a Query
Add Criteria to a Query
Add a Calculated Field to a Query
Perform Calculations on a Record Grouping

Lesson 6: Designing Forms

View Data Using an Access Form
Create a Form and Using the Form Wizard
Modify the Design of a Form

Lesson 7: Generating Reports

Create a Report Using the Report Wizard
Add a Custom Calculated Field to a Report
Format the Controls in a Report
Apply an AutoFormat to a Report
Prepare a Report for Print

[ back to top ]

Microsoft Access 2007 - Intermediate

Performance-Based Objectives

Upon successful completion of this course, students will be able to:

modify the design and field properties of a table to streamline data entry.
retrieve data from tables using joins.
create flexible queries to display specified records, allow for user-determined query criteria, and modify data using queries.
enhance the capabilities of a form.
customize reports to organize the displayed information and produce specific print layouts.
share Access data across other applications.

Course Content

Lesson 1: Controlling Data Entry

Restrict Data Entry Using Field Properties
Establish a Pattern for Entering Field Values
Create a List of Values for a Field

Lesson 2: Joining Tables

Create Query Joins
Join Unrelated Tables
Relate Data Within a Table

Lesson 3: Creating Flexible Queries

Set Select Query Properties
Create Parameter Queries
Create Action Queries

Lesson 4: Improving Forms

Design a Form Layout
Enhance the Appearance of a Form
Restrict Data Entry in Forms
Add a Command Button to a Form
Create a Subform

Lesson 5: Customizing Reports

Organize Report Information
Format the Report
Set Report Control Properties
Control Report Pagination
Summarize Report Information
Add a Subreport to an Existing Report
Create a Mailing Label Report

Lesson 6: Sharing Data Across Applications

Import Data into Access
Export Data
Analyze Access Data in Excel
Export Data to a Text File
Merge Access Data with a Word Document

[ back to top ]

Microsoft Access 2007 - Advanced

Performance-Based Objectives

Upon successful completion of this course, students will be able to:

restructure the data into appropriate tables to ensure data dependency and minimize redundancy.
write advanced queries to analyze and summarize data.
create and revise Access macros.
display data more effectively in a form.
customize reports by using various Access features, thus making them more effective.
maintain your database using tools provided by Access.

Course Content

Lesson 1: Structuring Existing Data

Analyze Tables
Create a Junction Table
Improve Table Structure

Lesson 2: Writing Advanced Queries

Create Subqueries
Create Unmatched and Duplicate Queries
Group and Summarize Records Using Criteria
Summarize Data Using a Crosstab Query
Create a PivotTable and a PivotChart

Lesson 3: Simplifying Tasks with Macros

Create a Macro
Attach a Macro
Restrict Records Using a Condition
Validate Data Using a Macro
Automate Data Entry Using a Macro

Lesson 4: Making Effective Use of Forms

Display a Calendar on a Form
Organize Information with Tab Pages
Display a Summary of Data in a Form

Lesson 5: Making Reports More Effective

Include a Chart in a Report
Print Data in Columns
Cancel Printing of a Blank Report
Create a Report Snapshot

Lesson 6: Maintaining an Access Database

Link Tables to External Data Sources
Manage a Database
Determine Object Dependency
Document a Database
Analyze the Performance of a Database

[ back to top ]

Microsoft PowerPoint 2007 - Introduction

In the past, you have used paper-based overhead systems to give presentations. Now, you want to upgrade those presentations to an electronic format. You can use Microsoft® Office PowerPoint® XP to give electronic presentations.

Course Objective: You will create effective basic Microsoft® Office PowerPoint® XP presentations for delivery in front of an audience.

Target Student: This course is designed for students who are interested in learning the fundamentals needed to create and modify basic Microsoft® PowerPoint® XP presentations. This course is also intended for students who wish to pursue their Microsoft Office Specialist certification in PowerPoint XP.

Performance-Based Objectives

Upon successful completion of this course, students will be able to:

manipulate an existing PowerPoint presentation.
begin creating a presentation.
format text slides.
add tables to a presentation.
chart data in a presentation.
modify objects on slides.
add images to a presentation.
prepare to deliver a presentation.

Course Content

Lesson 1: An Orientation to PowerPoint

The PowerPoint Environment
Orientation to Views
Navigate Through a Presentation
Edit Slide Text
Save the Presentation
Run a Slide Show

Lesson 2: Beginning a Presentation

Create a New Presentation
Change Background Color
Add Slides to a Presentation
Enter Text
Create a Presentation from a Microsoft Word Outline

Lesson 3: Formatting Text Slides

Apply Character Formats
Align Text
Change Line Spacing
Change Indents

Lesson 4: Adding Tables to a Presentation

Create a Table
Format Tables
Insert a Table from Microsoft Word

Lesson 5: Charting Data

Create a Column Chart
Edit Chart Data
Change Chart Type
Insert a Chart from Microsoft Excel

Lesson 6: Modifying Objects

Resize Objects
Copy and Duplicate Objects
Move Objects
Changing Object Orientation
Format Objects
Group and Ungroup Objects
Change the Order of Objects

Lesson 7: Adding Images to a Presentation

Add Clip Art
Add a Picture from a File
Draw Lines and Shapes
Insert WordArt

Lesson 8: Preparing to Deliver a Presentation

Spell Check
Arrange Slides
Add Transitions
Create Speaker Notes
Send a Presentation to Microsoft Word
Print the Presentation
Package a Presentation for CD

[ back to top ]

Microsoft PowerPoint 2007 - Advanced

As a Microsoft® Office PowerPoint® XP user familiar with the basics, you're able to convey information clearly without much glitz. That's okay, but you can do better-audiences expect more than the basics. In this course, you will enhance presentations with features that will transform basic presentations into those with a powerful means of communication.

Course Objective: You will use Microsoft® Office PowerPoint® XP features that draw, animate, and format presentations with professional-quality content such that they may be communicated to a wide variety of live, remote, and self-service audiences.

Target Student: This course is designed for students who desire to gain the skills necessary to work with design templates, organizational charts, special effects, Web presentations, collaboration functionality, and advanced presentation delivery, or students who desire to prepare for the Microsoft Office Specialist exam in Microsoft® PowerPoint® XP and who already have knowledge of the basics of Microsoft® PowerPoint® XP, including slide formatting, working with tables, images, and objects, charting data, and presentation preparation.

Performance-Based Objectives

Upon successful completion of this course, students will be able to:

create a design template.
create organization charts and diagrams.
add special effects to a Microsoft® Office PowerPoint® XP slide.
create a Web-based Microsoft® Office PowerPoint® XP presentation.
use a Microsoft® Office PowerPoint® XP presentation for collaborative workgroup review.
use functionality that will enable you to deliver live, self-service, and online presentations.

Course Content

Lesson 1: Creating a Custom Design Template

Define Design Template Characteristics
Create a Custom Color Scheme
Set Up a Slide Master
Format Custom Bullets
Add a Footer
Modify the Notes Master
Save a Custom Design Template

Lesson 2: Adding Organization Charts and Diagrams

Working with Organization Charts
Update an Organization Chart
Applying a Chart Layout
Create a Diagram
Draw a Flowchart

Lesson 3: Adding Special Effects

Add Sound and Movies
Add Animation
Emphasize Objects
Set a Motion Path
Set the Order of Effects

Lesson 4: Creating Web Presentations

Create a Group Home Page with the AutoContent Wizard
Hyperlink to a Web Page
Publish as a Web Page

Lesson 5: Collaborating in PowerPoint

Set Password Protection
Work with Comments
Send a Presentation for Review
Merge Revision Copies
Apply Reviewer Changes

Lesson 6: Delivering a Presentation

Hyperlink Within PowerPoint
Add an Action Button
Set Up a Custom Show
Annotate a Presentation
Working with Narrations and Slide Timings
Set Up a Slide Show to Repeat Automatically

[ back to top ]

MCSEClasses.com is your best choice for MCAS, MCAS training, MCAS certification, MCAS certification boot camp, MCAS boot camp, MCAS certification training, MCAS boot camp training, MCAS boot camp certification, MCAS certification course, MCAS course, training MCAS, certification MCAS, boot camp MCAS, certification MCAS boot camp, certification MCAS training, boot camp MCAS training, certification MCAS course.