Microsoft Office 2000: Microsoft Certified Edition

by Toliver, Pamela R.; Johnson, Yvonne; Koneman, Philip A.

• ISBN13: 9780201611878
• ISBN10: 0201611872
• Edition: Spiral
• Format: Paperback
• Copyright: 2000-03-01
• Publisher: Pearson College Div

Summary

The Select Office 2000 Series is written from the ground up to reflect the MS Certification objectives. The class-tested, project-based, highly visual approach makes it easy to clearly see and understand what you are doing as your work through each project.

Table of Contents

OVERVIEW OF WINDOWS
Overview of Windows	2	(1)
Identifying the Desktop Elements	2	(2)
Using a Mouse	4	(2)
To Use the Mouse	5	(1)
Using the Basic Features of Windows	6	(2)
To Work with a Window	7	(1)
Using Menus and Toolbars	8	(3)
To Use Menus and Toolbars	9	(2)
Working with Multiple Programs	11	(1)
To Switch between Windows	11	(1)
Getting Help	12	(3)
To Use Help in Windows 95	12	(1)
To Use Help in Windows 98	13	(2)
Exiting Windows	15	(1)
To Exit Windows	15	(1)
Summary	16
COMMON ELEMENTS IN OFFICE 2000
Basic Common Elements	2	(24)
Launching Applications	2	(3)
Launching Microsoft Word 2000	5	(1)
Performing Basic File Management Tasks	5	(8)
Opening a Copy of a Document	7	(5)
To Save a Copy of a File in a New Folder	12	(1)
Changing File Properties	13	(1)
Editing File Properties	13	(1)
Using Help	14	(6)
To Use the Office Assistant	15	(3)
To Turn the Office Assistant Off and On	18	(2)
Selecting Printers and Printing	20	(3)
To Select a Printer	20	(3)
Exiting Applications	23	(1)
Summary and Exercises	24	(2)
Common Text and Art Elements	26
Working with Text	27	(7)
To Enhance and Format Text	29	(3)
To Copy Text Formats Using the Format Painter	32	(2)
Using Proofing Tools	34	(3)
To Spell Check a File	35	(1)
To Find and Replace Text	36	(1)
Adding Art in Office 2000	37	(5)
To Insert Clip Art	37	(2)
To Move and Size Clip Art Images	39	(1)
To Create WordArt	40	(2)
Creating and Manipulating Drawings	42	(4)
To Create and Manipulate Drawings	42	(2)
To Insert, Size, and Position File Images	44	(2)
Summary and Exercises	46
WORD 2000
Introducing Word 2000	2	(1)
Understanding the Document Cycle for Word Processing	2	(1)
Launching Word	3	(1)
To Launch Word	3	(1)
Identifying Window Elements	4	(1)
Identifying Indicators and Icons in the Status Bar	5	(1)
Using Multiple Windows in Word	6	(1)
Closing a Document and Exiting Word	7	(1)
To Close a Document and Exit Word	7	(1)
Summary and Exercises	8	(2)
Creating a Document	10	(34)
Changing the View	13	(3)
To Change the View	14	(2)
Entering Text	16	(1)
Inserting the Date	16	(3)
To Insert the Date	16	(2)
To Type the First Part of the Letter	18	(1)
Inserting Symbols and Special Characters	19	(2)
To Insert a Special Character	19	(2)
Creating and Using Auto Text Entries	21	(1)
To Create and Use an Auto Text Entry	21	(1)
Using AutoComplete	22	(2)
To Use AutoComplete	23	(1)
Editing Text	24	(1)
Making Changes in the Document	24	(1)
Spell Checking the Document	25	(1)
Previewing the Document	25	(2)
To Preview the Document	26	(1)
Creating an Envelope	27	(2)
To Create an Envelope	27	(2)
Printing a Document	29	(1)
To Print a Document	29	(1)
Creating a Fax Coversheet from a Template	30	(3)
To Create a Fax Coversheet from a Template	31	(2)
Using Click-n-Type	33	(1)
To Use Click-n-Type	33	(1)
Creating Labels	34	(3)
To Create a Label	34	(3)
Summary and Exercises	37	(7)
Hands-On Exercises	40	(2)
Creating a Memo; Creating Mailing Labels On Your Own Exercises	42	(2)
Writing a Letter to a Friend; Writing a Letter to Another Friend; Creating Mailing Labels; Creating Auto Text Entries; Creating Your Own AutoCorrect Entries; Creating Your Own Quick Reference
Editing and Formatting a Document	44	(38)
Inserting a File	47	(1)
To Insert a Page Break and Insert a File	47	(1)
Navigating through a Document	48	(1)
Using the Mouse to Navigate	49	(1)
Using Keystrokes to Navigate	49	(2)
To Navigate in a Document	50	(1)
Browsing for and Deleting Objects	51	(2)
To Browse for Objects	51	(2)
Finding and Deleting Text	53	(4)
To Use the Go To and Find Commands	54	(3)
Moving Text	57	(1)
Using Cut and Paste	57	(3)
To Move Text with Cut and Paste	57	(3)
Using Drag and Drop	60	(4)
To Drag and Drop Text	61	(3)
Finding and Replacing Text	64	(1)
To Find and Replace Text	64	(1)
Formatting Text	64	(1)
Setting the Font Defaults	64	(2)
To Change the Font Defaults	65	(1)
Underlining Text	66	(1)
To Apply an Underline	66	(1)
Applying Font Effects	66	(2)
To Apply Font Effects to Text	67	(1)
Changing Case	68	(2)
To Change the Case of Text	69	(1)
Aligning Text	70	(1)
To Align Text	71	(1)
Highlighting Text	71	(1)
To Highlight Text	71	(1)
Using Writing and Proofing Tools	72	(1)
Using the Thesaurus	72	(2)
To Replace a Word Using the Thesaurus	73	(1)
Hyphenating a Document	74	(1)
To Hyphenate Document	74	(1)
Summary and Exercises	75	(7)
Hands-On Exercises	78	(1)
Checking Spelling and Grammar; Editing the Fashion Show Document On Your Own Exercises	79	(3)
Editing the Ski Trip Document; Browsing through Documents; Using the Office Clipboard; Creating a Report on Your Ideal Vacation Spot; Improving Your Work; Grading Readability
Creating a Brochure	82	(34)
Defining the Page Setup	84	(3)
To Define the Page Setup	84	(3)
Creating and Revising Columns	87	(1)
Creating Columns	87	(1)
To Format the Page with Equal-Width Columns	87	(1)
Changing the Column Structure	88	(1)
To Change the Colum Structure	88	(1)
Inserting Column Breaks	89	(1)
To Insert Column Breaks	89	(1)
Applying Formatting to Paragraphs	90	(1)
Setting Tabs	91	(4)
To Set Right Tabs and Tabs with Leaders	92	(3)
Setting Indents	95	(2)
To Set Indents	96	(1)
Setting Paragraph and Line Spacing	97	(1)
To Set Paragraph Spacing	97	(1)
Creating Bulleted and Numbered Lists	98	(3)
To Create Bulleted and Numbered Lists	98	(3)
Finding and Replacing Formatting	101	(1)
To Find a Font and Replace It with Another Font	101	(1)
Applying, Creating, and Modifying Styles	102	(6)
To Apply a Style	102	(1)
To Create a Style	103	(3)
To Create a Style by Example	106	(1)
To Modify a Style	107	(1)
Summary and Exercises	108	(8)
Hands-On Exercises	111	(2)
Formatting the Career Day Brochure; Formatting the Cooking Seminar Brochure On Your Own Exercises	113	(3)
Creating a Template for Research Papers; Designing and Printing Gift Certificates; Designing and Printing Your Own Greeting Cards; Designing and Printing a Party Invitation; Creating Word Puzzles with Graphics; Making Signs
Working with Multipage Documents	116	(34)
Creating a Title Page	119	(1)
To Create a Title Page	119	(1)
Creating Sections	120	(2)
To Insert a Section Break	120	(2)
Creating an Outline	122	(8)
To Create an Outline	122	(4)
To Create Body Text, Headings, and Subheadings	126	(3)
To Create the Next Section	129	(1)
Creating and Modifying Headers and Footers	130	(1)
Creating Headers and Footers	130	(3)
To Create Headers and Footers	130	(3)
Inserting and Formatting Page Numbers	133	(4)
To Insert and Format Page Numbers	133	(4)
Modifying Headers and Footers	137	(1)
To Modify a Header	138	(1)
Creating Footnotes	138	(3)
To Create a Footnote	139	(2)
Using the Document Map to Navigate	141	(1)
To Navigate with the Document Map	141	(1)
Printing Specific Pages	142	(2)
Summary and Exercises	144	(6)
Hands-On Exercises	147	(2)
Creating an Itinerary; Creating an Outline On Your Own Exercises	149	(1)
Writing an Outline for a Long-Range Plan; Editing the Long-Range Plan; Adding Headers and Footers; Adding Footnotes; Including a Bibliography; Creating a Proposal
Creating Tables	150	(34)
Inserting a Table	152	(1)
To Insert a Table	152	(1)
Moving Around in a Table and Entering Text	153	(3)
To Enter Data in a Table	153	(3)
Modifying the Structure of a Table	156	(1)
Inserting and Deleting Rows and Columns	156	(1)
To Insert and Delete Rows and Columns	156	(1)
Moving Columns and Rows	157	(2)
To Move a Column and a Row	158	(1)
Changing the Height and Width of Rows and Columns	159	(2)
To Change the Height or Width of Rows or Columns	159	(2)
Splitting and Merging Cells	161	(1)
To Split and Merge Cells	161	(1)
Setting Table Properties	162	(3)
To Set Table Properties	162	(3)
Using Borders and Shading	165	(3)
To Change the Borders and Add Shading	165	(3)
Saving a Document as a Web Page	168	(2)
To Save a Document as a Web Page and Edit the Document	168	(2)
Drawing a Table	170	(6)
To Draw a Table	170	(6)
Creating a Hyperlink	176	(1)
To Create a Hyperlink	176	(1)
Summary and Exercises	177	(7)
Hands-On Exercises	180	(3)
Creating a Flight Schedule; Creating a Newsletter On Your Own Exercises	183	(1)
Creating a Class Schedule; Creating a List of Professors; Creating a Calendar; Creating a TV Schedule; Creating a List of the Items You Collect; Creating Your Own Web Page
Merging Documents	184
Creating the Main Document	186	(1)
To Create the Main Document	186	(1)
Creating the Data Source Document	187	(9)
To Create the Data Source Document	187	(5)
To Insert the Merge Fields	192	(3)
To Preview the Merged Data	195	(1)
Merging the Documents	196	(2)
To Merge All the Records in the Data Source Document with the Main Document	196	(1)
To Merge Selected Records with the Main Document	197	(1)
To Remove Selection Criteria	198	(1)
Merging Data Sources with Envelopes and Labels	198	(5)
To Merge Envelopes with a Data Source	198	(2)
To Merge Labels with a Data Source	200	(3)
Summary and Exercises	203
Hands-On Exercises	206	(1)
Creating and Merging Recruiting Response 2; Creating a Form Letter for the College Recruiter On Your Own Exercises	207
Creating a Personal Data Source; Creating a Personal Mail Merge Letter; Creating Personal Envelopes; Creating Personal Labels; Reviewing Restaurants; Creating a Report
EXCEL 2000
Introducing Excel 2000	2	(1)
Worksheets and Workbooks	3	(1)
Planning Excel Workbooks for Timely, Useful, and Accurate Information	4	(3)
Launching Excel 2000	7	(1)
To Launch Microsoft Excel	7	(1)
The Excel 2000 User Interface	8	(2)
To Close Your Workbook and Exit Microsoft Excel	9	(1)
Summary and Exercises	10	(2)
Designing Worksheets and Workbooks	12	(32)
Designing a Workbook	14	(1)
Navigating in a Workbook	15	(3)
Entering Text in a Worksheet	18	(2)
To Enter Text as Labels	18	(2)
Filling in Data Based on Adjacent Cells	20	(1)
To Use the Fill Handle to Complete a Data Series	20	(1)
Adjusting Column Width and Entering Additional Text	21	(3)
To Change the Width of Worksheet Columns	21	(2)
To Enter Additional Text Labels and Adjust Column Width	23	(1)
Saving Your Workbook	24	(2)
To Create a Folder and Save Your Workbook	24	(2)
Entering Numbers	26	(2)
To Enter Numbers	27	(1)
Creating Formulas	28	(5)
To Enter Formulas Using a Variety of Methods	30	(3)
Previewing and Printing Worksheets	33	(2)
To Preview and Print Worksheets	33	(2)
Closing Your Workbook	35	(1)
To Save and Close Your Workbook	35	(1)
Summary and Exercises	36	(8)
Hands-On Exercises	40	(2)
Creating a Sales Summary; Adding an Additional Worksheet to the Java Workbook On Your Own Exercises	42	(2)
Creating a List of Web Sites; Creating a Class Schedule; Creating a Time Card; Creating an Address List in Excel; Calculating the Minimum Value in a Range; Conducting a ``What-If''Analysis
Modifying Worksheets and Workbooks	44	(30)
Opening an Excel Workbook	46	(1)
To Open an Excel Workbook	46	(1)
Working with Worksheets	47	(1)
Editing a Workbook by Inserting Worksheets	48	(3)
To Insert Worksheets into the Current Worksheet	48	(1)
To Rename Worksheets	49	(1)
To Delete a Worksheet	50	(1)
Repositioning Worksheets in a Workbook	51	(2)
To Change the Order of Worksheet Tabs	52	(1)
Editing Worksheet Data	53	(1)
Editing Worksheets by Copying and Moving Data	53	(6)
To Copy Ranges	53	(3)
To Copy an Additional Range	56	(1)
To Move Ranges	57	(2)
Editing Worksheets by Revising Existing Data	59	(1)
To Revise Existing Worksheet Data	59	(1)
Entering Additional Text and Number Data	60	(2)
To Enter Additional Text and Numeric Data	60	(2)
Constructing Linking Formulas with 3-D References	62	(3)
To Create Formulas Containing the SUM Function on Multiple Worksheets Simultaneously	62	(1)
Creating 3-D References	63	(2)
Entering Formulas to Sum the Sales Summary Data	65	(2)
Creating Formulas to Sum the Sales Summary Data	66	(1)
Summary and Exercises	67	(7)
Hands-On Exercises	70	(2)
Adding a Worksheet to the Java Sales Worksheet; Adding Linking Formulas to the Sales Summary Worksheet On Your Own Exercises	72	(2)
Summarizing a List of Web Sites; Creating a Class Schedule; Creating a Time Card; Creating an Address List in Excel; Calculating the Minimum Value in Range; Modifying a ``What-If''Analysis
Formatting Worksheets and Workbooks	74	(30)
About Worksheet Formats	77	(1)
Formatting Numbers	77	(1)
To Apply Number Formats	77	(1)
Modifying Formats	78	(1)
To Modify Number Formats	78	(1)
Copying Formats	79	(1)
To Copy Cell Formats Using the Format Printer	79	(1)
Applying Font Formats	80	(3)
To Apply Font Formats and Change Cell Alignment	81	(2)
Creating and Applying Styles	83	(4)
Shading Worksheet Cells	84	(1)
To Create and Apply Styles	85	(2)
Working with Rows and Columns	87	(3)
To Insert Columns into Worksheets	88	(1)
To Add a Row to the Selected Worksheets and Resize the Row	89	(1)
Adding Borders to Cells	90	(2)
To Apply Borders to Selected Cells	90	(2)
Applying Cell Formats to the Sales Summary Worksheet	92	(3)
To Apply Cell Formats to the Sales Summary Worksheet	92	(3)
Using the Web Page Preview	95	(2)
To Use Excel's Web Page Preview	95	(1)
To Save the Workbook as HTML	96	(1)
Summary and Exercises	97	(7)
Hands-On Exercises	100	(2)
Indenting and Rotating Text; Merging Worksheet Cells On Your Own Exercises	102	(2)
Formatting the Web Sites Workbook; Formatting Your Class Schedule; Formatting Time Cards; Formatting an Excel Address List; Formatting the January Sales Workbook; Formatting the Utility Costs Workbook
Creating More Complex Workbooks	104	(34)
Naming Ranges	107	(1)
To Name Ranges	107	(1)
Using Ranges to Select Data	108	(1)
To Select Data Using a Range Name	108	(1)
Using Range Names in Formulas	109	(5)
To Use Range Names in Formulas	110	(3)
To Create Additional Formulas Using Range Names	113	(1)
Using Logical Functions	114	(1)
To Add an IF Function to Test Conditions	114	(1)
Modifying the Page Setup of Worksheets	115	(7)
To Change Worksheet Orientation	115	(4)
To Add Headers and Footers to Worksheets	119	(3)
Setting and Clearing Print Areas	122	(2)
To Set and Clear Print Areas	122	(2)
Setting Other Print Options	124	(2)
To Set Print Options	124	(2)
Summary and Exercises	126	(12)
Hands-On Exercises	129	(7)
Adding the MIN and MAX Functions to a Workbook; Preparing the Java Sales Summary Worksheet for Printing; Creating a Workbook from a Template and Sending the Workbook as an Electronic Mail Attachment On Your Own Exercises	136	(2)
Modifying Page Setup for the Web Sites Workbook; Adding an IF Function to the Class Schedule Workbook; Preparing Time Cards for Printing; Modifying an Excel Address List; Modifying the January Sales Workbook; Formatting the Utility Costs Workbook
Analyzing and Distributing Worksheet Data	138	(38)
Using Charts to Analyze and Summarize Worksheet Data	141	(1)
Creating Charts	142	(9)
To Insert a Column Chart into the Workbook	142	(5)
To Enter a Pie Chart into the Workbook	147	(4)
Modifying Charts	151	(3)
To Modify a Column Chart by Changing Its Properties	151	(3)
Deleting Charts	154	(2)
To Add a Chart to the Workbook and Then Delete It	155	(1)
Previewing Charts	156	(2)
To Preview Charts	156	(2)
Printing Charts	158	(1)
To Print Charts	158	(1)
Adding Graphics to Workbooks	159	(3)
To Add a Graphic to the Sales Summary Worksheet	159	(3)
Publishing Workbooks to the Web	162	(3)
To Publish Workbooks to the Web	162	(1)
To View Excel Data on the Web	163	(2)
Summary and Exercises	165	(11)
Hands-On Exercises	168	(6)
Adding a Menu Worksheet to a Workbook; Adding Hyperlinks to a Worksheet On Your Own Exercises	174	(2)
Publishing the Web Sites Workbook; Printing Your Class Schedule to the Web; Adding a Graphic to the Time Cards Workbook; Publishing Addresses to the Web; Charting January Sales
Using Financial Functions	176
Using Excel to Amortize a Loan	178	(1)
Defining the Structure of the Amortization Schedule	179	(4)
To Define the Structure of the Amortization Schedule	180	(1)
To Apply Additional Formats to the Text Constants	181	(2)
Entering Numeric Constants	183	(2)
To Enter and Format Numeric Constants	183	(2)
Calculating the Loan Payment Using Excel's PMT Function	185	(1)
To Calculate the Loan Payment Using the PMT Function	185	(1)
Calculating the Beginning Balance Using Excel's PV Function	186	(1)
To Calculate the Beginning Balance Using the PV Function	186	(1)
Calculating the Principal Paid in Each Payment
Using Excel's PPMT Function	187	(2)
To Calculate the Periodic Principal Payment Using the PPMT Function	188	(1)
Calculating the Interest Paid in Each Payment Using the IPMT Function	189	(1)
To Calculate the Periodic Interest Payment	189	(1)
Constructing Formulas to Calculate the Cumulative Principal, Cumulative Interest, Total Payments, and Ending Balance	190	(1)
To Construct Formulas to Determine the Cumulative Interest, Cumulative Principal, Total Payments, and Ending Balance	190	(1)
Using the Fill Handle to Complete the Amortization Schedule	191	(4)
To Use the Fill Handle to Complete the Amortization Schedule	192	(3)
Freezing Worksheet Panes to Assist in Viewing Large Worksheets	195	(3)
To Freeze Worksheet Panes to Assist Viewing	195	(3)
Changing the Loan Scenario	198	(1)
To Change the Loan Scenario	198	(1)
Summary and Exercises	199
Hands-On Exercises	202	(4)
Protecting Cells in a Workbook; Creating Excel Macros; Calculating the Future Value of an Investment; Using the Date Function On Your Own Exercises	206
Creating Macros to Enable and Disable Protection for a Worksheet; Repaying a Loan Early; Modifying a Workbook; Comparing Multiple Amortizations, Adding a Lump Sum Feature to the Loan Comparisons Workbook; Summarizing Loan Comparison Data
INTEGRATED PROJECT
Integrating Word and Excel	2	(12)
Identifying Differences between Linking and Embedding	4	(1)
Copying Excel Data to a Word Document	5	(4)
To Embed Excel Data in a Word Document	5	(4)
Linking an Excel Chart to a Word Document	9	(2)
To Link an Excel Chart to a Word Document	9	(2)
Editing and Breaking Links	11	(2)
To Edit and Break Links	11	(2)
Saving Documents and Workbooks as Web Pages	13	(1)
To Save Files as Web Pages	13	(1)
Viewing Documents and Workbooks as Web Pages	14	(1)
To View Documents as Web Pages	14	(1)
E-Mailing Documents and Workbooks	15	(1)
To E-Mail Files	15	(1)
Summary and Exercises	16
ACCESS 2000
Introducing Access 2000	2	(1)
Defining Database Terminology	2	(2)
Identifying Access Database Objects	4	(2)
Designing a Database	6	(1)
Launching Microsoft Access and Creating a New Database	7	(3)
To Launch Microsoft Access and Create a New Database	7	(3)
Identifying Microsoft Access Screen Elements	10	(1)
Closing Your Database File and Exiting Microsoft Access	11	(1)
To Close Your Database File and Exit Microsoft Access	11	(1)
Summary and Exercises	12	(2)
Creating Access Tables	14	(30)
Opening an Access Database	18	(2)
To Open a Database	18	(2)
Creating Tables	20	(1)
Naming Fields and Determining Data Types	21	(1)
Creating a Table Using Table Design View	22	(4)
To Create the Department Table Using Table Design View	22	(4)
Creating a Table Using the Table Wizard	26	(3)
To Create the Time Cards Table Using the Table Wizard	26	(3)
Creating a Table by Importing Data from Excel	29	(4)
Create the Employees Table by Importing a Microsoft Excel Worksheet	29	(4)
Adding Records to the Department Table	33	(3)
Adding Records to the Department Table Using Datasheet View	33	(3)
Creating an AutoForm to Display Records in the Employees Table	36	(2)
To Create an AutoForm Based Upon the Employees Table	36	(2)
Summary and Exercises	38	(6)
Hands-On Exercises	41	(1)
Creating an Inventory Database; Entering Records into a Table On Your Own Exercises	42	(2)
Creating a Database Using the Hyperlink Data Type; Adding Records to a Table; Adding a Table to an Existing Database; Exploring Data from Access to Excel; Creating a Database Using an Access Database Wizard; Adding Contact Type Records to the Contact Management Database
Establishing Relationships and Modifying Tables	44	(30)
Adding a Lookup Field to the Time Cards Table	48	(4)
To Add a Lookup Field That Lists Department Names to the Time Cards Table	48	(4)
Creating and Modifying Relationships	52	(2)
To Open the Relationships Window and Add Tables	52	(2)
Using the Relationships Window	54	(3)
To Create a One-to-Many Relationship between the Time Cards and Employees Table and Enforce Referential Integrity	55	(1)
To Modify the Relationship between the Time Cards and the Department Tables to Enforce Referential Integrity	56	(1)
Printing Relationships	57	(3)
To Print the Relationships	58	(2)
Improving Data Accuracy Using Input Masks and Validation Rules	60	(3)
To Set the Validation Rule and Validation Text Properties for the HoursWorked Field	60	(1)
To Add Input Masks to the Employees Table	61	(2)
Adding a Lookup Field to a Table in Design View	63	(2)
To Add a Lookup Field to the Time Cards Table by Modifying the Table Properties Directly	63	(2)
Adding Records to the Time Cards Table Using Lookup Lists	65	(2)
To Add Records to the Time Cards Table	65	(2)
Summary and Exercises	67	(7)
Hands-On Exercises	70	(2)
Adding a Table to the Inventory Database; Adding a Lookup Field to the Inventory Database On Your Own Exercises	72	(2)
Creating a Table of Web Site Ratings; Adding a Lookup Field to a Table; Establishing a Relationship in the Inventory Database; Using the Office Assistant; Checking Referential Integrity; Adding Contract Records to the Contact Management Database
Manipulating Table Data	74	(34)
Navigating Among Table Records Using Datasheet View	77	(3)
To Navigate Among Records in Datasheet View	78	(2)
Testing Validation Rules by Adding Records	80	(1)
To Test the Validation Rule and Validation Text Properties of the Time Cards Table	80	(1)
Searching for Records	81	(2)
To Search a Table for a Specific Record	82	(1)
Updating Records in a Table	83	(1)
To Update Records	83	(1)
Updating Multiple Records in a Table Using Replace	83	(4)
To Replace Employee Hourly Wages with New Values Using Datasheet View	84	(1)
To Replace Employee Hourly Wages with New Values Using the Employees Form	85	(2)
Sorting Records	87	(3)
To Sort Records in a Table	87	(2)
To View the Table Properties	89	(1)
Filtering Records	90	(4)
To Use Filter by Selection to Display All Employees from Texas	90	(1)
To Use Filter by Form to Display All Employees from Texas in Sorted Order	91	(3)
Creating a Data Access Page	94	(4)
To Create a Data Access Page	94	(4)
Viewing a Data Access Page on the Web	98	(3)
Exporting the Data Access Page	98	(1)
Opening the Data Access Page Using Internet Explorer	99	(2)
Summary and Exercises	101	(7)
Hands-On Exercises	104	(2)
Compacting a Database; Deleting Records from a Table On Your Own Exercises	106	(2)
Sorting the Web Sites Database; Creating a Data Access Page of Web Site Ratings; Sorting the Inventory Database; Using the Office Assistant; Sorting Contracts; Sorting and Compacting the Contact Management Database
Creating Queries	108	(30)
Creating Select Queries	111	(2)
To Create a Select Query Base upon One Table Using Query Design View	111	(2)
Adding Fields to a Select Query	113	(4)
To Add Fields to the Query Design Grid	113	(3)
To View the Results of a Query	116	(1)
Creating a Query Displaying Data from Multiple Tables	117	(3)
To Create a Query Based upon Multiple Tables	117	(3)
Adding a Calculated Field to the Query	120	(5)
To Add an Expression to Calculate Gross Pay	120	(3)
To View the Results of the Expresion and Modify Its Format	123	(2)
Defining the Sort Order for a Query	125	(1)
To Add Sort Order to the Query Design	125	(1)
Specifying Query Conditions	126	(4)
To Add Records to the Time Cards Table	126	(1)
To Specify a Single Query Condition	127	(1)
To Specify an AND Condition	128	(2)
Creating an AutoForm Based upon a Query	130	(2)
To Create an AutoForm Based upon the Gross Pay Query	130	(2)
Summary and Exercises	132	(6)
Hands-On Exercises	135	(2)
Modifying a Query's AutoForm; Creating a Multitable Query in the Inventory Database On Your Own Exercises	137	(1)
Querying the Web Sites Database; Creating a Data Access Page of Web Site Ratings; Sorting the Inventory Database; Using the Office Assistant; Specifying Query Conditions; Specifying And Query Conditions
Creating and Modifying Forms	138	(28)
Creating Forms	141	(1)
To Delete an Existing Database Form	141	(1)
Creating a New Form Using Design View	142	(3)
To Create a New Form Using Design View	142	(1)
To Add Controls to the Form	143	(2)
To Save the Form and Switch to Form View	145	(1)
Modifying a Form's Controls	145	(4)
To Delete Label Controls form the Employees Form	146	(1)
To Reposition Text Box Controls on the Form	147	(2)
Using ControlTips to Improve Data Accuracy	149	(2)
To Add ControlTips to the Employees Form	149	(2)
Adding Unbound Controls to a Form	151	(3)
To Add a Label Control to the Form Header and Footer and Modify Format Properties	151	(3)
Adding an Image to the Form Using an Unbound Control	154	(2)
To Embed an Image into the Form Using an Unbound Control	154	(2)
Maintaining Table Data Using a Form	156	(2)
To Add a Record to the Employees Table Using the Employees Form	156	(1)
To Delete a Record from the Employees Table Using the Employees Form	157	(1)
Summary and Exercises	158	(8)
Hands-On Exercises	161	(3)
Creating a Form that Displays a Subform; Adding a Calculated Control to the Time Cards Subform On Your Own Exercises	164	(2)
Building a Form Based upon a Query with an and Condition; Creating a Form Based upon a Multiple Query; Creating a Switchboard; Using the Office Assistant; Modifying a Form in the Contact Management Database; Creating a Form Based upon a Multitable Query
Creating and Modifying Reports	166
Creating Reports	168	(1)
Creating a Report Using the Report Wizard	169	(3)
To Create a Report Using the Report Wizard	169	(3)
Viewing a Report in the Print Preview Window	172	(2)
To Change the Preview Display	173	(1)
Modifying the Report Design for Printing	174	(3)
To Modify the Design of the Employees Report for Printing	174	(3)
Creating a Report Using Report Design View	177	(2)
To Create a New Report Using Design View	177	(2)
Adding Sorting and Grouping Levels to the Report for Previewing and Printing	179	(3)
To Add Sorting and Grouping Levels to the Report for Previewing and Printing	180	(2)
Adding a Calculated Control to the Report	182	(2)
To Create a Calculated Control to Sum the Total Payroll Amount	182	(2)
Adding a Report Header Displaying a Title for the Report	184	(2)
To Modify the Report	184	(2)
Summary and Exercises	186
Hands-On Exercises	189	(2)
Adding an Image to a Report; Modifying a Report's Design On Your Own Exercises	191
Building a Report Based upon a Query with an and Condition; Creating a Report Based upon a Multitable Query; Adding Functionality to a Switchboard Form; Using the Office Assistant; Modifying Reports in the Contact Management Database; Creating a Report Based upon a Multitable Query; Backing Up and Restoring a Database; Saving Database Objects as Web Pages
INTEGRATED PROJECT
Integrating Word, Excel, and Access	2	(10)
Copying Excel Data to an Access Database	4	(4)
To Import Excel Data into a New Access Database	4	(4)
Importing and Linking an Access Table to a New Database	8	(2)
To Import and Link an Access Table to a New Database	8	(2)
Merging Data from an Access Database Table with a Word Document	10	(3)
To Merge Access Data with Word	11	(2)
Merging Access Data from a Query to a Word Document	13	(3)
To Merge Access Records from a Query to a Word Document	13	(3)
Summary	16
POWERPOINT 2000
Introducting PowerPoint 2000	2	(1)
Defining PowerPoint Terminology	2	(1)
Designing a Presentation	3	(1)
Launching PowerPoint 2000	4	(1)
To Launch PowerPoint 2000	4	(1)
Creating a New Presentation	5	(4)
To Create a New Presentation	5	(4)
Summary and Exercises	9	(3)
Creating Presentations	12	(28)
Creating Blank Presentations	14	(1)
To Create a Blank Presentation with a Title Slide	14	(1)
Adding Text to Slide Placeholders	15	(2)
To Add Text to Slide Placeholders	15	(2)
Adding Slides to Presentations	17	(2)
To Add Slides to Presentations	17	(2)
Adding Text to Outlines and Slide Notes	19	(2)
To Add Text to Outlines and Slide Notes	20	(1)
Navigating Presentations	21	(1)
To Navigate Presentation Slides	22	(1)
Proofing Presentations	22	(3)
To Check Presentation Style	22	(3)
Creating Presentations Using Wizards	25	(3)
To Create a Presentation Using a Wizard	25	(3)
Setting Up Pages and Printing Presentation Materials	28	(4)
To Change Paper Size and Orientation	29	(1)
To Print Presentation Materials	30	(2)
Summary and Exercises	32	(8)
Hands-On Exercises	34	(3)
Creating, Proofing, Saving, and Adding Slides and Text to a Presentation; Switching Views, Navigating Presentation Slides, and Printing Handouts On Your Own Exercises	37	(3)
Creating, Proofing, Saving, and Adding Slides and Text to a Presentation; Creating, Formatting, and Saving a Multi-Slide Presentation; Using a Wizard to Create an On-Screen Presentation; Creating a Presentation from Information Obtained from the Internet; Creating a New Presentation; Printing Presentation Materials
Enhancing Presentations	40	(30)
Applying Presentation Templates	42	(2)
To Apply a Template to a Presentation	43	(1)
Creating a Table Slide	44	(2)
To Create a Table Slide	45	(1)
Selecting, Editing, and Formatting Presentation Slide Text	46	(2)
To Select, Edit, and Format Text	46	(2)
Formatting Slide Text Placeholders	48	(2)
To Format Text Placeholders	49	(1)
Adding Art to Slides	50	(2)
To Add Clip Art to Slides	51	(1)
Editing and Manipulating Art Objects	52	(3)
To Edit and Manipulate Art Objects	52	(3)
Animating Slide Text	55	(1)
Using Basic Text Animation Tools	55	(2)
To Animate Slide Text	55	(2)
Creating Custom Animations	57	(2)
To Create Custom Animations	57	(2)
Packing a Presentation to Go	59	(3)
To Pack a Presentation to Go	59	(3)
Summary and Exercises	62	(8)
Hands-On Exercises	65	(2)
Adding a New Slide and Inserting a Graphic; Adding Drawings to the Slides, Downloading Clips from the Internet, Formatting Text Placeholders and Using Text Animation Tools On Your Own Exercises	67	(3)
Applying a Template and Adding, Moving, and Sizing Clip Art Images; Adding, Formatting, and Manipulating Clip Art and Drawings; Searching the Internet for Pictures to Enhance Presentations and Use Animation Effects; Applying a Template, Arranging Bulleted Lists, and Changing Line Spacing; Finding Templates on the Internet; Copying Graphics from the Internet, Editing Presentation Format, and Applying a Template to a Presentation; Editing a Presentation
Viewing and Organizing Slide Shows	70	(30)
Presenting a Slide Show	72	(1)
To View a Presentation as a Slide Show	73	(1)
Advancing Slides	73	(1)
Using the Slide Show Shortcut Menu	74	(2)
To Use the Slide Show Shortcut Menu	74	(2)
Rearranging Presentation Slides Using Slide Sorter View	76	(1)
Moving Slides	77	(1)
To Rearrange Slides Using Slide Sorter View	77	(1)
Copying and Duplicating Slides	78	(1)
To Copy and Duplicate Slides	78	(1)
Deleting Slides	79	(1)
Adding Slides from One Presentation to an Existing Presentation	79	(2)
To Insert Slides from a File	80	(1)
Setting Action Buttons	81	(3)
To Create Action Buttons	82	(2)
Setting Action Button Actions	84	(1)
To Edit Action Button Actions	84	(1)
Adding Slide Transitions	85	(2)
To Add Slide Transitions	86	(1)
Hiding Slides and Displaying Hidden Slides	87	(1)
To Hide Slides and Display Them during a Slide Show	87	(1)
Setting Presentations to Run Automatically	88	(3)
To Set a Show to Run Automatically	88	(3)
Summary and Exercises	91	(9)
Hands-On Exercises	94	(3)
Adding Slides to the Presentation and Creating Action Buttons; Rearranging and Hiding Slides and Showing a Presentation On Your Own Exercises	97	(3)
Locating Information on the Internet, Editing, Enhancing, and Viewing a Presentation as a Slide Show, and Packing a Presentation to Go; Editing and Enhancing a Presentation and Viewing a Slide Show; Rearranging and Hiding Slides and Showing a Presentation; Using the Slides Show Shortcut Menu and Setting Action Buttons; Creating a New Presentation Using Slides from an Existing Presentation and Information from the Internet; Expanding Your Family Tree Using Action Buttons
Working with Masters	100
Displaying Slide Masters	102	(2)
To Display the Presentation Slide Master	102	(2)
Adding Footers to Presentations	104	(2)
To Add and Position the Slide Number in the Footer Area of Presentation Slides	104	(2)
Changing Text Style and Alignment on Slide Masters	106	(1)
To Change Text Style and Alignment on the Slide Master	106	(1)
Changing Bullet Format on Slide Masters	107	(3)
To Change the Bullet Format for a Text Level	108	(2)
Formatting the Slide Background	110	(3)
To Format the Slide Background	110	(3)
Customizing a Color Scheme	113	(2)
To Customize a Color Scheme	113	(2)
Inserting and Formatting Graphics on Slide Masters	115	(3)
To Insert and Format a Graphic on a Slide Master	115	(3)
Creating and Formatting Title Masters	118	(2)
To Create a Presentation Title Master	118	(2)
Saving Presentation Designs as Templates	120	(3)
To Save a Presentation Design as a Template	120	(3)
Summary and Exercises	123
Hands-On Exercises	126	(1)
Formatting Text and Bullets on Slide Masters; Changing the Slide Background and Adjusting Objects on Slides On Your Own Exercises	127
Changing the Background, Adding a Footer, Formatting Bullets, and Changing Text Alignment for a Template; Customizing a Presentation Template; Customizing a Presentation Template; Searching the Internet for Template Designs, Changing the Template Background, Adding Graphics as a Watermark, and Adjusting the Position of the Placeholders on Slide and Title Masters
INTEGRATED PROJECT
Integrating Word, Excel, Access, and PowerPoint	2
Embedding a Word Table in a PowerPoint Slide	4	(2)
To Create a Table Slide	5	(1)
Linking Data from Excel to a PowerPoint Slide	6	(2)
To Link Data from Excel to a PowerPoint Slide	6	(2)
Creating a Word Document from a PowerPoint Presentation Outline	8	(1)
To Create a Word Document from a PowerPoint Presentation Outline	8	(1)
Saving a PowerPoint Slide as a Graphic	9	(1)
To Save a PowerPoint Slide as a Graphic and Add It to a Word Document	9	(1)
Creating a Hyperlink between a PowerPoint Presentation and an Access Database	10	(2)
To Create a Hyperlink between PowerPoint and Access	11	(1)
Saving a Presentation as a Web Page	12	(1)
To Save a Presentation as a Web Page	12	(1)
Viewing the Web Presentation	13	(2)
To View a Presentation As It Appears on the Web	13	(2)
Summary	15	(1)
BONUS FEATURE
Sharing Files and Posting Presentations	16
To Create a PowerPoint Presentation from a Word Outline	16	(1)
To Save a PowerPoint Presentation as a Web Page	16
INTERNET EXPLORER 5
Overview of Internet Explorer	2	(1)
Identifying the Structure and Purpose of the Internet	2	(1)
Connecting to the Internet	3	(1)
Identifying Services on the Internet	3	(1)
Launching Internet Explorer 5	4	(1)
To Launch Internet Explorer 5	4	(1)
Identifying the Internet Explorer 5 Screen Elements	4	(1)
Navigating the Internet	5	(1)
Using Hyperlinks	5	(1)
To Use a Hyperlink	6	(1)
Typing an Address	6	(1)
To Type an Internet Address	6	(1)
Selecting a Site from History	7	(1)
To Return to a Page by Using History	8	(1)
Selecting a Favorite	8	(1)
To Add a Favorite	8	(1)
Using a Favorite	9	(1)
To Go to a Favorite	9	(1)
Searching the Internet	9	(2)
To Search for Information Using a Search Engine	10	(1)
Using Channels	11	(3)
To Select a Page for Offline Viewing	11	(2)
To Synchronize and Work Offline	13	(1)
Downloading a File	14	(1)
To Download a File	15	(1)
Accessing Newsgroups	15	(1)
Launching the Internet Explorer Newsreader	15	(1)
To Launch the Newsreader from Internet Explorer 5	16	(1)
Reading a Message in a Newsgroup	16	(1)
To Read a Message	16	(1)
Subscribing to Newsgroups	17	(1)
To Subscribe to a Newsgroup	17	(1)
Exiting Internet Explorer 5	17	(1)
To Exit Internet Explorer 5	17	(1)
Summary and Exercises	18
Hands-On Exercises	21	(1)
Finding Out More about InterNIC; Exploring Links on the Links Toolbar On Your Own Exercises	21
Exploring Newsgroups; Guessing Addresses of Web Sites; Exploring Channels; Exploring Newsgroup Netiquette
OUTLOOK
Introducing Outlook 2000	2	(1)
Identifying Outlook Features	2	(1)
Launching Outlook	3	(1)
Using the Outlook Bar	4	(2)
To Access Outlook Features	4	(2)
Using the Office Assistant to Get Help	6	(2)
To Use the Office Assistant	6	(2)
Turning Off and On the Office Assistant	8	(1)
To Turn Off and On the Office Assistant	8	(1)
Customizing Toolbars and Menus	8	(1)
To Change AutoCustomizing Settings and Manually Customize Toolbars	9	(1)
Working with Outlook Views	9	(2)
To Set View Options and Change Views	10	(1)
Scheduling Appointments in the Calendar	11	(2)
To Schedule Appointments in the Calendar	11	(2)
Scheduling Multi-Day Events	13	(2)
To Schedule Multi-Day Events and Recurring Appointments	14	(1)
Recording Tasks in the TaskPad	15	(1)
Entering Basic Tasks	15	(2)
To Record Tasks in the TaskPad	15	(2)
Storing Contacts in the Contacts List	17	(1)
To Add and Edit Contacts Entries	17	(1)
Assigning Tasks to Others	18	(1)
To Assign Tasks to Others	18	(1)
Working with E-Mail	19	(1)
Creating, Sending, and Receiving E-Mail	20	(3)
To Create, Send, and Receive E-Mail	20	(3)
Replying to and Forwarding Messages	23	(1)
To Reply to and Forward Messages	23	(1)
Working with Mail Attachments	24	(1)
To Attach, Open, and Save Files Using E-Mail	24	(1)
Creating Address Book Entries	25	(2)
to Create Address Book Entries	25	(2)
Managing Outlook Files	27	(1)
Managing E-Mail	27	(1)
To Create Outlook Folders and Sort Messages by Setting View Options	27	(1)
Archiving Files	28	(1)
To Archive Files	28	(1)
Linking and Sorting Outlook Items	29	(2)
To Link and Sort Outlook Items	29	(2)
Using Categories to Manage Files	31	(2)
To Create Categories, Assign Items to Categories, and Sort Items by Category	31	(2)
Creating Notes	33	(1)
To Create, Edit, and Organize Notes	33	(1)
Printing from Outlook	34	(1)
To Print from Outlook	34	(1)
Exiting Outlook	35	(1)
Summary and Exercises	36
Hands-On Exercises	38
Integrating Outlook Components; Using Outlook to Plan/Schedule Meetings; Finding Messages; Creating Office 2000 Files; Using the Journal Feature
Function Reference Guide	G-1	(1)
Glossary	G-1	(1)
Index	I-1