Welcome | p. vi |
Overview of Office XP | p. vii |
Windows 2000 | |
Exploring Windows 2000 | p. 3 |
Exploring the Windows 2000 Desktop | p. 4 |
Opening and Manipulating Windows | p. 8 |
Exploring the Taskbar | p. 10 |
Features Summary | p. 14 |
Procedures Check | p. 14 |
Skills Review | p. 15 |
Performance Plus | p. 16 |
Internet Explorer 5.5 | |
Browsing the Internet Using Internet Explorer 5.5 | p. 3 |
Browsing the Internet Using Internet Explorer | p. 4 |
Navigating Using Hyperlinks | p. 6 |
Searching for Specific Sites | p. 8 |
Completing Advanced Searches for Specific Sites | p. 10 |
Downloading Images, Text, and Web Pages from the Internet | p. 12 |
Features Summary | p. 14 |
Procedures Check | p. 14 |
Skills Review | p. 15 |
Performance Plus | p. 16 |
Word 2002 | |
Creating and Editing a Document | p. 3 |
Completing the Word Processing Cycle | p. 4 |
Moving the Insertion Point; Inserting, Replacing, and Deleting Text | p. 6 |
Scrolling and Navigating in a Document | p. 8 |
Selecting and Deleting Text; Using Undo and Redo | p. 10 |
Checking the Spelling and Grammar in a Document | p. 12 |
Using AutoCorrect and the Thesaurus | p. 16 |
Using the Help Feature; Highlighting Text | p. 18 |
Previewing and Printing a Document | p. 20 |
Inserting the Date and Time; Closing a Document | p. 22 |
Creating a Document Using a Template | p. 24 |
Managing Documents | p. 26 |
Features Summary | p. 28 |
Procedures Check | p. 28 |
Skills Review | p. 29 |
Performance Plus | p. 31 |
Formatting Characters and Paragraphs | p. 33 |
Applying Fonts and Font Effects Using the Formatting Toolbar | p. 34 |
Changing the Font at the Font Dialog Box; Using the Format Painter | p. 36 |
Applying Effects Using the Font Dialog Box; Repeating a Command | p. 38 |
Aligning Text in Paragraphs | p. 40 |
Indenting Text | p. 42 |
Changing Line and Paragraph Spacing | p. 44 |
Inserting Bullets and Numbering | p. 46 |
Inserting Symbols | p. 48 |
Setting Tabs | p. 50 |
Setting Tabs with Leaders | p. 52 |
Adding Borders and Shading | p. 54 |
Applying Styles and Creating an Outline-Style Numbered List | p. 56 |
Formatting and Enhancing a Document | p. 65 |
Finding and Replacing Text | p. 66 |
Cutting, Copying, and Pasting Text; Using Paste Special | p. 68 |
Using the Clipboard Task Pane | p. 70 |
Inserting a Page Break; Inserting and Modifying Page Numbers | p. 72 |
Changing Margins and Page Orientation | p. 74 |
Changing Views; Using Click and Type; Vertically Aligning Text | p. 76 |
Inserting, Sizing, and Moving Images in a Document | p. 78 |
Inserting, Sizing, and Moving WordArt in a Document | p. 82 |
Using the Drawing Toolbar | p. 84 |
Preparing an Envelope | p. 86 |
Preparing Labels | p. 88 |
Excel 2002 | |
Analyzing Data Using Excel | p. 3 |
Completing the Excel Worksheet Cycle | p. 4 |
Entering Labels and Values; Using the Fill Handle | p. 8 |
Performing Calculations Using Formulas | p. 12 |
Using AutoSum | p. 14 |
Copying Relative Formulas | p. 16 |
Testing the Worksheet; Improving the Appearance of Cells | p. 18 |
Using Help | p. 22 |
Previewing, Printing, and Closing a Workbook | p. 24 |
Navigating a Worksheet | p. 26 |
Features Summary | p. 28 |
Procedures Check | p. 28 |
Skills Review | p. 29 |
Performance Plus | p. 31 |
Editing and Formatting Worksheets | p. 33 |
Editing and Clearing Cells; Performing a Spell Check | p. 34 |
Inserting and Deleting Cells; Using Undo and Redo | p. 36 |
Inserting, Deleting, Hiding, and Unhiding Columns and Rows | p. 38 |
Moving and Copying Cells | p. 40 |
Adjusting Column Width and Row Height | p. 42 |
Freezing and Unfreezing Panes; Changing the Zoom | p. 44 |
Changing the Font, Size, Style, and Color of Cells | p. 46 |
Formatting Numeric Cells; Adjusting Decimal Places | p. 48 |
Changing the Alignment and Indentation of Cells | p. 50 |
Adding Borders and Shading; Autoformatting | p. 52 |
Using Find and Replace | p. 56 |
Using Functions, Setting Print Options, and Adding Visual Elements | p. 65 |
Using Statistical Functions AVERAGE, MAX, and MIN | p. 66 |
Using Date Functions NOW and DATE | p. 68 |
Using Financial Function PMT | p. 70 |
Using Logical Function IF | p. 72 |
Changing Margins; Centering a Worksheet on the Page | p. 74 |
Inserting Headers and Footers | p. 76 |
Printing Headings and Gridlines; Scaling a Worksheet | p. 78 |
Creating a Chart | p. 80 |
Modifying a Chart | p. 84 |
Inserting Pictures | p. 86 |
Drawing Arrows and Text Boxes | p. 88 |
Access 2002 | |
Maintaining Data in Access Tables | p. 3 |
Exploring Database Objects | p. 4 |
Adjusting Column Width; Navigating in Datasheet View | p. 8 |
Finding and Editing Records | p. 10 |
Adding Records in Datasheet View | p. 12 |
Adding Records in Form View | p. 14 |
Deleting Records in Datasheet View | p. 16 |
Sorting Records | p. 18 |
Previewing and Printing | p. 20 |
Formatting the Datasheet | p. 22 |
Using Help | p. 24 |
Compacting and Repairing a Database | p. 26 |
Features Summary | p. 28 |
Procedures Check | p. 28 |
Skills Review | p. 29 |
Performance Plus | p. 30 |
Creating Tables and Relationships | p. 33 |
Creating a Table in Design View | p. 34 |
Using the Lookup Wizard | p. 38 |
Using the Input Mask Wizard | p. 40 |
Validating Field Entries | p. 44 |
Modifying Field Size and Default Value | p. 46 |
Creating a Table Using the Table Wizard | p. 48 |
Creating Relationships | p. 50 |
Creating a Form Using AutoForm | p. 52 |
Creating a New Database Using a Wizard | p. 54 |
Creating Queries, Forms, and Reports | p. 65 |
Creating a Query in Design View | p. 66 |
Using the Simple Query Wizard | p. 68 |
Extracting Records Using Criteria Statements | p. 70 |
Performing Calculations in a Query | p. 72 |
Creating a Parameter Query | p. 74 |
Creating a Form Using the Form Wizard | p. 76 |
Modifying Controls in a Form | p. 80 |
Adding Controls to a Form | p. 82 |
Creating, Previewing, and Printing a Report | p. 84 |
Resizing Controls in a Report | p. 88 |
Powerpoint 2002 | |
Preparing a Presentation | p. 3 |
Completing the Presentation Cycle | p. 4 |
Choosing a Design Template, Creating Slides, and Closing a Presentation | p. 8 |
Opening, Navigating, and Inserting Slides in a Presentation | p. 12 |
Changing Views; Choosing a Slide Layout | p. 14 |
Changing the Slide Layout; Selecting and Moving a Placeholder | p. 16 |
Using Help; Checking Spelling | p. 18 |
Running a Presentation | p. 20 |
Using the Pen When Running a Presentation | p. 22 |
Adding Transition and Sound | p. 24 |
Printing and Previewing a Presentation | p. 26 |
Features Summary | p. 28 |
Procedures Check | p. 28 |
Skills Review | p. 29 |
Performance Plus | p. 30 |
Editing Slides and Slide Elements | p. 33 |
Rearranging and Deleting Slides | p. 34 |
Increasing and Decreasing Indents | p. 36 |
Selecting, Cutting, Copying, and Pasting Text | p. 38 |
Applying Font Effects Using the Formatting Toolbar | p. 40 |
Changing the Font Using Buttons on the Formatting Toolbar | p. 42 |
Changing the Font at the Font Dialog Box; Replacing Fonts | p. 44 |
Formatting with Format Painter | p. 46 |
Changing Alignment and Line and Character Spacing | p. 48 |
Changing the Slide Design and Color Scheme | p. 50 |
Inserting, Sizing, and Moving an Image | p. 52 |
Inserting and Recoloring Clip Art Images | p. 54 |
Applying an Animation Scheme | p. 56 |
Integrated Programs | |
Integrating Word, Excel, Access, and PowerPoint | p. 1 |
Exporting Access Data to Excel | p. 2 |
Exporting an Access Report to Word | p. 4 |
Importing Data to a New Table | p. 6 |
Exporting a PowerPoint Presentation to Word | p. 8 |
Exporting a Word Outline to a PowerPoint Presentation | p. 10 |
Linking an Excel Chart with a Word Document and a PowerPoint Presentation | p. 12 |
Editing a Linked Object | p. 14 |
Embedding and Editing a Word Table in a PowerPoint Slide | p. 16 |
Linking Data to a New Table and Editing Linked Data | p. 18 |
Embedding an Excel Worksheet into a Word Document | p. 22 |
Editing an Embedded Worksheet | p. 24 |
Skills Review | p. 26 |
Index | p. 29 |
Table of Contents provided by Syndetics. All Rights Reserved. |