Objective:
Participants will learn how to use the most common office skill such as Ms Word 2003, Ms Excel 2003, Ms Power Point 2003 and Ms Access 2003. Participants must be PC literate and has some basic knowledge of Windows Operationg Systems.
Course Content:
Microsoft Word 2003 Basic and Intermediate
1 Introduction to Word Processing
- Starting Microsoft Word
- What's New in Word 2003?
- Understanding the Word Screen
- Using Menus
- Using Toolbars and Creating a New Document
- Document / Program Management
- Inserting, Deleting, Moving, Selecting and Replacing of Text
2 Working with and Editing Text
- Navigating through a Document
- Viewing a Document
- Working with Multiple Documents and Windows
- Cutting and Pasting Text
- Copying and Pasting Text and Comparing Documents Side by Side
- Finding and Replacing Text
- Collecting and Pasting Multiple Items
- Correcting Your Spelling and Grammar
- Understanding Smart Tags
- Using Thesaurus, Word Count, and Research Pane
- Inserting Symbols and Special Characters
- Using Undo, Redo and Repeat
- Using Click and Type
- Advanced Printing Options
- Recovering Your Documents
3 Formatting Characters and Paragraphs
- 3.1 Formatting Characters Using the Toolbar
- 3.2 Using the Format Painter
- 3.3 Using the Font Dialog Box
- 3.4 Changing Paragraph Alignment
- 3.5 Indenting Paragraphs
- 3.6 Special Indents
- 3.7 Formatting Paragraph Line Spacing
- 3.8 Formatting Spacing between Paragraphs
- 3.9 Creating Bulleted and Numbered Lists
- 3.10 Adding Borders to Your Paragraphs
- 3.11 Adding Shading and Patterns
4 Formatting Pages
- Adjusting Margins
- Creating Headers and Footers
- Changing the Paper Orientation and Size
- Previewing a Document
- Controlling Where the Page Breaks
- Working with Section Breaks and Multiple Page Formats
- Creating and Working with Envelopes
5 Arranging Text in Multiple Columns
6 Working with Tables
- Introduction to Tables
- Creating a Table
- Working with a Table
- Adjusting Column Width
- Adjusting Row Height
- Inserting and Deleting Rows and Columns
- Adding Borders to a Table
- Adding Shading and Patterns
- Using AutoFormat
- Totaling Numbers in a Table
- Sorting Information in a Table
- Creating Table Formulas
- Merging and Splitting Cells
- Orienting, Aligning, and Spacing Cell Contents
- Working with Tables that Span Multiple Pages
- Resizing, Moving, and Positioning a Table
7 Drawing and Working with Graphics
- 7.1 Drawing on Your Documents
- 7.2 Inserting Clipart
- 7.3 Inserting and Formatting Pictures
- 7.4 Positioning Objects
- 7.5 Working with WordArt
Microsoft Excel 2003 Basic and Intermediate
1.Microsoft Excel 2003
- What's New in Excel 2003?
- Understanding the Screen Display
- Workbook Management
- Moving the Cell Pointer
- Navigating a Worksheet
- Entering Labels in a Worksheet
- Using AutoFill
2.Formatting a Worksheet
- Formatting Fonts with the Formatting Toolbar
- Formatting Values
- Adjusting Row Height and Column Width
- Changing Cell Alignment
- Adding Borders
- Applying Colors and Patterns
- Using the Format Painter
- Using AutoFormat
- Creating a Custom Number Format
- Formatting Cells with Conditional Formatting
- Merging Cells, Rotating Text, and using AutoFit
- Finding and Replacing Formatting
3. Managing Workbooks and Worksheets
- Changing the Number or Worksheets in a New Workbook
- Selecting Multiple Worksheets
- Switching Between Sheets in a Workbook
- Gridlines
- Hide/Unhide a Workbook Window
- Hide/Unhide a Sheet
- Inserting and Deleting Worksheets
- Renaming and Moving Worksheets
- Move or Copy Sheets
- Splitting and Freezing a Window
- View Multiple Sheets or Workbooks at the Same Time
- Compare Workbooks Side By Side
4. Perform Calculations
- Expanded Autosum Functionality
- Entering Formulas
- Formula Error Checking
- Name a Cell or a Range Of Cells
- Cell Linking Vs. Data Consolidation
5.Prepare and Print Worksheets
- Adjusting Page Orientation
- Print a Worksheet to Fit a Paper Width or a Number of Pages
- Adjusting Page Margins and Centre Print Out
- Create Headers, Footers & Page Number
- Print With or Without Cell Gridlines
- Adding Print Titles
- Print a Worksheet with Formulas Displayed
- Hiding Columns, Rows, and Sheets
- Print a Selected Area of a Worksheet
6. Create and Manage Charts
- Create a Chart
- Change the Chart Type of an Existing Chart
- Change the Location, Display Size, or Position of a Chart
- Change the Fill, Border, Line Style, or Color of Chart Elements
- Change the 3-D View of a Chart
- Change the Size or Position of an Embedded Chart in the Worksheet
- Add or Remove Pictures in a Chart
Microsoft Power Point 2003 Basic and Intermediate
1.Introduction To Microsoft Powerpoint 2003
- What Is Powerpoint?
- The Powerpoint Environment
- The Different Powerpoint Views
- Toolbars
2. Presentations And Slides
- Creating And Opening Presentations
- Managing Presentations
- Managing Slides
3. Using Master Pages
- Working With Slide Masters
4. Formatting And Editing Slides
- Working With Slide Layouts
- Applying Backgrounds
- Modifying Slide Attributes
- Paragraph Settings
- Bullets And Numbering
5. Formatting And Editing Text
- Adding Text To A Slide
- Formatting Text
- Using Undo And Redo
- Using Spell Check
6. Slide Design
- Working With Slide Design
- Using Design Templates
- Adding Color Schemes
- Applying Animation Schemes
7. Drawings And Pictures
- Drawing Lines And Shapes
- Using Autoshapes
- Adding Clip Art And Pictures
- Grouping And Ungrouping Objects
- Rotating And Flipping Objects
- Aligning Objects
8. Printing
- Using Page Setup
- Using Print Preview
- Printing A Presentation
9. Presenting The Presentation
- Running A Slide Show
- Navigating Slides
- Pointer Options
- Screen Options
- Adding Notes To The Slide Show
Microsoft Access 2003 Basic & Intermediate
1. Introduction To Microsoft Access 2003
- What Is Access?
- What Is Database?
- Creating Files
- Starting Access 2003
- Opening And Closing A Database File
2. The Database Window
- The Database Menu Bar
- The Database Window Toolbar
3. Tables
- Create A Table
- Working With Tables
- Setting A Primary Key
- Establishing Relationships
- Working With Data Types
- Inputmask Property
4. Queries
- Create A Query
- Creating Parameter Queries
- Creating Calculated Columns In Queries
5. Forms
- Using And Creating Forms
- Working With Subforms
6. Reports
- Creating And Using Reports
- Saving, Maintaining, And Printing Reports
|