| Microsoft Word 2002 Core MOUS Skills |
|
vi | |
| Microsoft Excel 2002 Core MOUS Skills |
|
vi | |
| Microsoft Access 2002 Core MOUS Skills |
|
vii | |
| Microsoft PowerPoint 2002 Comprehensive MOUS Skills |
|
vii | |
| Welcome |
|
viii | |
| WINDOWS 2000 |
|
|
|
|
3 | (14) |
|
Exploring the Windows 2000 Desktop |
|
|
4 | (4) |
|
Opening and Manipulating Windows |
|
|
8 | (2) |
|
|
|
10 | (7) |
|
|
|
14 | (1) |
|
|
|
|
|
|
15 | (1) |
|
|
|
16 | (1) |
|
Maintaining Files and Customizing Windows |
|
|
17 | |
|
Getting Help in Windows 2000 |
|
|
18 | (4) |
|
|
|
22 | (2) |
|
Selecting and Copying Files |
|
|
24 | (2) |
|
|
|
26 | (2) |
|
Deleting Files/Folders to the Recycle Bin |
|
|
28 | (2) |
|
Restoring Files/Folders and Emptying Files from the Recycle Bin |
|
|
30 | (2) |
|
Creating and Deleting a Shortcut |
|
|
32 | (2) |
|
Exploring the Control Panel |
|
|
34 | (2) |
|
Searching for a File or Folder |
|
|
36 | (2) |
|
|
|
38 | (2) |
|
|
|
40 | |
|
|
|
42 | (1) |
|
|
|
43 | (1) |
|
|
|
44 | (3) |
|
|
|
47 | |
|
|
|
16 | |
| INTERNET EXPLORER 5.5 |
|
|
Browsing the Internet Using Internet Explorer 5.5 |
|
|
3 | (1) |
|
Browsing the Internet Using Internet Explorer |
|
|
4 | (2) |
|
Navigating Using Hyperlinks |
|
|
6 | (2) |
|
Searching for Specific Sites |
|
|
8 | (2) |
|
Completing Advanced Searches for Specific Sites |
|
|
10 | (2) |
|
Downloading Images, Text, and Web Pages from the Internet |
|
|
12 | |
|
|
|
14 | (1) |
|
|
|
14 | (1) |
|
|
|
15 | (1) |
|
|
|
16 | (1) |
|
|
|
16 | |
| OFFICE |
|
|
Introducing Microsoft Office XP |
|
|
1 | (1) |
|
|
|
2 | (2) |
|
Preparing Documents Using Word 2002 |
|
|
4 | (2) |
|
Preparing Workbooks and Analyzing Data Using Excel 2002 |
|
|
6 | (2) |
|
Managing Data Using Access 2002 |
|
|
8 | (2) |
|
Preparing Presentations Using PowerPoint 2002 |
|
|
10 | (2) |
|
Managing E-Mail, Contacts, and Schedules Using Outlook 2002 |
|
|
12 | (2) |
|
Integrating Data in Office XP |
|
|
14 | |
|
|
|
16 | |
| WORD 2002 |
|
|
Creating and Editing a Document |
|
|
3 | (30) |
|
Completing the Word Processing Cycle |
|
|
4 | (2) |
|
Moving the Insertion Point; Inserting, Replacing, and Deleting Text |
|
|
6 | (2) |
|
Scrolling and Navigating in a Document |
|
|
8 | (2) |
|
Selecting and Deleting Text; Using Undo and Redo |
|
|
10 | (2) |
|
Checking the Spelling and Grammar in a Document |
|
|
12 | (4) |
|
Using AutoCorrect and the Thesaurus |
|
|
16 | (2) |
|
Using the Help Feature; Highlighting Text |
|
|
18 | (2) |
|
Previewing and Printing a Document |
|
|
20 | (2) |
|
Inserting the Date and Time; Closing a Document |
|
|
22 | (2) |
|
Creating a Document Using a Template |
|
|
24 | (2) |
|
|
|
26 | (7) |
|
|
|
28 | (1) |
|
|
|
28 | (1) |
|
|
|
29 | (2) |
|
|
|
31 | (2) |
|
*These elements appear at the end of each section |
|
|
|
Formatting Characters and Paragraphs |
|
|
33 | (32) |
|
Applying Fonts and Font Effects Using the Formatting Toolbar |
|
|
34 | (2) |
|
Changing the Font at the Font Dialog Box; Using the Format Painter |
|
|
36 | (2) |
|
Applying Effects Using the Font Dialog Box; Repeating a Command |
|
|
38 | (2) |
|
Aligning Text in Paragraphs |
|
|
40 | (2) |
|
|
|
42 | (2) |
|
Changing Line and Paragraph Spacing |
|
|
44 | (2) |
|
Inserting Bullets and Numbering |
|
|
46 | (2) |
|
|
|
48 | (2) |
|
|
|
50 | (2) |
|
Setting Tabs with Leaders |
|
|
52 | (2) |
|
Adding Borders and Shading |
|
|
54 | (2) |
|
Applying Styles and Creating an Outline-Style Numbered List |
|
|
56 | (9) |
|
Formatting and Enhancing a Document |
|
|
65 | (32) |
|
Finding and Replacing Text |
|
|
66 | (2) |
|
Cutting, Copying, and Pasting Text; Using Paste Special |
|
|
68 | (2) |
|
Using the Clipboard Task Pane |
|
|
70 | (2) |
|
Inserting a Page Break; Inserting and Modifying Page Numbers |
|
|
72 | (2) |
|
Changing Margins and Page Orientation |
|
|
74 | (2) |
|
Changing Views; Using Click and Type; Vertically Aligning Text |
|
|
76 | (2) |
|
Inserting, Sizing, and Moving Images in a Document |
|
|
78 | (4) |
|
Inserting, Sizing, and Moving WordArt in a Document |
|
|
82 | (2) |
|
Using the Drawing Toolbar |
|
|
84 | (2) |
|
|
|
86 | (2) |
|
|
|
88 | (9) |
|
Formatting with Special Features |
|
|
97 | |
|
|
|
98 | (2) |
|
|
|
100 | (2) |
|
Changing Column Widths and Row Heights; Moving a Table |
|
|
102 | (2) |
|
|
|
104 | (2) |
|
Applying Borders and Shading to a Table; Applying AutoFormats |
|
|
106 | (2) |
|
Inserting a Section Break; Creating Newspaper Columns |
|
|
108 | (2) |
|
Revising Column Structure |
|
|
110 | (2) |
|
Inserting a Header or Footer |
|
|
112 | (2) |
|
Modifying a Header or Footer |
|
|
114 | (2) |
|
Saving a Document as a Web Page; Creating a Hyperlink; Using Web Page Preview |
|
|
116 | (2) |
|
Comparing and Merging Documents |
|
|
118 | (2) |
|
Creating Diagrams and Organizational Charts |
|
|
120 | |
|
|
|
128 | |
| EXCEL 2002 |
|
|
Analyzing Data Using Excel |
|
|
3 | (30) |
|
Completing the Excel Worksheet Cycle |
|
|
4 | (4) |
|
Entering Labels and Values; Using the Fill Handle |
|
|
8 | (4) |
|
Performing Calculations Using Formulas |
|
|
12 | (2) |
|
|
|
14 | (2) |
|
Copying Relative Formulas |
|
|
16 | (2) |
|
Testing the Worksheet; Improving the Appearance of Cells |
|
|
18 | (4) |
|
|
|
22 | (2) |
|
Previewing, Printing, and Closing a Workbook |
|
|
24 | (2) |
|
|
|
26 | (7) |
|
|
|
28 | (1) |
|
|
|
28 | (1) |
|
|
|
29 | (2) |
|
|
|
31 | (2) |
|
*These elements appear at the end of each section |
|
|
|
Editing and Formatting Worksheets |
|
|
33 | (32) |
|
Editing and Clearing Cells; Performing a Spell Check |
|
|
34 | (2) |
|
Inserting and Deleting Cells; Using Undo and Redo |
|
|
36 | (2) |
|
Inserting, Deleting, Hiding, and Unhiding Columns and Rows |
|
|
38 | (2) |
|
|
|
40 | (2) |
|
Adjusting Column Width and Row Height |
|
|
42 | (2) |
|
Freezing and Unfreezing Panes; Changing the Zoom |
|
|
44 | (2) |
|
Changing the Font, Size, Style, and Color of Cells |
|
|
46 | (2) |
|
Formatting Numeric Cells; Adjusting Decimal Places |
|
|
48 | (2) |
|
Changing the Alignment and Indentation of Cells |
|
|
50 | (2) |
|
Adding Borders and Shading; Autoformatting |
|
|
52 | (4) |
|
|
|
56 | (9) |
|
Using Functions, Setting Print Options, and Adding Visual Elements |
|
|
65 | (32) |
|
Using Statistical Functions AVERAGE, MAX, and MIN |
|
|
66 | (2) |
|
Using Date Functions NOW and DATE |
|
|
68 | (2) |
|
Using Financial Function PMT |
|
|
70 | (2) |
|
Using Logical Function IF |
|
|
72 | (2) |
|
Changing Margins; Centering a Worksheet on the Page |
|
|
74 | (2) |
|
Inserting Headers and Footers |
|
|
76 | (2) |
|
Printing Headings and Gridlines; Scaling a Worksheet |
|
|
78 | (2) |
|
|
|
80 | (4) |
|
|
|
84 | (2) |
|
|
|
86 | (2) |
|
Drawing Arrows and Text Boxes |
|
|
88 | (9) |
|
Working with Multiple Worksheets and Managing Files |
|
|
97 | |
|
Inserting, Deleting, and Renaming a Worksheet |
|
|
98 | (2) |
|
Moving and Copying a Worksheet |
|
|
100 | (3) |
|
Linking Worksheets; Using 3-D References; Formatting Sheet Tabs |
|
|
103 | (3) |
|
Printing Multiple Worksheets; Setting the Print Area |
|
|
106 | (2) |
|
Creating a Workbook from a Template |
|
|
108 | (2) |
|
|
|
110 | (2) |
|
Creating a Web Page from a Worksheet; inserting and Editing Hyperlinks |
|
|
112 | (2) |
|
Filtering Lists Using AutoFilter |
|
|
114 | (2) |
|
Locating a Workbook; Creating a New Folder |
|
|
116 | (2) |
|
Inserting and Editing Comments |
|
|
118 | (2) |
|
Creating and Responding to Discussion Comments |
|
|
120 | |
|
Integrated 1: Integrating Word and Excel |
|
|
129 | (1) |
|
Copying and Pasting Word Data into an Excel Worksheet |
|
|
130 | (2) |
|
Linking an Excel Worksheet with a Word Document |
|
|
132 | (2) |
|
Updating Linked Data; Viewing a Link |
|
|
134 | (2) |
|
Linking an Excel Chart with a Word Document |
|
|
136 | (2) |
|
Embedding an Excel Worksheet into a Word Document |
|
|
138 | (2) |
|
Editing an Embedded Worksheet |
|
|
140 | (2) |
|
|
|
142 | (2) |
|
|
|
144 | |
| ACCESS 2002 |
|
|
Maintaining Data in Access Tables |
|
|
3 | (30) |
|
Exploring Database Objects |
|
|
4 | (4) |
|
Adjusting Column Width; Navigating in Datasheet View |
|
|
8 | (2) |
|
Finding and Editing Records |
|
|
10 | (2) |
|
Adding Records in Datasheet View |
|
|
12 | (2) |
|
Adding Records in Form View |
|
|
14 | (2) |
|
Deleting Records in Datasheet View |
|
|
16 | (2) |
|
|
|
18 | (2) |
|
|
|
20 | (2) |
|
|
|
22 | (2) |
|
|
|
24 | (2) |
|
Compacting and Repairing a Database |
|
|
26 | (7) |
|
|
|
28 | (1) |
|
|
|
28 | (1) |
|
|
|
29 | (1) |
|
|
|
30 | (3) |
|
*These elements appear at the end of each section |
|
|
|
Creating Tables and Relationships |
|
|
33 | (32) |
|
Creating a Table in Design View |
|
|
34 | (4) |
|
|
|
38 | (2) |
|
Using the Input Mask Wizard |
|
|
40 | (4) |
|
|
|
44 | (2) |
|
Modifying Field Size and Default Value |
|
|
46 | (2) |
|
Creating a Table Using the Table Wizard |
|
|
48 | (2) |
|
|
|
50 | (2) |
|
Creating a Form Using AutoForm |
|
|
52 | (2) |
|
Creating a New Database Using a Wizard |
|
|
54 | (11) |
|
Creating Queries, Forms, and Reports |
|
|
65 | (32) |
|
Creating a Query in Design View |
|
|
66 | (2) |
|
Using the Simple Query Wizard |
|
|
68 | (2) |
|
Extracting Records Using Criteria Statements |
|
|
70 | (2) |
|
Performing Calculations in a Query |
|
|
72 | (2) |
|
Creating a Parameter Query |
|
|
74 | (2) |
|
Creating a Form Using the Form Wizard |
|
|
76 | (4) |
|
Modifying Controls in a Form |
|
|
80 | (2) |
|
Adding Controls to a Form |
|
|
82 | (2) |
|
Creating, Previewing, and Printing a Report |
|
|
84 | (4) |
|
Resizing Controls in a Report |
|
|
88 | (9) |
|
Modifying Tables and Reports, Performing Calculations, and Viewing Data |
|
|
97 | |
|
|
|
98 | (2) |
|
Inserting and Deleting Fields |
|
|
100 | (2) |
|
Modifying Field Properties |
|
|
102 | (2) |
|
Adding a Calculated Control to a Form |
|
|
104 | (2) |
|
Modifying a Report; Creating a Calculated Control |
|
|
106 | (4) |
|
|
|
110 | (2) |
|
Displaying Records in a Subdatasheet |
|
|
112 | (2) |
|
Applying and Removing Filters |
|
|
114 | (2) |
|
Creating Data Access Pages |
|
|
116 | (4) |
|
|
|
120 | |
|
Integrated 2: Integrating Word, Excel, and Access |
|
|
129 | (1) |
|
Exporting Access Data to Excel |
|
|
130 | (2) |
|
Exporting Access Data to Word |
|
|
132 | (2) |
|
Exporting an Access Report to Word |
|
|
134 | (2) |
|
Importing Data to a New Table |
|
|
136 | (2) |
|
Linking Data to a New Table and Editing Linked Data |
|
|
138 | (4) |
|
|
|
142 | (2) |
|
|
|
144 | |
| POWERPOINT 2002 |
|
|
|
|
3 | (30) |
|
Completing the Presentation Cycle |
|
|
4 | (4) |
|
Choosing a Design Template, Creating Slides, and Closing a Presentation |
|
|
8 | (4) |
|
Opening, Navigating, and Inserting Slides in a Presentation |
|
|
12 | (2) |
|
Changing Views; Choosing a Slide Layout |
|
|
14 | (2) |
|
Changing the Slide Layout; Selecting and Moving a Placeholder |
|
|
16 | (2) |
|
Using Help; Checking Spelling |
|
|
18 | (2) |
|
|
|
20 | (2) |
|
Using the Pen When Running a Presentation |
|
|
22 | (2) |
|
Adding Transition and Sound |
|
|
24 | (2) |
|
Printing and Previewing a Presentation |
|
|
26 | (7) |
|
|
|
28 | (1) |
|
|
|
28 | (1) |
|
|
|
29 | (1) |
|
|
|
30 | (3) |
|
*These elements appear at the end of each section |
|
|
|
Editing Slides and Slide Elements |
|
|
33 | (32) |
|
Rearranging and Deleting Slides |
|
|
34 | (2) |
|
Increasing and Decreasing Indents |
|
|
36 | (2) |
|
Selecting, Cutting, Copying, and Pasting Text |
|
|
38 | (2) |
|
Applying Font Effects Using the Formatting Toolbar |
|
|
40 | (2) |
|
Changing the Font Using Buttons on the Formatting Toolbar |
|
|
42 | (2) |
|
Changing the Font at the Font Dialog Box; Replacing Fonts |
|
|
44 | (2) |
|
Formatting with Format Painter |
|
|
46 | (2) |
|
Changing Alignment and Line and Character Spacing |
|
|
48 | (2) |
|
Changing the Slide Design and Color Scheme |
|
|
50 | (2) |
|
Inserting, Sizing, and Moving an Image |
|
|
52 | (2) |
|
Inserting and Recoloring Clip Art Images |
|
|
54 | (2) |
|
Applying an Animation Scheme |
|
|
56 | (9) |
|
Formatting and Enhancing a Presentation |
|
|
65 | |
|
Using the Clipboard Task Pane |
|
|
66 | (2) |
|
Finding and Replacing Text |
|
|
68 | (2) |
|
Formatting with a Slide Master |
|
|
70 | (2) |
|
Formatting with a Title Master Slide |
|
|
72 | (2) |
|
Inserting and Formatting WordArt |
|
|
74 | (2) |
|
Drawing and Customizing an Autoshape and a Text Box |
|
|
76 | (2) |
|
Copying and Rotating Shapes |
|
|
78 | (2) |
|
Creating a Table in a Slide |
|
|
80 | (2) |
|
|
|
82 | (2) |
|
Creating an Organizational Chart |
|
|
84 | (2) |
|
Inserting Headers and Footers |
|
|
86 | (2) |
|
Creating a Hyperlink; Publishing a Presentation to the Web |
|
|
88 | (10) |
|
Customizing and Managing a Presentation |
|
|
|
Applying More than One Design Template; Managing Multiple Slide Masters; Inserting a Bitmap Image |
|
|
98 | (4) |
|
Customizing and Formatting a Table |
|
|
102 | (2) |
|
|
|
104 | (2) |
|
Sending a Presentation for Review; Editing a Presentation Sent for Review |
|
|
106 | (4) |
|
Accepting/Rejecting Changes from Reviewers |
|
|
110 | (2) |
|
Setting and Rehearsing Timings for a Presentation |
|
|
112 | (2) |
|
Inserting and Printing Comments |
|
|
114 | (2) |
|
Creating a Folder; Saving a Presentation in Outline/RTF Format |
|
|
116 | (2) |
|
Embedding Fonts; Using the Pack and Go Wizard |
|
|
118 | (2) |
|
Publishing a Presentation to the Web; Broadcasting a Presentation Online |
|
|
120 | |
|
Integrated 3: Integrating Word, Excel, and PowerPoint |
|
|
129 | (1) |
|
Exporting a PowerPoint Presentation to Word |
|
|
130 | (2) |
|
Exporting a Word Outline to a PowerPoint Presentation |
|
|
132 | (2) |
|
Linking an Excel Chart with a Word Document and a PowerPoint Presentation |
|
|
134 | (2) |
|
|
|
136 | (2) |
|
Embedding a Word Table in a PowerPoint Presentation |
|
|
138 | (2) |
|
Embedding and Editing a Word Table in a PowerPoint Slide |
|
|
140 | (4) |
|
|
|
144 | |
| OUTLOOK 2002 |
|
|
|
|
3 | (1) |
|
Creating and Sending an E-Mail Message |
|
|
4 | (2) |
|
Replaying to, Printing, and Deleting Messages |
|
|
6 | (2) |
|
Scheduling Appointments and Events |
|
|
8 | (2) |
|
Scheduling Recurring Appointments; Changing the View |
|
|
10 | (2) |
|
Editing and Moving Appointments |
|
|
12 | (2) |
|
|
|
14 | (2) |
|
Editing, Deleting, and Printing Contacts |
|
|
16 | (2) |
|
|
|
18 | (2) |
|
Adding a Recurring Task; Updating Tasks |
|
|
20 | (2) |
|
Using and Customizing Outlook Today |
|
|
22 | (2) |
|
Saving a Calendar as a Web Page |
|
|
24 | (2) |
|
Integrating Contacts with the Calendar |
|
|
26 | (6) |
|
|
|
28 | (1) |
|
|
|
28 | (1) |
|
|
|
29 | (1) |
|
|
|
30 | (2) |
|
|
|
32 | |