Microsoft Word 2007

Exam Structure: 26 Questions in 50 Minutes, Pass rate 66%

Exam Objectives as stated by Microsoft

CREATING AND CUSTOMISING DOCUMENTS
Create and format documents
Lay out documents Make documents and content easier to find
Personalise Office Word 2007

FORMATTING CONTENT
Format text and paragraphs
Manipulate test
Control pagination

WORKING WITH VISUAL CONTENT
Insert illustrations
Format illustrations
Format text graphically
Insert and modify test boxes

ORGANISING CONTENT
Structure content by using Quick Parts
Use tables and lists to organise content
Modify tables
Insert and format references and captions
Merge documents and data sources

REVIEWING DOCUMENTS
Navigate documents
Compare and merge document versions
Manage tracked changes
Insert, modify, and delete comments

SHARING AND SECURING CONTENT
Prepare documents for sharing
Control document access
Attach digital signatures

__________________________________________________________________________

Microsoft Excel 2007

Exam Structure: 23 Questions in 50 Minutes, Pass rate 68%

Exam Objectives as stated by Microsoft

CREATING AND MANIPULATING DATA
Insert data by using AutoFill
Ensure data integrity
Modify cell contents and formats
Change Worksheet Views

FORMATTING DATA AND CONTENT
Format worksheets
Insert and modify rows and columns
Format cells and cell content
Format data as a table

CREATING AND MODIFYING FORMULAS
Reference data in formulas
Summarise data using a formula.
Summarise data using subtotals.
Conditionally summarize data by using a formula
Look up data by using a formula.
Use conditional logic in a formula.
Format or modify text by using formulas.

PRESENTING DATA VISUALLY
Create and format charts
Modify charts
Apply conditional formatting
Insert and modify illustrations
Outline data

COLLABORATING AND SECURING DATA
Manage changes to workbooks
Protect and share workbooks
Prepare workbooks for distribution
Set print options for printing data, worksheets, and workbooks
Filter data by using AutoFilter
Filter and sort data by using conditional formatting
Filter and sort data by using cell attributes

__________________________________________________________________________

Microsoft Outlook 2007

Exam Structure: 32 Questions in 50 Minutes, Pass rate 70%

Exam Objectives as stated by Microsoft

MANAGING MESSAGING
Create and send e-mail message
Create and manage your signature and automated messages
Managed e-mail message attachments
Configure e-mail message sensitivity and
importance settings
Configure e-mail message security settings
Configure e-mail message delivery reports
View e-mail messages

MANAGING SCHEDULING
Create appointments, meetings and events
Send meeting requests
Update, cancel, and respond to meeting requests
Customise calendar settings
Share your calendar with others
View other calendars

MANAGING TASKS
Create and modify contacts
Accept, decline, assign, update, and respond to tasks

MANAGING CONTACTS AND PERSONAL CONTACTS INFORMATION
Create and modify contacts
Edit and use electronic business cards
Create and modify distribution lists
Create a secondary address book

ORGANISING INFORMATION
Categorise items by colour
Create and manage data files
Organise mail folders
Locate items by using the search feature
Create, modify, and remove rules to manage e-mail messages.

__________________________________________________________________________

Microsoft PowerPoint 2007

Exam Structure: 27 Questions in 50 Minutes, Pass rate 70%

Exam Objectives as stated by Microsoft

CREATING AND FORMATTING PRESENTATIONS
Create new presentations
Customise slide masters.
Add elements to slide masters
Create and change presentation elements
Arrange slides

CREATING AND FORMATTING SLIDE CONTENT
Insert and format text boxes.
Manipulate text.
Add and link existing content to presentations
Apply, customize, modify, and remove animations

WORKING WITH VISUAL CONTENT
Create SmartArt diagrams
Modify SmartArt diagrams.
Insert illustrations and shapes.
Modify illustrations
Arrange illustrations and other content
Insert and modify charts
Insert and modify tables

COLLABORATING ON AND DELIVERING PRESENTATIONS
Review presentations
Protect presentations.
Secure and Share Presentations
Prepare printed materials
Prepare for and rehearse presentation delivery

__________________________________________________________________________

Microsoft Access 2007

Exam Structure: 29 Questions in 50 Minutes, Pass rate 70%

Exam Objectives as stated by Microsoft

STRUCTURING A DATABASE
Define data needs and types
Define and print table relationships
Add, set, change, or remove primary keys
Split databases

CREATING AND FORMATTING DATABASE ELEMENTS
Create Databases
Create and modify tables
Create reports and forms
Modify the design of reports and forms
Enter and modify data
Enter, edit, delete and navigate among records
Find, replace and import data
Attach documents to and detach from records

QUERIES
Create and modify queries
Present and share data
Sort and filter data
Export data

DATABASE
Save database objects as other file types
Print database objects
Manage and maintain databases
Perform routine database operations
Manage databases

__________________________________________________________________________

Windows Vista for Business

Exam Structure: 38 Questions in 50 Minutes, Pass rate 65%

Exam Objectives as stated by Microsoft

PROTECTING YOUR COMPUTER
Managing Windows Firewall
Manage Malicious software (malware) Protection
Configure Windows Update Settings
Lock a Computer
Manage Windows Internet Explorer Security
Configure Local User Accounts

MANAGING MOBILE & REMOTE COMPUTING
Manage the Computer Power State
Manage Network Connections
Manage Remote Access to your Computer
Connect to another Computer
Access files stored in shared network folders
when your computer is offline

MANAGING SOFTWARE, DISKS AND DEVICES
Manage Software
Manage Disks
Manage Devices and Drivers
Manage Display Settings
Configure Multiple Monitors
Install and Configure a Printer

MANAGING FILES & FOLDERS
Manage Windows Explorer Settings
Manage and Secure Folders
Share Folders
Back up and Restore Files and Folders

COLLABORATING WITH OTHER PEOPLE
Collaborate in Real Time Present information to an audience

CUSTOMISING YOUR WINDOWS VISTA EXPERIENCE
Customise and Modify the Start Menu
Customise the taskbar
Personalise the Appearance and
Sound of a Computer
Manage the Windows Sidebar

OPTIMISING AND TROUBLESHOOTING YOUR COMPUTER
Increase Processing speed
Locate Trouble shooting and system information
Repair a Network Connection
Recover from Software Errors
Troubleshooting Printing Errors
Recover the Operating System from a problem
Request and Mange Remote Assistance

__________________________________________________________________________