Microsoft Word 2003 Core

Exam Structure: 17 Questions in 50 Minutes, Pass rate 64%

Exam Objectives as stated by Microsoft

CREATING CONTENT
Insert and edit text, symbols and special characters
Insert frequently used and pre-defined text
Navigate to specific content
Insert, position and size graphics
Create and modify diagrams and charts
Locate, select and insert supporting information

ORGANISING CONTENT
Insert and modify tables
Create bulleted lists, numbered lists and outlines
Insert and modify hyperlinks

FORMATTING CONTENT
Format text
Format paragraphs
Apply and format columns
Insert and modify content in headers and footers
Modify document layout and page setup

COLLABORATING
Circulate documents for review
Compare and merge documents
Insert, view and edit comments
Track, accept and reject proposed changes

FORMATTING AND MANAGING DOCUMENTS
Create new documents using templates
Review and modify document properties
Organize documents using file folders
Save documents in appropriate formats for different uses
Print documents, envelopes and labels
Preview documents and Web pages
Change and organise document views and windows

__________________________________________________________________________

Microsoft Word 2003 Expert

Exam Structure: 16 Questions in 50 Minutes, Pass rate 63%

Exam Objectives as stated by Microsoft

FORMATTING CONTENT
Create custom styles for text, tables and lists
Control pagination
Format, position and resize graphics using advanced layout features
Insert and modify objects
Create and modify diagrams and charts using data from other sources

ORGANISING CONTENT
Sort content in lists and tables
Perform calculations in tables
Modify table formats
Summarise document content using automated tools
Use automated tools for document navigation
Merge letters with other data sources
Merge labels with other data sources
Structure documents using XML

FORMATTING DOCUMENTS
Create and modify forms
Create and modify document background
Create and modify document indexes and tables
Insert and modify endnotes, footnotes, captions, and cross-references
Create and manage master documents and subdocuments

COLLABORATING
Modify track changes options
Publish and edit Web documents
Manage document versions
Protect and restrict forms and documents
Attach digital signatures to documents
Customise document properties

CUSTOMISING WORD
Create, edit, and run macros
Customize menus and toolbars
Modify Word default settings

__________________________________________________________________________

Microsoft Excel 2003 Core

Exam Structure: 18 Questions in 50 Minutes, Pass rate 69%

Exam Objectives as stated by Microsoft

CREATING DATA AND CONTENT
Enter and edit cell content
Navigate to specific cell content
Locate, select and insert supporting information
Insert, position, and size graphics

ANALYSING DATA
Filter lists using AutoFilter
Sort lists
Insert and modify formulas
Use statistical, date and time, financial, and logical functions
Create, modify, and position diagrams and charts based on worksheet data

FORMATTING DATA AND CONTENT
Apply and modify cell formats
Apply and modify cell styles
Modify row and column formats
Format worksheets

COLLABORATING
Insert, view and edit comments

MANAGING WORKBOOKS
Create new workbooks from templates
Insert, delete and move cells
Create and modify hyperlinks
Organize worksheets
Preview data in other views
Customize Window layout
Setup pages for printing
Print data
Organize workbooks using file folders
Save data in appropriate formats for different uses

__________________________________________________________________________

Microsoft Excel 2003 Expert

Exam Structure: 18 Questions in 50 Minutes, Pass rate 63%

Exam Objectives as stated by Microsoft

ORGANISING AND ANALYSING DATA
Use subtotals
Define and apply advanced filters
Group and outline data
Use data validation
Create and modify list ranges
Add, show, close, edit, merge and summarize scenarios
Perform data analysis using automated tools
Create PivotTable and PivotChart reports
Use Lookup and Reference functions
Use Database functions
Trace formula precedents, dependents and errors
Locate invalid data and formulas
Watch and evaluate formulas
Define, modify and use named ranges
Structure workbooks using XML

FORMATTING DATA AND CONTENT
Create and modify custom data formats
Use conditional formatting
Format and resize graphics
Format charts and diagrams

COLLABORATING
Protect cells, worksheets, and workbooks
Apply workbook security settings
Share workbooks
Merge workbooks
Track, accept, and reject changes to workbooks

MANAGING DATA AND WORKBOOKS
Import data to Excel
Export data from Excel
Publish and edit Web worksheets and workbooks
Create and edit templates
Consolidate data
Define and modify workbook properties

CUSTOMISING EXCEL
Customize toolbars and menus
Create, edit, and run macros
Modify Excel default settings

__________________________________________________________________________

Microsoft Outlook 2003 Core

Exam Structure: 19 Questions in 50 Minutes, Pass rate 71%

Exam Objectives as stated by Microsoft

MESSAGING
Organising
Attach files to items
Create and modify a personal signature for messages
Modify e-mail message settings and delivery options
Create and edit contacts
Accept, decline, and delegate tasks

SCHEDULING
Create and modify appointments, meetings, and events
Update, cancel, and respond to meeting requests
Customize Calendar settings
Create, modify, and assign tasks

ORGANISING
Create and modify distribution lists
Link contacts to other items
Create and modify notes
Organize items
Organize items using folders
Search for items
Save items in different file formats
Assign items to categories
Preview and print items

__________________________________________________________________________

Microsoft PowerPoint 2003 Core

Exam Structure: 17 Questions in 50 Minutes
Pass rate 65%

Exam Objectives as stated by Microsoft

CREATING CONTENT
Create new presentations from templates
Insert and edit text-based content
Insert tables, charts and diagrams
Insert pictures, shapes and graphics
Insert objects

FORMATTING CONTENT
Format text-based content
Format pictures, shapes and graphics
Format slides
Apply animation schemes
Apply slide transitions
Customize slide templates
Work with masters

COLLABORATING
Track, accept and reject changes in a presentation
Add, edit and delete comments in a presentation
Compare and merge presentations

MANAGING AND DELIVERING PRESENTATIONS
Organise a presentation
Set up slide shows for delivery
Rehearse timing
Deliver presentations
Prepare presentations for remote delivery
Save and publish presentations
Print slides, outlines, handouts, and speaker notes
Export a presentation to another Microsoft Office programme

__________________________________________________________________________

Microsoft Access 2003 Core

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

Exam Objectives as stated by Microsoft

STRUCTURING DATABASES
Create Access databases
Create and modify tables
Define and modify field types
Modify field properties
Create and modify one-to-many relationships
Enforce referential integrity
Create and modify queries
Create forms
Add and modify form controls and properties
Create reports
Add and modify report control properties
Create a data access page

ENTERING DATA
Enter, edit and delete records
Find and move among records
Import data to Access

ORGANISING DATA
Create and modify calculated fields and aggregate functions
Modify form layout
Modify report layout and page setup
Format datasheets
Sort records
Filter records

MANAGING DATABASES
Identify object dependencies
View objects and object data in other views
Print database objects and data
Export data from Access
Back up a database
Compact and repair databases

__________________________________________________________________________