Microsoft Office Xp

by Shelly, Gary B.; Cashman, Thomas J.; Vermaat, Misty E.

• ISBN13: 9780789563934
• ISBN10: 0789563932
• Format: Spiral Bound
• Copyright: 2001-07-25
• Publisher: Cengage Learning

Summary

Part of the highly successful Shelly Cashman Series, Microsoft Office XP Introductory Concepts and Techniques provides step-by-step instructions accompanied by full-color screen shots, helping students learn basic Office XP skills quickly and easily.

Table of Contents

Essential Introduction to Computers
Objectives	1	(1)
What Is a Computer?	2	(1)
What Does a Computer Do?	3	(1)
Why Is a Computer So Powerful?	3	(1)
How Does a Computer Know What to Do?	3	(1)
What Are the Components of a Computer?	4	(1)
Input Devices	4	(2)
The Keyboard	4	(1)
The Mouse	5	(1)
The Central Processing Unit	6	(1)
Memory	6	(1)
Output Devices	6	(2)
Printers	6	(2)
Computer Screens	8	(1)
Storage Devices	8	(4)
Floppy Disks	8	(2)
Hard Disks	10	(1)
Compact Discs	10	(1)
CD-ROMs	11	(1)
CD-R and CD-RW	11	(1)
DVD-ROMs	11	(1)
Computer Software	12	(2)
System Software	12	(1)
Application Software	12	(2)
Networks and the Internet	14	(3)
The Internet	14	(1)
The World Wide Web	15	(1)
Electronic Commerce	15	(2)
How to Purchase a Desktop Computer	17	(5)
How to Purchase a Notebook Computer	22	(2)
How to Purchase a Handheld Computer	24	(2)
How to Install a Personal Computer	26	(3)
How to Maintain a Personal Computer	29	(2)
Learn It Online	31	(1)
Index	32	(1)
Photo Credits	32
Microsoft Windows 2000 and Office XP
1 PROJECT ONE
An Introduction to Windows 2000 Professional and Office XP
Objectives	1	(3)
Introduction	4	(1)
What Is Microsoft Windows 2000 Professional?	5	(4)
What Is a User Interface?	5	(1)
Launching Microsoft Windows 2000 Professional	6	(2)
Closing the Getting Started with Windows 2000 Dialog Box	8	(1)
The Desktop as a Work Area	9	(1)
Communicating with Microsoft Windows 2000	9	(18)
Mouse Operations	9	(1)
Point and Click	9	(3)
Right-Click	12	(1)
Double-Click	13	(1)
My Computer Window	14	(1)
Minimize Button	15	(1)
Maximize and Restore Down Buttons	16	(2)
Close Button	18	(2)
Drag	20	(1)
Sizing a Window by Dragging	21	(2)
Scrolling in a Window	23	(2)
Resizing a Window	25	(1)
Closing a Window	25	(1)
Right-Drag	25	(2)
Summary of Mouse and Windows Operations	27	(1)
The Keyboard and Keyboard Shortcuts	27	(1)
Launching an Application Program	28	(3)
Launching an Application Using the Start Button	28	(2)
Quitting a Program	30	(1)
Windows Explorer	31	(7)
Starting Windows Explorer and Maximizing Its Window	31	(1)
The Exploring Window	32	(2)
Displaying the Contents of a Folder	34	(1)
Expanding a Folder	35	(2)
Collapsing a Folder	37	(1)
Copying Files to a Folder on a Floppy Disk	38	(12)
Creating a New Folder	38	(3)
Displaying the Destination Folder	41	(1)
Displaying the Contents of the WINNT Folder	42	(2)
Selecting a Group of Files	44	(2)
Copying a Group of Files	46	(1)
Displaying the Contents of the My Files Folder	47	(1)
Renaming a File or Folder	48	(2)
Deleting a File or Folder	50	(3)
Deleting a File by Right-Clicking Its File Name	50	(2)
Deleting a Folder	52	(1)
Quitting Windows Explorer	53	(1)
Using Windows Help	53	(8)
Contents Sheet	53	(4)
Index Sheet	57	(2)
Shutting Down Windows 2000	59	(2)
What Is Microsoft Office XP?	61	(1)
The Internet, World Wide Web, and Intranets	62	(1)
Microsoft Office XP and the Internet	62	(1)
Microsoft Word 2002	62	(2)
Microsoft Word 2002 and the Internet	63	(1)
Microsoft Excel 2002	64	(2)
Microsoft Excel 2002 and the Internet	64	(2)
Microsoft Access 2002	66	(1)
Microsoft Access 2002 and the Internet	66	(1)
Microsoft PowerPoint 2002	67	(2)
Microsoft PowerPoint 2002 and the Internet	68	(1)
The Web Toolbar	69	(1)
Microsoft Publisher 2002	70	(1)
Microsoft Publisher and the Internet	71	(1)
Microsoft FrontPage 2002	71	(1)
Microsoft Outlook 2002	72	(2)
The Microsoft Office XP Help System	74	(1)
Project Summary	75	(1)
What You Should Know	75	(1)
Learn It Online	76	(1)
In the Lab	77
Microsoft Word 2002
1 PROJECT ONE
Creating and Editing a Word Document
Objectives	3	(3)
What Is Microsoft Word?	6	(1)
Project One --- Hidden Lake Announcement	6	(1)
Starting and Customizing Word	7	(5)
The Word Window	12	(7)
Document Window	12	(2)
Menu Bar and Toolbars	14	(3)
Resetting Menus and Toolbars	17	(1)
Speech Recognition and Handwriting Recognition	17	(1)
Zooming Page Width	18	(1)
Changing the Default Font Size	19	(2)
Entering Text	21	(8)
Entering Blank Lines into a Document	23	(1)
Displaying Formatting Marks	23	(1)
Entering More Text	24	(1)
Using Wordwrap	25	(1)
Entering Text that Scrolls the Document Window	26	(1)
Checking Spelling as You Type	27	(2)
Saving a Document	29	(3)
Formatting Paragraphs and Characters in a Document	32	(14)
Selecting and Formatting Paragraphs and Characters	33	(1)
Selecting Multiple Paragraphs	33	(1)
Changing the Font Size of Selected Text	34	(2)
Changing the Font of Selected Text	36	(1)
Right-Align a Paragraph	36	(2)
Center a Paragraph	38	(1)
Undoing Commands or Actions	38	(1)
Selecting a Line and Formatting It	39	(2)
Italicize Selected Text	41	(1)
Scrolling	41	(1)
Selecting a Word	42	(1)
Underlining Selected Text	43	(1)
Selecting a Group of Words	44	(1)
Bold Selected Text	44	(2)
Inserting Clip Art into a Word Document	46	(7)
Inserting Clip Art	46	(4)
Resizing a Graphic	50	(3)
Saving an Existing Document with the Same File Name	53	(1)
Printing a Document	54	(1)
Quitting Word	55	(1)
Opening a Document	55	(2)
Correcting Errors	57	(2)
Types of Changes Made to Documents	57	(1)
Inserting Text into an Existing Document	58	(1)
Deleting Text from an Existing Document	58	(1)
Closing the Entire Document	58	(1)
Word Help System	59	(3)
Obtaining Help Using the Ask a Question Box on the Menu Bar	59	(3)
Project Summary	62	(1)
What You Should Know	62	(1)
Learn It Online	63	(1)
Apply Your Knowledge	64	(2)
In the Lab	66	(4)
Cases and Places	70
2 PROJECT TWO
Creating a Research Paper
Objectives	1	(3)
Introduction	4	(1)
Project Two --- E-Retailing Research Paper	4	(3)
MLA Documentation Style	6	(1)
Starting Word	6	(1)
Resetting Menus and Toolbars	7	(1)
Displaying Formatting Marks	7	(1)
Changing the Margins	7	(3)
Zooming Page Width	9	(1)
Adjusting Line Spacing	10	(1)
Using a Header to Number Pages	11	(4)
Headers and Footers	11	(2)
Entering Text Using Click and Type	13	(1)
Entering a Page Number into the Header	14	(1)
Typing the Body of the Research Paper	15	(19)
Applying Formatting Using Shortcut Keys	16	(2)
Saving the Research Paper	18	(1)
Indenting Paragraphs	18	(2)
Using Word's AutoCorrect Feature	20	(4)
Adding Footnotes	24	(3)
Modifying a Style	27	(5)
Using Word Count	32	(1)
Automatic Page Breaks	33	(1)
Recounting Words in a Document	34	(1)
Creating an Alphabetical Works Cited Page	34	(8)
Manual Page Breaks	35	(1)
Centering the Title of the Works Cited Page	36	(1)
Creating a Hanging Indent	36	(2)
Inserting Arrows, Faces, and Other Symbols Automatically	38	(1)
Creating a Hyperlink	39	(2)
Sorting Paragraphs	41	(1)
Proofing and Revising the Research Paper	42	(11)
Going to a Specific Location in a Document	42	(2)
Moving Text	44	(3)
Smart Tags	47	(1)
Finding and Replacing Text	48	(1)
Finding Text	49	(1)
Finding a Synonym	50	(1)
Checking Spelling and Grammar At Once	50	(2)
Saving Again and Printing the Document	52	(1)
Navigating to a Hyperlink	53	(1)
E-Mailing a Copy of the Research Paper	54	(1)
Project Summary	55	(1)
What You Should Know	55	(1)
Learn It Online	56	(1)
Apply Your Knowledge	57	(1)
In the Lab	58	(6)
Cases and Places	64
3 PROJECT THREE
Creating a Resume Using a Wizard and a Cover Letter with a Table
Objectives	01	(3)
Introduction	04	(1)
Project Three --- Resume and Cover Letter	05	(3)
Starting Word	06	(1)
Resetting Menus and Toolbars	07	(1)
Displaying Formatting Marks	07	(1)
Using Word's Resume Wizard to Create a Resume	08	(8)
Personalizing the Resume	16	(11)
Tables	16	(1)
Zooming Text Width	17	(1)
Styles	18	(1)
Selecting and Replacing Text	19	(2)
Entering a Line Break	21	(1)
AutoFormat As You Type	22	(3)
Viewing and Printing the Resume in Print Preview	25	(1)
Saving the Resume	26	(1)
Creating a Letterhead	27	(14)
Opening a New Document Window	27	(1)
Adding Color to Characters	28	(2)
Setting Tab Stops Using the Tabs Dialog Box	30	(2)
Collecting and Pasting	32	(5)
Adding a Bottom Border to a Paragraph	37	(1)
Clearing Formatting	38	(3)
Creating a Cover Letter	41	(16)
Components of a Business Letter	41	(1)
Saving the Cover Letter with a New File Name	41	(1)
Setting Tab Stops Using the Ruler	42	(1)
Inserting the Current Date into a Document	43	(1)
Creating an AutoText Entry	44	(2)
Entering a Nonbreaking Space	46	(1)
Inserting an AutoText Entry	47	(2)
Creating a Table with the Insert Table Button	49	(1)
Entering Data into a Word Table	50	(1)
Resizing Table Columns	51	(2)
Changing the Table Alignment	53	(1)
Bulleting a List	54	(3)
Saving Again and Printing the Cover Letter	57	(1)
Addressing and Printing Envelopes and Mailing Labels	57	(1)
Smart Tags	58	(3)
Project Summary	61	(1)
What You Should Know	61	(1)
Learn It Online	62	(1)
Apply Your Knowledge	63	(1)
In the Lab	64	(2)
Cases and Places	66
WEB FEATURE
Creating Web Pages Using Word
Introduction	01	(2)
Saving a Word Document as a Web Page	03	(1)
Formatting the E-Mail Address as a Hyperlink	04	(1)
Using Word's Web Page Wizard to Create a Web Page	04	(4)
Modifying a Web Page	08	(6)
Viewing the Web Page in Your Default Browser	11	(1)
Editing a Web Page from Your Browser	12	(2)
Web Feature Summary	14	(1)
In the Lab	14
Microsoft Excel 2002
1 PROJECT ONE
Creating a Worksheet and Embedded Chart
Objectives	03	(3)
What Is Microsoft Excel?	06	(1)
Project One --- Dynamite Music Fourth Quarter Sales	06	(1)
Starting and Customizing Excel	07	(3)
The Excel Worksheet	10	(2)
The Worksheet	11	(1)
Worksheet Window	12	(4)
Menu Bar	12	(1)
Standard Toolbar and Formatting Toolbar	13	(2)
Formula Bar	15	(1)
Status Bar	15	(1)
Speech Recognition and Speech Playback	16	(1)
Selecting a Cell	16	(1)
Entering Text	16	(5)
Entering the Worksheet Titles	17	(2)
Correcting a Mistake While Typing	19	(1)
AutoCorrect	19	(1)
Entering Column Titles	19	(1)
Entering Row Titles	20	(1)
Entering Numbers	21	(2)
Calculating a Sum	23	(1)
Using the Fill Handle to Copy a Cell to Adjacent Cells	24	(4)
Determining Row Totals	26	(2)
Formatting the Worksheet	28	(7)
Fonts, Font Color, Font Size, and Font Style	29	(1)
Bolding a Cell	29	(1)
Increasing the Font Size	29	(1)
Changing the Font Color of a Cell	30	(1)
Centering the Worksheet Title across Columns	31	(1)
Formatting the Worksheet Subtitle	32	(1)
Using AutoFormat to Format the Body of a Worksheet	33	(2)
Using the Name Box to Select a Cell	35	(2)
Adding a 3-D Column Chart to the Worksheet	37	(3)
Saving a Workbook	40	(4)
Printing a Worksheet	44	(1)
Quitting Excel	45	(1)
Starting Excel and Opening a Workbook	46	(1)
AutoCalculate	47	(2)
Correcting Errors	49	(3)
Correcting Errors While You Are Typing Data into a Cell	49	(1)
In-Cell Editing	49	(1)
Undoing the Last Entry	50	(1)
Clearing a Cell or Range of Cells	51	(1)
Clearing the Entire Worksheet	51	(1)
Excel Help System	52	(3)
Obtaining Help Using the Ask a Question Box on the Menu Bar	52	(2)
Quitting Excel	54	(1)
Project Summary	55	(1)
What You Should Know	55	(1)
Learn It Online	56	(1)
Apply Your Knowledge	57	(1)
In the Lab	58	(5)
Cases and Places	63
2 PROJECT TWO
Formulas, Functions, Formatting, and Web Queries
Objectives	01	(3)
Introduction	04	(1)
Project Two --- Greenback Stock Club	04	(3)
Starting and Customizing Excel	06	(1)
Entering the Titles and Numbers into the Worksheet	07	(2)
Entering Formulas	09	(7)
Order of Operations	10	(1)
Entering Formulas Using Point Mode	11	(2)
Copying the Formulas Using the Fill Handle	13	(2)
Smart Tags	15	(1)
Determining the Totals Using the AutoSum Button	15	(1)
Determining the Total Percent Gain/Loss	16	(1)
Using the AVERAGE, MAX, and MIN Functions	16	(9)
Determining the Average of a Range of Numbers	17	(1)
Determining the Highest Number in a Range of Numbers	18	(2)
Determining the Lowest Number in a Range of Numbers	20	(3)
Copying the AVERAGE, MAX, and MIN Functions	23	(1)
Saving the Workbook	24	(1)
Verifying Formulas Using Range Finder	25	(1)
Formatting the Worksheet	26	(22)
Changing the Font and Centering the Worksheet Title	27	(3)
Changing the Worksheet Title Background and Font Colors and Applying an Outline Border	30	(1)
Applying Formats to the Column Titles	31	(1)
Centering the Stock Symbols and Formatting the Dates and Numbers in the Worksheet	32	(1)
Formatting Numbers Using the Formatting Toolbar	33	(3)
Underlining the Row above the Title Row and Bolding the Total Row Titles	36	(1)
Formatting Numbers Using the Format Cells Command on the Shortcut Menu	36	(3)
Formatting Numbers Using the Percent Style Button and Increase Decimal Button	39	(1)
Conditional Formatting	40	(3)
Changing the Widths of Columns and Heights of Rows	43	(1)
Changing the Widths of Columns	43	(3)
Changing the Heights of Rows	46	(2)
Checking Spelling	48	(2)
Saving a Workbook a Second Time Using the Same File Name	50	(1)
Previewing and Printing the Worksheet	51	(5)
Printing a Section of the Worksheet	54	(2)
Displaying and Printing the Formulas Version of the Worksheet	56	(2)
Changing the Print Scaling Option Back to 100%	57	(1)
Importing External Data from a Web Source Using a Web Query	58	(4)
Changing the Sheet Names	62	(1)
E-Mailing a Workbook from within Excel	63	(2)
Quitting Excel and Saving the Workbook	64	(1)
Project Summary	65	(1)
What You Should Know	65	(1)
Learn It Online	66	(1)
Apply Your Knowledge	67	(2)
In the Lab	69	(9)
Cases and Places	78
3 PROJECT THREE
What-If Analysis, Charting, and Working with Large Worksheets
Objectives	01	(3)
Introduction	04	(2)
Project Three---Awesome Intranets' Six-Month Financial Projections	06	(2)
Starting and Customizing Excel	06	(1)
Changing the Font of the Entire Worksheet to Bold	07	(1)
Entering the Worksheet Titles	07	(1)
Rotating Text and Using the Fill Handle to Create a Series	08	(3)
Copying a Cell's Format Using the Format Painter Button	11	(2)
Increasing the Column Widths and Entering Row Titles	12	(1)
Copying a Range of Cells to a Nonadjacent Destination Area	13	(3)
Using Drag and Drop to Move or Copy Cells	16	(1)
Inserting and Deleting Cells in a Worksheet	16	(3)
Inserting Rows	16	(2)
Inserting Columns	18	(1)
Inserting Individual Cells or a Range of Cells	18	(1)
Deleting Columns and Rows	18	(1)
Deleting Individual Cells or a Range of Cells	18	(1)
Entering Numbers with a Format Symbol	19	(1)
Saving the Workbook	19	(1)
Freezing Worksheet Titles	20	(2)
Entering the Projected Revenue	21	(1)
Displaying the System Date	22	(3)
Absolute Versus Relative Addressing	25	(2)
Entering a Formula Containing Absolute Cell References	26	(1)
Making Decisions --- The IF Function	27	(5)
Entering the Remaining Projected Expense and Net Income Formulas for January	29	(1)
Copying the Projected January Expenses and Net Income Formulas to the Other Months	30	(1)
Determining the Projected Total Expenses by Category and Total Net Income	31	(1)
Unfreezing Worksheet Titles and Saving the Workbook	31	(1)
Formatting the Worksheet	32	(11)
Formatting the Numbers	33	(2)
Formatting the Worksheet Titles	35	(2)
Displaying the Drawing Toolbar	37	(1)
Moving and Docking a Toolbar	38	(1)
Adding a Drop Shadow to the Title Area	39	(1)
Formatting the Category Row Titles and Net Income Row	40	(2)
Formatting the Assumptions Table	42	(1)
Hiding the Drawing Toolbar and Saving the Workbook	43	(1)
Adding a 3-D Pie Chart to the Workbook	43	(11)
Drawing a 3-D Pie Chart on a Separate Chart Sheet	44	(4)
Formatting the Chart Title and Data Labels	48	(1)
Changing the Colors of the Slices	49	(2)
Exploding the 3-D Pie Chart	51	(1)
Rotating and Tilting the 3-D Pie Chart	51	(2)
Adding Leader Lines to the Data Labels	53	(1)
Renaming and Reordering the Sheets and Coloring Their Tabs	54	(2)
Checking Spelling, Saving, Previewing, and Printing the Workbook	56	(2)
Checking Spelling in Multiple Sheets	56	(1)
Previewing and Printing the Workbook	56	(2)
Changing the View of the Worksheet	58	(3)
Shrinking and Magnifying the View of a Worksheet or Chart	58	(1)
Splitting the Window into Panes	59	(2)
What-If Analysis	61	(4)
Goal Seeking	63	(2)
Quitting Excel	65	(1)
Project Summary	65	(1)
What You Should Know	66	(1)
Learn It Online	67	(1)
Apply Your Knowledge	68	(1)
In the Lab	69	(10)
Cases and Places	79
WEB FEATURE
Creating Static and Dynamic Web Pages Using Excel
Introduction	01	(3)
Using Web Page Preview and Saving an Excel Workbook as a Static Web Page	04	(6)
Web Page Preview	04	(2)
Saving a Workbook as a Static Web Page to a New Folder	06	(2)
Viewing the Static Web Page Using Your Browser	08	(2)
Saving an Excel Chart as a Dynamic Web Page	10	(5)
Viewing and Manipulating the Dynamic Web Page Using Your Browser	12	(1)
Modifying the Worksheet on a Dynamic Web Page	13	(2)
Web Feature Summary	15	(1)
What You Should Know	15	(1)
In the Lab	15
Microsoft Access 2002
1 PROJECT ONE
Creating A Database Using Design and Datasheet Views
Objectives	03	(3)
What Is Microsoft Access?	06	(1)
Project One --- Alisa Vending Services	06	(2)
Starting Access	08	(2)
Speech Recognition	10	(1)
Creating a New Database	11	(2)
The Access Desktop and the Database Window	13	(1)
Creating a Table	13	(7)
Defining the Fields	16	(3)
Correcting Errors in the Structure	19	(1)
Saving and Closing a Table	20	(1)
Adding Records to a Table	21	(3)
Closing a Table and Database	24	(1)
Opening a Database	25	(1)
Adding Additional Records	26	(2)
Correcting Errors in the Data	28	(1)
Previewing and Printing the Contents of a Table	28	(4)
Creating Additional Tables	32	(2)
Adding Records to the Additional Table	34	(1)
Using a Form to View Data	34	(6)
Creating a Form	35	(1)
Closing and Saving the Form	36	(1)
Opening the Saved Form	37	(1)
Using the Form	38	(1)
Switching Between Form View and Datasheet View	39	(1)
Creating a Report	40	(7)
Selecting the Fields for the Report	42	(1)
Completing the Report	43	(3)
Printing the Report	46	(1)
Closing the Database	47	(1)
Access Help System	47	(2)
Obtaining Help Using the Ask a Question Box on the Menu Bar	47	(2)
Quitting Access	49	(1)
Designing a Database	49	(2)
Project Summary	51	(1)
What You Should Know	52	(1)
Learn It Online	53	(1)
Apply Your Knowledge	54	(2)
In the Lab	56	(6)
Cases and Places	62
2 PROJECT TWO
Querying a Database Using the Select Query Window
Objectives	01	(3)
Introduction	04	(1)
Project Two --- Querying the Alisa Vending Services Database	04	(2)
Opening the Database	06	(1)
Creating a New Query	06	(8)
Using the Select Query Window	09	(1)
Displaying Selected Fields in a Query	09	(2)
Running a Query	11	(1)
Printing the Results of a Query	11	(1)
Returning to the Select Query Window	12	(1)
Closing a Query	12	(2)
Including All Fields in a Query	14	(1)
Clearing the Design Grid	15	(1)
Entering Criteria	16	(6)
Using Text Data in Criteria	16	(1)
Using Wildcards	17	(1)
Criteria for a Field Not in the Result	18	(2)
Using Numeric Data in Criteria	20	(1)
Using Comparison Operators	21	(1)
Using Compound Criteria	22	(2)
Using AND Criteria	22	(1)
Using OR Criteria	23	(1)
Sorting Data in a Query	24	(5)
Omitting Duplicates	26	(1)
Sorting on Multiple Keys	27	(2)
Joining Tables	29	(4)
Restricting Records in a Join	32	(1)
Using Calculated Fields in a Query	33	(3)
Calculating Statistics	36	(5)
Using Criteria in Calculating Statistics	38	(2)
Grouping	40	(1)
Saving a Query	41	(1)
Closing a Database	42	(1)
Project Summary	42	(1)
What You Should Know	42	(1)
Learn It Online	43	(1)
Apply Your Knowledge	44	(1)
In the Lab	44	(4)
Cases and Places	48
3 PROJECT THREE
Maintaining a Database Using the Design and Update Features of Access
Objectives	01	(3)
Introduction	04	(1)
Project Three --- Maintaining the Alisa Vending Services Database	04	(1)
Opening the Database	05	(1)
Adding, Changing, and Deleting	06	(9)
Adding Records	06	(2)
Searching for a Record	08	(2)
Changing the Contents of a Record	10	(1)
Switching Between Views	10	(2)
Filtering Records	12	(2)
Deleting Records	14	(1)
Changing the Structure	15	(7)
Changing the Size of a Field	15	(2)
Adding a New Field	17	(2)
Deleting a Field	19	(1)
Updating the Restructured Database	19	(1)
Resizing Columns	20	(2)
Using an Update Query	22	(3)
Using a Delete Query	25	(2)
Creating Validation Rules	27	(9)
Specifying a Required Field	27	(2)
Specifying a Range	29	(1)
Specifying a Default Value	29	(1)
Specifying a Collection of Legal Values	30	(1)
Using a Format	31	(1)
Saving Rules, Values, and Formats	32	(1)
Updating a Table that Contains Validation Rules	33	(2)
Making Individual Changes to a Field	35	(1)
Specifying Referential Integrity	36	(4)
Using Subdatasheets	39	(1)
Ordering Records	40	(3)
Ordering Records on Multiple Fields	41	(2)
Creating and Using Indexes	43	(5)
How Does Access Use an Index?	45	(1)
When Should You Create an Index?	45	(1)
Creating Single-Field Indexes	46	(1)
Creating Multiple-Field Indexes	46	(2)
Closing the Database	48	(1)
Project Summary	49	(1)
What You Should Know	49	(1)
Learn It Online	50	(1)
Apply Your Knowledge	51	(1)
In the Lab	52	(6)
Cases and Places	58
WEB FEATURE
Publishing to the Internet Using Data Access Pages
Introduction	01	(1)
Opening the Database	01	(1)
Creating a Data Access Page	02	(5)
Viewing the Data Access Page	07	(1)
Using the Data Access Page	08	(1)
Web Feature Summary	09	(1)
What You Should Know	09	(1)
In the Lab	10
Microsoft PowerPoint 2002
1 PROJECT ONE
Using a Design Template and Text Slide Layout to Create a Presentation
Objectives	03	(3)
What Is Microsoft PowerPoint?	06	(2)
Project One --- Time to Start Making Friends	08	(2)
Starting and Customizing PowerPoint	10	(3)
The PowerPoint Window	13	(5)
PowerPoint Views	14	(1)
Placeholders, Text Areas, Mouse Pointer, and Scroll Bars	15	(1)
Status Bar, Menu Bar, Standard Toolbar, Formatting Toolbar, and Drawing Toolbar	15	(3)
Speech Recognition	18	(1)
Choosing a Design Template	19	(3)
Creating a Title Slide	22	(3)
Entering the Presentation Title	22	(1)
Correcting a Mistake When Typing	23	(1)
Entering the Presentation Subtitle	23	(2)
Text Attributes	25	(4)
Changing the Style of Text to Italic	25	(2)
Changing the Font Size	27	(2)
Saving the Presentation on a Floppy Disk	29	(3)
Adding a New Slide to a Presentation	32	(1)
Creating a Text Slide with a Single-Level Bulleted List	33	(3)
Entering a Slide Title	33	(1)
Selecting a Text Placeholder	34	(1)
Typing a Single-Level Bulleted List	35	(1)
Creating a Text Slide with a Multi-Level Bulleted List	36	(7)
Adding New Slides and Entering Slide Titles	37	(1)
Typing a Multi-Level Bulleted List	38	(3)
Creating a Third-Level Paragraph	41	(2)
Ending a Slide Show with a Black Slide	43	(2)
Saving a Presentation with the Same File Name	45	(1)
Moving to Another Slide in Normal View	45	(2)
Using the Scroll Box on the Slide Pane to Move to Another Slide	45	(2)
Viewing the Presentation in Slide Show View	47	(4)
Starting Slide Show View	47	(2)
Advancing Through a Slide Show Manually	49	(1)
Using the Popup Menu to Go to a Specific Slide	49	(2)
Using the Popup Menu to End a Slide Show	51	(1)
Quitting PowerPoint	51	(2)
Opening a Presentation	53	(2)
Opening an Existing Presentation	53	(2)
Checking a Presentation for Spelling and Consistency	55	(2)
Checking a Presentation for Spelling Errors	55	(1)
Starting the Spelling Checker	55	(2)
Correcting Errors	57	(1)
Types of Corrections Made to Presentations	57	(1)
Deleting Text	58	(1)
Replacing Text in an Existing Slide	58	(1)
Displaying a Presentation in Black and White	58	(2)
Printing a Presentation	60	(1)
Saving Before Printing	60	(1)
Printing the Presentation	60	(1)
Making a Transparency	61	(1)
PowerPoint Help System	61	(4)
Obtaining Help Using the Ask a Question Box on the Menu Bar	62	(2)
Quitting PowerPoint	64	(1)
Project Summary	65	(1)
What You Should Know	66	(1)
Learn It Online	67	(1)
Apply Your Knowledge	68	(1)
In the Lab	69	(7)
Cases and Places	76
2 PROJECT TWO
Using the Outline Tab and Clip Art to Create a Slide Show
Objectives	01	(3)
Introduction	04	(1)
Project Two --- Enjoy Spring Break in the Caribbean	04	(2)
Start a New Presentation	06	(1)
Using the Outline Tab	07	(3)
Creating a Presentation on the Outline Tab	10	(2)
Creating a Title Slide on the Outline Tab	10	(2)
Adding a Slide on the Outline Tab	12	(1)
Creating a Text Slide with a Single-Level Bulleted List on the Outline Tab	12	(2)
Creating Text Slides with Multi-Level Bulleted Lists on the Outline Tab	14	(3)
Creating a Second Text Slide with a Multi-Level Bulleted List	15	(1)
Creating a Closing Slide on the Outline Tab	16	(1)
Saving a Presentation	17	(1)
Reviewing a Presentation in Slide Sorter View	18	(3)
Changing Slide Layout	21	(3)
Adding Clip Art to a Slide	24	(7)
Inserting Clip Art into a Content Placeholder	24	(3)
Inserting a Second Clip into a Slide	27	(1)
Inserting Clip Art into a Slide without a Content Placeholder	28	(2)
Smart Tags	30	(1)
Using the Automatic Layout Options Button to Undo a Layout Change	31	(2)
Moving Clip Art	33	(1)
Changing the Size of Clip Art	33	(3)
Inserting, Moving, and Sizing a Clip into a Slide	36	(1)
Saving the Presentation Again	36	(1)
Adding a Header and Footer to Outline Pages	37	(2)
Using the Notes and Handouts Sheet to Add Headers and Footers	37	(2)
Applying Animation Schemes	39	(3)
Adding an Animation Scheme to a Slide Show	39	(3)
Animating Clip Art	42	(3)
Adding Animation Effects	42	(3)
Saving the Presentation Again	45	(1)
Running an Animated Slide Show	45	(2)
Printing a Presentation Created on the Outline Tab	47	(4)
Printing an Outline	47	(3)
Printing Presentation Slides	50	(1)
E-Mailing a Slide Show from within PowerPoint	51	(2)
Saving and Quitting PowerPoint	53	(1)
Project Summary	53	(1)
What You Should Know	54	(1)
Learn It Online	55	(1)
Apply Your Knowledge	56	(1)
In the Lab	57	(7)
Cases and Places	64
WEB FEATURE
Creating a Presentation on the Web Using PowerPoint
Introduction	01	(2)
Saving a PowerPoint Presentation as a Web Page	03	(3)
Viewing a Presentation as a Web Page	06	(2)
Editing a Web Page through a Browser	08	(3)
Web Feature Summary	11	(1)
What You Should Know	12	(1)
In the Lab	13
Microsoft Outlook 2002
1 PROJECT ONE
Schedule and Contact Management Using Outlook
Objectives	03	(3)
What Is Microsoft Outlook?	06	(1)
Project One --- Personal Information Manager	06	(2)
Starting Outlook	08	(1)
Opening the Calendar Folder	08	(1)
The Calendar - Microsoft Outlook Window	09	(4)
Creating a Personal Subfolder in the Calendar Folder	11	(2)
Changing to a Personal Folder	13	(1)
Entering Appointments Using the Appointment Area	13	(10)
Entering Appointments Using the Appointment Window	15	(2)
Recurring Appointments	17	(2)
Moving to the Next Day in Calendar and Entering the Remaining Recurring Appointments	19	(1)
Using Natural Language Phrases to Enter Appointment Dates and Times	20	(3)
Editing Appointments	23	(1)
Deleting Appointments	23	(1)
Moving Appointments to a New Time	24	(2)
Moving Appointments to a New Date	26	(1)
Moving an Appointment to a New Month	27	(2)
Creating an Event	29	(1)
Displaying the Calendar in Week and Month Views	30	(3)
Work Week View	30	(1)
Week View	31	(1)
Month View	32	(1)
Creating a Task List Using the TaskPad	33	(2)
Printing a Calendar	35	(2)
Daily Style	35	(1)
Weekly Style	36	(1)
Monthly Style	36	(1)
Printing the Task List	36	(1)
Contacts	37	(9)
Creating a Personal Subfolder in the Contacts Folder	37	(2)
Creating a Contact List	39	(3)
Finding a Contact Quickly	42	(1)
Organizing Contacts	43	(2)
Printing the Contact List	45	(1)
Exporting, Deleting, and Importing Subfolders	46	(5)
Exporting Subfolders	46	(2)
Deleting Subfolders	48	(2)
Importing Subfolders	50	(1)
Quitting Outlook	51	(1)
Project Summary	52	(1)
What You Should Know	52	(1)
Learn It Online	53	(1)
In the Lab	54	(1)
Cases and Places	55
Office XP Integration
1 PROJECT ONE
Integrating Office XP Applications and the World Wide Web
Objectives	01	(3)
Introduction	04	(1)
Integration Project --- Garden National Bank Web Site	05	(1)
Adding Hyperlinks to a Word Document	05	(8)
Starting Word and Opening a Document	08	(1)
Inserting a Table into a Word Document	09	(1)
Eliminating the Table Border	10	(1)
Inserting the Text for the Hyperlinks	11	(1)
Inserting a Hyperlink to PowerPoint Web Pages	12	(1)
Embedding an Excel Chart into a Word Document	13	(7)
Changing the Size of an Embedded Object	16	(3)
Quitting Excel	19	(1)
Adding Scrolling Text to a Word Document	20	(4)
Inserting Scrolling Text	21	(2)
Resizing the Scrolling Text	23	(1)
Viewing the Word Document in Your Browser and Saving It as a Web Page	24	(2)
Creating a PowerPoint Presentation Web Page	26	(5)
Adding Text for a Hyperlink	28	(1)
Creating a Hyperlink	28	(1)
Viewing and Saving the PowerPoint Web Page	29	(2)
Saving the PowerPoint Presentation as a Web Page	31	(1)
Creating a Data Access Page from an Access Database	31	(9)
Creating a Data Access Page Using the Wizard	32	(3)
Adding a Title and Resizing a Label on a Data Access Page	35	(2)
Adding a Hyperlink to a Data Access Page	37	(2)
Saving the Data Access Page and Viewing It	39	(1)
Testing the Web Site	40	(2)
Verifying the Hyperlinks in Your Browser	41	(1)
Project Summary	42	(1)
What You Should Know	42	(1)
In the Lab	43	(5)
Cases and Places	48
APPENDIX A Microsoft Office XP Help System
Using the Microsoft Office Help System	1	(1)
Ask a Question Box	2	(2)
The Office Assistant	4	(3)
Showing and Hiding the Office Assistant	4	(1)
Turning the Office Assistant On and Off	4	(1)
Using the Office Assistant	5	(2)
The Microsoft Word Help Window	7	(2)
Using the Contents Sheet	7	(1)
Using the Answer Wizard Sheet	8	(1)
Using the Index Sheet	8	(1)
What's This? Command and Question Mark Button	9	(1)
What's This? Command	10	(1)
Question Mark Button	10	(1)
Office on the Web Command	10	(1)
Other Help Commands	11	(1)
Activate Product Command	11	(1)
WordPerfect Help Command	11	(1)
Detect and Repair Command	11	(1)
About Microsoft Word Command	11	(1)
Use Help	12
APPENDIX B Speech and Handwriting Recognition and Speech Playback
Introduction	1	(1)
The Language Bar	1	(4)
Buttons on the Language Bar	2	(1)
Customizing the Language Bar	2	(3)
Speech Recognition	5	(4)
Getting Started with Speech Recognition	6	(2)
Using Speech Recognition	8	(1)
Handwriting Recognition	9	(5)
Writing Pad	9	(3)
Write Anywhere	12	(1)
Drawing Pad	12	(1)
On-Screen Keyboard	13	(1)
Speech Playback in Excel	14
Customizing Speech Playback	15
APPENDIX C Publishing Office Web Pages to a Web Server
Using Web Folders to Publish Office Web Pages	1	(1)
Using FTP to Publish Office Web Pages	1	(1)
APPENDIX D Resetting the Toolbars and Menus	1	(1)
APPENDIX E Microsoft Office User Specialist Certification Program
What Is MOUS Certification?	1	(1)
Why Should You Get Certified?	1	(1)
The MOUS Exams	2	(1)
How Can You Prepare for the MOUS Exams?	2	(1)
How to Find an Authorized Testing Center	2	(1)
Shelly Cashman Series MOUS Web Page	2
Index	1	(1)
Quick Reference Summary	1