A Professional Approach Series: Office 2000 Beginning Course Student Edition

by Hinkle, Deborah

• ISBN13: 9780028056005
• ISBN10: 0028056000
• Edition: Student
• Format: Paperback
• Copyright: 1999-09-28
• Publisher: MCG

Summary

Office 2000: Beginning Course from Glencoe's Professional Approach Series equips students with the skills needed to successfully use Microsoft Office. An extensive array of exercises teaches and challenges students, while illustrations of screens and the accompanying icons help them to follow instructions for hands-on practice. Students gain real-world experience by performing many of the same tasks required in business settings. A comprehensive instructional package allows instructors to tailor the program to teaching styles, lab needs, student objectives, and student learning styles.

Table of Contents

Preface	xi
Installation Requirements	xiv
Word
Case Study	3	(8)
Unit 1 Basic Skills	11	(108)
Creating a Document	12	(26)
Starting Word	12	(3)
Identifying Parts of the Word Screen	15	(2)
Keying Text	17	(3)
Basic Text Editing	20	(3)
Naming and Saving a Document	23	(2)
Printing a Document	25	(1)
Closing a Document and Exiting Word	26	(12)
Using Help	27	(2)
Concepts Review	29	(1)
Skills Review	30	(4)
Lesson Applications	34	(4)
Selecting and Editing Text	38	(26)
Opening an Existing Document	38	(3)
Nonprinting Characters	41	(2)
Moving Within a Document	43	(3)
Undo and Redo Commands	46	(1)
Repeat Command	47	(1)
Selecting Text	48	(3)
Saving a Revised Document	51	(1)
Working with Document Properties	51	(13)
Using Help	53	(2)
Concepts Review	55	(1)
Skills Review	56	(4)
Lesson Applications	60	(4)
Formatting Characters	64	(25)
Basic Character Formatting	64	(3)
Working with Fonts	67	(2)
Using the Font Dialog Box	69	(3)
Repeating and Copying Formatting	72	(2)
Changing Case	74	(1)
Highlighting Text	75	(1)
Creating a Dropped Capital Letter	76	(1)
Word's AutoFormat Features	77	(12)
Using Help	78	(2)
Concepts Review	80	(1)
Skills Review	81	(4)
Lesson Applications	85	(4)
Writing Tools	89	(30)
Using AutoComplete and AutoCorrect	89	(4)
Working with AutoText	93	(5)
Checking Spelling and Grammar	98	(4)
Using the Thesaurus	102	(17)
Using Help	103	(2)
Concepts Review	105	(1)
Skills Review	106	(4)
Lesson Applications	110	(4)
Applications	114	(5)
Unit 2 Paragraph Formatting, Margins, and Tabs	119	(88)
Formatting Paragraphs	120	(34)
Paragraph Alignment	121	(1)
Line Spacing	122	(2)
Paragraph Spacing	124	(1)
Paragraph Indents	125	(4)
Borders and Shading	129	(5)
Repeating and Copying Formats	134	(1)
Bulleted and Numbered Lists	135	(5)
Symbols and Special Characters	140	(14)
Using Help	143	(1)
Concepts Review	144	(1)
Skills Review	145	(5)
Lesson Applications	150	(4)
Margins	154	(23)
Changing Margins in Normal View	154	(3)
Changing Margins in Print Layout View	157	(3)
Changing Margins in Print Preview	160	(2)
Mirror Margins and Gutter Margins	162	(1)
Hyphenation	163	(3)
Inserting the Date and Time	166	(11)
Using Help	167	(1)
Concepts Review	168	(1)
Skills Review	169	(4)
Lesson Applications	173	(4)
Tabs and Tabbed Columns	177	(30)
Setting Tabs	178	(4)
Setting Leader Tabs	182	(1)
Clearing Tabs	183	(1)
Adjusting Tab Settings	184	(1)
Creating Tabbed Columns	185	(3)
Sorting Paragraphs and Tabbed Columns	188	(19)
Using Help	190	(1)
Concepts Review	191	(1)
Skills Review	192	(4)
Lesson Applications	196	(4)
Applications	200	(7)
Unit 3 Moving, Copying, and Replacing Text	207	(62)
Moving and Copying Text	208	(29)
Displaying the Office Clipboard	208	(1)
Moving Text Using Cut and Paste	209	(3)
Moving Text by Dragging	212	(1)
Copying Text Using Copy and Paste	213	(1)
Copying Text by Dragging	214	(1)
Using Smart Cut and Paste	215	(1)
Working with Multiple Document Windows	216	(5)
Moving and Copying Text among Windows	221	(16)
Using Help	224	(1)
Concepts Review	225	(1)
Skills Review	226	(6)
Lesson Applications	232	(5)
Find and Replace	237	(32)
Finding Text	237	(6)
Finding and Replacing Text	243	(2)
Finding and Replacing Special Characters	245	(2)
Finding and Replacing Formatting	247	(22)
Using Help	251	(1)
Concepts Review	252	(1)
Skills Review	253	(6)
Lesson Applications	259	(4)
Applications	263	(6)
Unit 4 Printing and Page Formatting	269	(86)
Printing	270	(27)
Using Print Preview	270	(4)
Setting Print Options	274	(2)
Setting Paper Size and Page Orientation	276	(2)
Printing Envelopes	278	(4)
Printing Labels	282	(1)
Sending a Document as E-mail	283	(14)
Using Help	285	(2)
Concepts Review	287	(1)
Skills Review	288	(4)
Lesson Applications	292	(5)
Page and Section Breaks	297	(23)
Using Soft and Hard Page Breaks	297	(3)
Controlling Line and Page Breaks	300	(2)
Controlling Section Breaks	302	(2)
Formatting Sections	304	(3)
Using the Go To Feature	307	(13)
Using Help	309	(1)
Concepts Review	310	(1)
Skills Review	311	(4)
Lesson Applications	315	(5)
Page Numbers, Headers, and Footers	320	(35)
Adding Page Numbers	320	(3)
Varying Page Numbers in Print Layout View	323	(2)
Adding Headers and Footers	325	(4)
Adding Headers and Footer within Sections	329	(1)
Linking Section Headers and Footers	330	(2)
Changing the Starting Page Number	332	(1)
Creating Continuation Page Headers	332	(2)
Creating Alternate Headers and Footers	334	(21)
Using Help	336	(1)
Concepts Review	337	(1)
Skills Review	338	(5)
Lesson Applications	343	(5)
Applications	348	(7)
Outlook Lesson 1 Introduction to Outlook and E-Mail	355	(40)
Starting Outlook	355	(3)
Identifying Parts of the Outlook Window	358	(2)
Navigating in Outlook	360	(3)
Addressing, Composing, and Sending E-Mail	363	(2)
Sending Attachments to E-Mail	365	(2)
Reading E-Mail	367	(5)
Using E-Mail Features	372	(3)
Printing E-Mail and Closing Outlook	375	(12)
Using Help	378	(1)
Concepts Review	379	(1)
Skills Review	380	(3)
Lesson Applications	383	(4)
Excel
Case Study	387	(8)
Unit 1 Basic Skills	395	(104)
What Is Excel?	397	(31)
Starting Excel	397	(6)
Changing the Active Cell	403	(1)
Navigating Between Worksheets	404	(2)
Closing and Opening Worksheets	406	(1)
Navigating within a Worksheet	407	(5)
Keying Data in a Worksheet	412	(1)
Saving a Workbook	413	(3)
Printing a Worksheet and Exiting Excel	416	(12)
Using Help	418	(1)
Concepts Review	419	(1)
Skills Review	420	(4)
Lesson Applications	424	(4)
Creating a Simple Worksheet	428	(35)
Entering and Editing Data	428	(5)
Using Pick from List and AutoComplete	433	(2)
Entering Data in Selected Cells	435	(5)
Constructing Basic Formulas	440	(4)
Using the SUM Function	444	(3)
Using AutoCalculate	447	(16)
Using Help	449	(1)
Concepts Review	450	(1)
Skills Review	451	(6)
Lesson Applications	457	(6)
Enhancing a Simple Worksheet	463	(36)
Selecting Multiple Columns and Rows	463	(2)
Inserting Cells, Columns, and Rows	465	(3)
Deleting Cells, Columns, and Rows	468	(1)
Using the Undo and Redo Commands	469	(1)
Using Shortcut Menus	470	(1)
Moving Data to a New Location	471	(3)
Formatting Numbers: The Basics	474	(1)
Applying Text Attributes and Cell Borders	475	(24)
Using Help	478	(2)
Concepts Review	480	(1)
Skills Review	481	(5)
Lesson Applications	486	(6)
Applications	492	(7)
Unit 2 Developing a Worksheet	499	(128)
Designing and Printing a Worksheet	501	(43)
Planning a Worksheet on Paper	502	(2)
Putting the Worksheet Plan on Screen	504	(7)
Keeping Row and Column Labels in View	511	(3)
Selecting Display Options	514	(2)
Creating User Documentation	516	(2)
Protecting Files	518	(1)
Printing Workbooks and Print Areas	519	(7)
Printing Formulas	526	(18)
Using Help	528	(1)
Concepts Review	529	(1)
Skills Review	530	(7)
Lesson Applications	537	(7)
Copying Data and Using Toolbars	544	(27)
Building a Worksheet with Copy and Paste	544	(4)
Copying Using Drag and Drop	548	(1)
Copying Using Fill and AutoFill	549	(2)
Using Toolbars in Excel	551	(20)
Using Help	557	(2)
Concepts Review	559	(1)
Skills Review	560	(5)
Lesson Applications	565	(6)
Ranges Names and Sorting	571	(23)
Naming Ranges and Constants	572	(2)
Using Names in Formulas	574	(1)
Changing and Deleting Range Names	575	(1)
Navigating Using Range Names	576	(1)
Pasting Names into Worksheets	577	(2)
Sorting Information in a Worksheet	579	(15)
Using Help	581	(1)
Concepts Review	582	(1)
Skills Review	583	(5)
Lesson Applications	588	(6)
Spelling, Find/Replace, and File Management	594	(33)
Checking Spelling	594	(3)
Using AutoCorrect	597	(2)
Finding and Replacing Data	599	(3)
Finding Files	602	(2)
Renaming, Copying, and Deleting Files	604	(23)
Using Help	606	(2)
Concepts Review	608	(1)
Skills Review	609	(5)
Lesson Applications	614	(5)
Applications	619	(8)
Outlook Lesson 2 Contacts and E-Mail	627	(24)
Creating Contacts	627	(3)
Editing and Deleting Contacts	630	(2)
Sending Contacts Via E-Mail	632	(3)
Viewing and Printing Contacts	635	(8)
Concepts Review	637	(1)
Skills Review	638	(2)
Lesson Applications	640	(3)
PowerPoint
Case Study: Good 4 U	643	(8)
Unit 1 Basic Skills	651	(72)
What is PowerPoint?	652	(32)
Starting PowerPoint	652	(3)
Navigating in PowerPoint	655	(6)
Keying Text on a Slide	661	(1)
Using the PowerPoint Views	662	(3)
Running a Slide Show	665	(3)
Naming and Saving a Presentation	668	(2)
Printing Slides and Handouts	670	(2)
Closing Presentations and Exiting PowerPoint	672	(12)
Using Help	673	(2)
Concepts Review	675	(1)
Skills Review	676	(4)
Lesson Applications	680	(4)
Basic Presentation Skills	684	(39)
Using the AutoContent Wizard	685	(2)
Changing Sample Text	687	(3)
Using the Spelling Checker and Style Checker	690	(3)
Using Find and Replace	693	(1)
Making Changes in Slide Sorter View	694	(5)
Adding Headers and Footers	699	(3)
Choosing Print Options	702	(21)
Using Help	704	(1)
Concepts Review	705	(1)
Skills Review	706	(5)
Lesson Applications	711	(6)
Applications	717	(6)
Unit 2 Developing a Presentation	723	(98)
Creating a Presentation from Scratch	724	(29)
Creating a New Presentation	725	(3)
Adding New Slides	728	(1)
Promoting and Demoting Text	729	(2)
Using the Undo and Redo Commands	731	(1)
Changing Slide Layouts	732	(2)
Applying a Design Template	734	(3)
Working with Speaker's Notes	737	(16)
Using Help	740	(1)
Concepts Review	741	(1)
Skills Review	742	(5)
Lesson Applications	747	(6)
Using the Outline Pane	753	(30)
Creating a Presentation in the Outline Pane	753	(2)
Adding a New Slide in the Outline Pane	755	(2)
Promoting and Demoting Outline Entries	757	(3)
Moving Bulleted Items in the Outline Pane	760	(2)
Moving Slides in the Outline Pane	762	(1)
Creating a Summary Slide	763	(2)
Importing and Exporting	765	(18)
Using Help	769	(2)
Concepts Review	771	(1)
Skills Review	772	(6)
Lesson Applications	778	(5)
Working with Text	783	(38)
Applying Fonts and Text Attributes to Text	783	(4)
Applying Attributes to Placeholders	787	(2)
Controlling Presentation Fonts	789	(2)
Working with Bullets	791	(4)
Changing Size and Position of Text Placeholders	795	(4)
Using Master Slides to Format Text	799	(22)
Using Help	803	(2)
Concepts Review	805	(1)
Skills Review	806	(5)
Lesson Applications	811	(5)
Applications	816	(5)
Unit 3 Customizing a Presentation	821	(124)
Working with PowerPoint Objects	822	(39)
Using Clip Art	823	(6)
Using WordArt for Special Effects	829	(2)
Working with Floating Text Boxes	831	(2)
Rotating Text	833	(2)
Working with Basic Drawing Tools	835	(5)
Using Basic AutoShapes	840	(2)
Placing Text in a Graphic Object	842	(2)
Working with Scanned Images	844	(17)
Using Help	846	(1)
Concepts Review	847	(1)
Skills Review	848	(7)
Lesson Applications	855	(6)
Working with Lines, Fills, and Colors	861	(36)
Changing the Line Color and Style of Objects	861	(4)
Changing the Fill Color of Objects	865	(1)
Adding Patterns, Shading, and Textures	866	(5)
Using the Format Painter Tool	871	(1)
Applying Design Elements to Create a Custom Template	872	(3)
Changing Clip Art Colors	875	(2)
Changing a Presentation Color Scheme	877	(3)
Changing Black and White Settings	880	(17)
Using Help	882	(2)
Concepts Review	884	(1)
Skills Review	885	(7)
Lesson Applications	892	(5)
Manipulating PowerPoint Objects	897	(48)
Selecting Multiple Objects	897	(3)
Aligning, Flipping, and Distributing Objects	900	(4)
Grouping and Ungrouping Objects	904	(2)
Working with Layers of Objects	906	(2)
Applying Object Shadows and 3-D Effects	908	(3)
Using the Duplicate Command	911	(1)
Advanced Clip Art Editing	912	(2)
Working with Toolbars	914	(31)
Using Help	916	(2)
Concepts Review	918	(1)
Skills Review	919	(9)
Lesson Applications	928	(6)
Applications	934	(11)
Outlook Lesson 3 Customizing and Managing E-Mail	945	(24)
Customizing the Look of E-Mail	945	(3)
Using Signatures	948	(1)
Managing Mail	949	(4)
Customizing Menus and Toolbars	953	(10)
Using Help	955	(1)
Concepts Review	956	(1)
Skills Review	957	(3)
Lesson Applications	960	(3)
Access
Case Study: Carolina Critters	963	(6)
Unit 1 Understanding Access Basics	969	(118)
Getting Started with a Database	970	(38)
Starting Access	971	(5)
Identifying Parts of the Access Screen	976	(1)
Working with Objects	977	(5)
Working with Tables	982	(6)
Working with Multiple Tables	988	(1)
Editing Records in a Table	989	(3)
Printing a Table	992	(3)
Compacting and Closing a Database and Exiting Access	995	(13)
Using Help	998	(1)
Concepts Review	999	(1)
Skills Review	1000	(4)
Lesson Applications	1004	(4)
Adding and Editing Data	1008	(36)
Adding and Deleting Records in Tables	1009	(3)
Using Editing Commands	1012	(5)
Adding Records with a Form	1017	(3)
Changing Views in a Form	1020	(3)
Printing a Form	1023	(4)
Editing Data in a Form	1027	(2)
Adding a Picture to a Record	1029	(15)
Using Help	1031	(2)
Concepts Review	1033	(1)
Skills Review	1034	(7)
Lesson Applications	1041	(3)
Finding and Sorting Records	1044	(43)
Using the Find Command	1045	(3)
Using Wildcards with the Find Command	1048	(2)
Using the Replace Command	1050	(2)
Sorting Records	1052	(2)
Editing an Index	1054	(2)
Using Filters	1056	(8)
Creating an Advanced Filter/Sort	1064	(2)
Using And/Or Criteria	1066	(21)
Using Help	1071	(1)
Concepts Review	1072	(1)
Skills Review	1073	(6)
Lesson Applications	1079	(3)
Applications	1082	(5)
Unit 2 Building a Database	1087
Adding Tables to a Database	1088	(45)
Creating Tables Using a Wizard	1088	(7)
Making Design Changes	1095	(7)
Using Default Values, Formats, and Input Masks	1102	(6)
Creating Tables in Design View	1108	(2)
Adding Validation Rules and Text	1110	(2)
Importing and Linking Tables	1112	(3)
Inserting a Subdatasheet	1115	(2)
Creating a Table in Datasheet View	1117	(16)
Using Help	1120	(1)
Concepts Review	1121	(1)
Skills Review	1122	(7)
Lesson Applications	1129	(4)
Adding Forms to a Database	1133	(42)
Creating Autoforms	1134	(3)
Using the Form Wizard	1137	(1)
Working with Form Sections	1138	(5)
Working with Controls on a Form	1143	(8)
Creating a Form from the Tables Window	1151	(1)
Adding a Calculated Control to a Form	1152	(3)
Creating a Form in Design View	1155	(2)
Refining the Appearance of a Form	1157	(18)
Using Help	1162	(1)
Concepts Review	1163	(1)
Skills Review	1164	(6)
Lesson Applications	1170	(5)
Adding Reports to a Database	1175
Creating a Report with the Report Wizard	1176	(4)
Working with Report Sections	1180	(2)
Adding a Group Section to a Report	1182	(2)
Working with Controls on a Report	1184	(6)
Creating a Report in Design View	1190	(6)
Adding a Calculated Control	1196	(2)
Using Format Painter and Conditional Formatting	1198	(2)
Creating a Multicolumn Report	1200
Concepts Review	1202	(1)
Skills Review	1203	(6)
Lesson Applications	1209	(3)
Applications	1212
Porfolio Builder	1	(1)
Building a Resume	5	(11)
Identifying Prospective Employees	16	(3)
Building Your Portfolio	19	(3)
Targeting Your Resume and Portfolio	22	(2)
Writing a Cover Letter	24	(3)
Filling Out an Employment Application	27	(1)
Employment Interviews	28	(2)
Following Up the Interview	30
Appendices	1	(1)
A: Windows Tutorial	2	(9)
B: Using the Mouse	11	(1)
C: Using Menus and Dialog Boxes	12	(1)
D: File Management	13	(3)
E: Proofreaders' Marks	16	(2)
F: MOUS Certification	18	(13)
G: Standard Forms for Business Topics	31
Glossary	1	(1)
Index	1