A Professional Approach Series: Office 2000 Advanced Course Student Edition

by Hinkle, Deborah

• ISBN13: 9780028055930
• ISBN10: 0028055934
• Edition: Student
• Format: Paperback
• Copyright: 2000-01-21
• Publisher: MCG

Summary

Office 2000: Advanced 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 Tables and Columns	11	(60)
Tables	12	(33)
Creating a Table	12	(4)
Key and Edit in a Table	16	(2)
Selecting Cells, Rows, and Columns	18	(2)
Editing Table Structures	20	(7)
Formatting Tables and Cell Contents	27	(5)
Converting Tables and Text	32	(13)
Using Help	34	(1)
Concepts Review	35	(1)
Skills Review	36	(4)
Lesson Applications	40	(5)
Columns	45	(26)
Creating Multiple-Column Layouts	45	(4)
Keying and Editing Text in Columns	49	(1)
Formatting Columns and Column Text	50	(2)
Controlling Column Breaks	52	(19)
Using Help	54	(2)
Concepts Review	56	(1)
Skills Review	57	(4)
Lesson Applications	61	(4)
Applications	65	(6)
Unit 2 Advanced Topics	71	(132)
Styles	72	(27)
Applying Styles	72	(2)
Creating New Styles	74	(2)
Redefining, Modifying, and Renaming Styles	76	(3)
Using Style Options	79	(3)
Using AutoFormat and the Style Gallery	82	(3)
Creating Automatic Styles	85	(14)
Using Help	87	(1)
Concepts Review	88	(1)
Skills Review	89	(6)
Lesson Applications	95	(4)
Templates and Wizards	99	(26)
Using Word's Templates	99	(4)
Creating New Templates	103	(2)
Attaching Templates to Documents	105	(2)
Modifying Templates	107	(2)
Using the Organizer	109	(4)
Using Word's Wizards	113	(12)
Using Help	114	(1)
Concepts Review	115	(1)
Skills Review	116	(5)
Lesson Applications	121	(4)
Graphics	125	(40)
Inserting Pictures	125	(2)
Moving and Formatting Pictures	127	(9)
Drawing Shapes	136	(3)
Selecting, Sizing, Moving, and Copying Shapes	139	(4)
Formatting Shapes	143	(3)
Drawing AutoShapes	146	(3)
Ordering, Grouping, and Aligning Shapes	149	(2)
Inserting WordArt	151	(14)
Using Help	153	(1)
Concepts Review	154	(1)
Skills Review	155	(5)
Lesson Applications	160	(5)
Mail Merge	165	(38)
Creating a Main Document	166	(2)
Creating a Data Source	168	(4)
Inserting Merge Fields into a Main Document	172	(3)
Initiating a Mail Merge	175	(3)
Editing an Existing Data Source	178	(1)
Creating Mailing Labels	179	(24)
Using Help	181	(1)
Concepts Review	182	(1)
Skills Review	183	(6)
Lesson Applications	189	(5)
Applications	194	(9)
2000 Outlook Outlook Lesson 1 Using Outlook's Calendar	203	(40)
Navigating within the Calendar	203	(2)
Scheduling Appointments	205	(4)
Planning Meetings	209	(6)
Scheduling Events	215	(2)
Customizing the Calendar	217	(5)
Printing the Calendar	222	(13)
Using Help	225	(2)
Concepts Review	227	(2)
Skills Review	229	(2)
Lesson Applications	231	(4)
Excel
Case Study	235	(8)
Unit 1 Changing the Appearance of a Worksheet	243	(60)
Formatting Text and Numbers	245	(27)
Formatting Numbers	245	(4)
Suppressing the Display of Zero Values	249	(1)
Working with Stored Numbers	250	(1)
Aligning Text	251	(4)
Changing Column Width and Row Height	255	(4)
Hiding Columns and Rows	259	(13)
Using Help	260	(2)
Concepts Review	262	(1)
Skills Review	263	(4)
Lesson Applications	267	(5)
Changing Fonts, Patterns, Colors, and Formats	272	(31)
Working with Fonts	272	(4)
Adding Borders	276	(3)
Using Patterns and Colors	279	(2)
Coloring Borders	281	(1)
Copying Cell Formatting	281	(1)
Working with Styles and Autoformats	282	(3)
Creating Hyperlinks	285	(18)
Using Help	287	(2)
Concepts Review	289	(1)
Skills Review	290	(4)
Lesson Applications	294	(4)
Applications	298	(5)
Unit 2 Formulas and Advanced Printing	303	(114)
Using Functions	305	(25)
Entering Functions	305	(1)
Using the AVERAGE Function	306	(1)
Using the MIN and MAX Functions	307	(3)
Using the COUNT Function	310	(2)
Using the COUNTA Function	312	(1)
Using the INT and ROUND Functions	313	(3)
Using Nested Functions	316	(14)
Using Help	318	(1)
Concepts Review	319	(1)
Skills Review	320	(4)
Lesson Applications	324	(6)
Advanced Formulas	330	(30)
Using Absolute and Mixed Cell References	331	(3)
Creating an IF Function	334	(1)
Using IF Functions with Multiple Conditions	335	(4)
Using IF Functions to Insert Text	339	(1)
Using VLOOKUP and HLOOKUP	340	(2)
Using Comments to Annotate Formulas	342	(2)
Correcting Circular References	344	(16)
Using Help	345	(1)
Concepts Review	346	(1)
Skills Review	347	(5)
Lesson Applications	352	(8)
Dates, Times, and Financial Functions	360	(27)
Working with Dates	360	(2)
Working with Date Functions	362	(1)
Using Date Math	363	(4)
Working with Time Functions	367	(3)
Working with Financial Functions	370	(17)
Using Help	376	(2)
Concepts Review	378	(1)
Skills Review	379	(3)
Lesson Applications	382	(5)
Advanced Printing	387	(30)
Inserting and Removing Page Breaks	387	(3)
Scaling a Worksheet	390	(1)
Adding Print Titles	390	(2)
Changing Margins in Print Preview	392	(1)
Changing Column Widths in Print Preview	393	(1)
Modifying Preset Headers and Footers	394	(1)
Changing Page Order and Printing	395	(1)
Printing Named Ranges	396	(21)
Using Help	397	(1)
Concepts Review	398	(1)
Skills Review	399	(5)
Lesson Applications	404	(5)
Applications	409	(8)
Unit 3 Graphics	417	(70)
Creating Charts	419	(26)
Identifying Chart Types and Chart Objects	419	(3)
Using the Chart Wizard to Create an Embedded Chart	422	(3)
Sizing and Moving a Chart	425	(1)
Editing a Chart	426	(5)
Saving and Printing a Chart	431	(1)
Creating a Chart on a Chart Sheet	432	(13)
Using Help	433	(2)
Concepts Review	435	(1)
Skills Review	436	(4)
Lesson Applications	440	(5)
Enhancing Charts and Worksheets	445	(42)
Formatting Chart Text	445	(2)
Enhancing the Legend	447	(2)
Changing Data Series Colors and Patterns	449	(1)
Adding Backgrounds and Borders	450	(1)
Adding and Formatting Objects	451	(6)
Sizing, Moving, and Copying Objects	457	(2)
Working with 3-D Shapes	459	(4)
Importing Clip Art	463	(3)
Using Help	466	(2)
Concepts Review	468	(1)
Skills Review	469	(6)
Lesson Applications	475	(12)
Applications	480	(7)
Unit 4 Linking and Consolidating Worksheets	487	(60)
Working with Multiple Worksheets	489	(28)
Managing Worksheets	489	(5)
Opening Multiple Workbooks	494	(2)
Arranging Workbook Windows	496	(4)
Saving a Workspace File	500	(1)
Copying and Pasting Between Workbooks	500	(3)
Using Help	503	(1)
Concepts Review	504	(1)
Skills Review	505	(6)
Lesson Applications	511	(6)
Consolidating Worksheets and Exchanging Data	517	(30)
Linking Multiple Files through Formulas	517	(4)
Designing Worksheets for Consolidation	521	(2)
Creating the Consolidated Worksheet	523	(24)
Using Help	527	(1)
Concepts Review	528	(1)
Skills Review	529	(6)
Lesson Applications	535	(5)
Applications	540	(7)
2000 Outlook Outlook Lesson 2 Using Outlook's Task and Notes	547	(40)
Creating and Updating Tasks	548	(4)
Assigning Tasks	552	(4)
Accepting and Declining Tasks	556	(3)
Viewing, Organizing, and Printing Tasks	559	(5)
Creating and Editing Notes	564	(2)
Viewing, Organizing, and Printing Notes	566	(2)
Customizing Notes	568	(11)
Using Help	570	(2)
Concepts Review	572	(1)
Skills Review	573	(3)
Lesson Applications	576	(3)
PowerPoint
Case Study	579	(8)
Unit 1 Advanced Techniques	587	(102)
Advanced Text Manipulation	588	(32)
Working with Indents	588	(3)
Working with Tabs	591	(4)
Controlling Line Spacing	595	(2)
Working with Text Box Settings	597	(3)
Working with Page Setup Options	600	(2)
Customizing Handout and Notes Masters	602	(18)
Using help	604	(1)
Concepts Review	605	(1)
Skills Review	606	(6)
Lesson Applications	612	(8)
Advanced Drawing Techniques	620	(28)
Using Guides to Position and Measure Objects	620	(4)
Using Zoom	624	(1)
Exploring the Snap and Nudge Features	624	(2)
Using the Freeform Tool	626	(4)
Editing a Freeform Drawing	630	(2)
Using the Curve Tool	632	(16)
Using Help	634	(1)
Concepts Review	635	(1)
Skills Review	636	(7)
Lesson Applications	643	(175)
Concepts Review	818
Animation and Slide Show Effects	648	(41)
Adding Slide Transitions	648	(4)
Animating Text	652	(3)
Adding Object Animations and Other Effects	655	(1)
Adding Sound and Motion Clips	656	(4)
Adding Animation Effects to a Template	660	(1)
Adding Links	661	(4)
Set Automatic Slide Timings	665	(24)
Using Help	667	(2)
Concepts Review	669	(1)
Skills Review	670	(5)
Lesson Applications	675	(5)
Applications	680	(9)
Unit 2 Charts and Tables	689	(110)
Creating a Chart	690	(35)
Inserting a Chart	690	(1)
Changing Sample Data	691	(4)
Viewing the New Chart	695	(1)
Editing a Chart	695	(2)
Formatting a Chart	697	(6)
Adding Shapes and Text Objects	703	(1)
Inserting Other Chart Types	704	(6)
Animating Chart Elements	710	(15)
Using Help	711	(1)
Concepts Review	712	(1)
Skills Review	713	(8)
Lesson Applications	721	(4)
Creating a Table	725	(35)
Creating a Table	726	(1)
Keying a Text in a Table	727	(1)
Selecting a Table, Table Cells, and Text	728	(2)
Formatting a Table	730	(4)
Aligning Text and Numbers in a Table	734	(2)
Changing the Height and Width of Rows, Columns, and Tables	736	(2)
Inserting and Deleting Rows, Columns, and Individual Cells	738	(5)
Inserting a Microsoft Word Table	743	(17)
Using Help	745	(1)
Concepts Review	746	(1)
Skills Review	747	(8)
Lesson Applications	755	(5)
Creating Flowcharts and Organization Charts	760	(39)
Drawing Flowchart AutoShapes	760	(2)
Connecting Flowchart AutoShapes	762	(3)
Creating an Organization Chart	765	(2)
Adding Organization Chart Boxes	767	(3)
Rearranging Organization Chart Boxes	770	(2)
Formatting Organization Chart Elements	772	(27)
Using Help	775	(2)
Concepts Review	777	(1)
Skills Review	778	(7)
Lesson Applications	785	(6)
Applications	791	(8)
Unit 3 Delivering Presentations	799	(30)
Distributing and Presenting Your Work	800	(29)
Using Meeting Minder to Record Notes During a Presentation	800	(4)
Distributing Your Work in Other Formats	804	(5)
Packaging Presentations for Other Computers (Pack and Go)	809	(4)
Preparing Presentations for the Web	813	(16)
Using Help	817	(1)
Concepts Review	818	(1)
Skills Review	819	(5)
Lesson Applications	824	(2)
Applications	826	(3)
2000 Outlook Outlook Lesson 3 Integrating Outlook's Features	829	(38)
Using Mail Templates	829	(3)
Using Mail with Other Outlook Components	832	(2)
Integrating Calendar with Other Outlook Components	834	(2)
Moving Items Between Folders	836	(2)
Managing and Organizing Contacts	838	(5)
Creating Tasks from Other Outlook Components	843	(1)
Using the Office Clipboard	844	(1)
Creating Office Documents Inside Outlook	845	(14)
Using Help	849	(1)
Concepts Review	850	(1)
Skills Review	851	(4)
Lesson Applications	855	(4)
Access
Case Study	859	(8)
Unit 1 Getting Information from a Database	867	(102)
Designing Queries	868	(33)
Viewing and Creating a Select Query	869	(6)
Making Changes in the Dynaset and Design View	875	(3)
Sorting in a Query	878	(1)
Using a Query for a Report	879	(1)
Setting Criteria in a Query	880	(4)
Using ``AND'' and ``OR'' Criteria	884	(2)
Using Query Properties	886	(3)
Adding a Calculated Field to a Query	889	(12)
Using Help	890	(2)
Concepts Review	892	(1)
Skills Review	893	(5)
Lesson Applications	898	(3)
Using Joins and Relationships	901	(34)
Creating a Multiple Table Query	902	(2)
Creating and Editing Joins	904	(1)
Creating Relationships	905	(9)
Enforcing Referential Integrity	914	(2)
Setting Cascade Update and Cascade Delete	916	(2)
Creating a Lookup Field	918	(2)
Editing Records with a Lookup Field	920	(2)
Printing Relationships	922	(13)
Using Help	923	(1)
Concepts Review	924	(1)
Skills Review	925	(6)
Lesson Applications	931	(4)
Designing Advanced Queries	935	(34)
Creating Summary Queries	935	(3)
Creating a Crosstab Query	938	(2)
Designing Parameter Queries	940	(3)
Creating an Update Query	943	(2)
Using a Make-Table Query	945	(2)
Creating a Delete Query	947	(1)
Creating an Append Query	948	(2)
Using Specialized Query Wizards	950	(19)
Using Help	954	(1)
Concepts Review	955	(1)
Skills Review	956	(6)
Lesson Applications	962	(3)
Applications	965	(4)
Unit 2 Printing and Integrating Data	969	(126)
Working with Report Wizards and Labels	970	(38)
Creating a Columnar AutoReport	971	(2)
Modifying Controls	973	(4)
Creating a Tabular AutoReport	977	(3)
Using Multiple Groups in a Summary Report	980	(4)
Using Page Breaks in a Report	984	(2)
Adding Images to a Report	986	(5)
Creating Labels	991	(17)
Using Help	995	(2)
Concepts Review	997	(1)
Skills Review	998	(7)
Lesson Applications	1005	(3)
Working with Subreports	1008	(40)
Creating Queries for Main and Subreports	1009	(3)
Creating the Main Report	1012	(2)
Using Text Expressions	1014	(5)
Creating a Subreport	1019	(4)
Adding a Subreport to the Main Report	1023	(2)
Editing Subreports	1025	(3)
Adding Calculations to the Main Report	1028	(2)
Building a Subreport in the Wizard	1030	(18)
Using Help	1033	(2)
Concepts Review	1035	(1)
Skills Review	1036	(7)
Lesson Applications	1043	(5)
Integrating Access with Other Data	1048	(47)
Creating a Chart	1049	(6)
Creating a New Database	1055	(5)
Importing Spreadsheet or Text Data	1060	(4)
Exporting Data to Excel or Word	1064	(5)
Exporting Data to HTML	1069	(2)
Creating a Data Access Page	1071	(4)
Creating a Mail/Merge Document	1075	(20)
Using Help	1077	(1)
Concepts Review	1078	(1)
Skills Review	1079	(6)
Lesson Applications	1085	(3)
Applications	1088	(7)
Unit 3 Viewing Information in a Database	1095	(124)
Building Forms with Subforms	1096	(38)
Creating a Main Form	1097	(2)
Formatting a Main Form	1099	(3)
Creating a Subform	1102	(3)
Adding a Subform to a Main Form	1105	(1)
Modifying a Subform Control and a Subform	1106	(5)
Adding a Command Button to a Form	1111	(2)
Creating a Form and Subform with the Wizard	1113	(3)
Creating a Grouped Data Access Page	1116	(18)
Using Help	1123	(1)
Concepts Review	1124	(1)
Skills Review	1125	(6)
Lesson Applications	1131	(3)
Enhancing Forms	1134	(44)
Adding and Formatting an Option Group	1134	(7)
Changing Control Types	1141	(1)
Using List and Combo Boxes	1142	(4)
Creating Multipage Forms	1146	(5)
Adding a Hyperlink to a Form	1151	(1)
Adding a Chart and an Image to a Form	1152	(4)
Creating a Switchboard	1156	(3)
Using Database Tools	1159	(19)
Using Help	1164	(2)
Concepts Review	1166	(1)
Skills Review	1167	(7)
Lesson Applications	1174	(4)
Using Macros in Forms	1178	(41)
Running a Macro from a Command Button	1178	(2)
Viewing and Editing a Macro	1180	(3)
Creating a Macro	1183	(5)
Naming and Grouping Macros	1188	(3)
Using SendKeys, RunCommand, and the AutoKeys Macro	1191	(5)
Using Conditions in a Macro	1196	(6)
Writing an AutoExec Macro	1202	(17)
Using Help	1203	(1)
Concepts Review	1204	(1)
Skills Review	1205	(6)
Lesson Applications	1211	(3)
Applications	1214	(5)
Office 2000 Integration Lesson 1 Specialized Integration	1219	(1)
Using Delimited Data to Create an Excel Worksheet	1220	(3)
Creating an Excel Worksheet in Word	1223	(1)
Sending a Word Document to PowerPoint	1224	(1)
Sending a PowerPoint Presentation to Word	1225	(2)
Concepts Review	1227	(1)
Skills Review	1228	(3)
Lesson Applications	1231
Portfolio Builder	P-1
Building a Resume	P-5
Identifying Prospective Employers	P-16
Building Your Portfolio	P-19
Targeting Your Resume and Portfolio	P-22
Writing a Cover Letter	P-24
Filling Out an Employment Application	P-27
Employment Interviews	P-28
Following Up the Interview	P-30
Appendices	A-1
A: Windows Tutorial	A-2
B: Using the Mouse	A-11
C: Using Menus and Dialog Boxes	A-12
D: File Management	A-13
E: Proofreaders' Marks	A-16
F: MOUS Certification	A-18
G 1. Standard Forms for Business Documents	A-29
G 2. Advanced Presentation Delivery Options	A-31
G 3. Learning about Database Management	A-41
G 4. Designing a Database	A-43
Glossary	G-1
Index	I-1