New Perspectives On Microsoft Office 2003

by Shaffer,Ann

• ISBN13: 9780619268084
• ISBN10: 0619268085
• Edition: 2nd
• Format: Spiral Bound
• Copyright: 2005-02-10
• Publisher: Cengage Learning

Summary

Stimulate your Office course with this Second Edition of New Perspectives on Microsoft Office 2003-First Course. This book is bursting with updates and enhancements to provide students with an enriched Office learning experience. Its case-based, problem-solving approach provides in-depth coverage of the basic features of Microsoft Office 2003, as well as file management, essential computer concepts, and three integration tutorials.

Table of Contents

Preface	v
Essential Computer Concepts	1	(1)
Read This Before You Begin	2	(1)
Essential Computer Concepts	3
Paik's Oriental Rug Gallery	3	(1)
What Is a Computer?	4	(2)
Types of Computers	6	(3)
Computer Hardware	9	(13)
Input Devices	9	(2)
Output Devices	11	(2)
Processing Hardware	13	(4)
Storage Devices and Media	17	(5)
Data Communications	22	(5)
Data Bus	23	(2)
Networks	25	(1)
Telecommunications	26	(1)
The Internet	26	(1)
Computer Software	27	(8)
System Software	28	(1)
Application Software	29	(6)
Tutorial Summary	35	(1)
Key Terms	35	(2)
Review Assignments	37	(2)
Lab Assignments	39
Windows	1	(1)
Read This Before You Begin	2	(1)
Exploring the Basics of Microsoft Windows XP	3
Investigating the Windows XP Operating System	3	(1)
Session 1	4	(1)
Starting Windows XP	4	(8)
Touring the Windows XP Desktop	6	(1)
Interacting with the Desktop	6	(4)
Exploring the Start Menu	10	(2)
Running Multiple Programs	12	(2)
Switching Between Programs	13	(1)
Closing Programs from the Taskbar	14	(1)
Using Windows and Dialog Boxes	14	(9)
Manipulating Windows	16	(2)
Selecting Options from a Menu	18	(2)
Using Toolbars	20	(1)
Using List Boxes and Scroll Bars	21	(1)
Working with Dialog Boxes	22	(1)
Session 1 Quick Check	23	(1)
Session 2	24	(1)
Exploring Your Computer	24	(7)
Navigating with My Computer	24	(3)
Changing the View	27	(2)
Navigating with Windows Explorer	29	(2)
Getting Help	31	(3)
Viewing Topics on the Windows XP Help and Support Center Home Page	32	(1)
Selecting a Topic from the Index	32	(1)
Searching the Help Pages	33	(1)
Shutting Down Windows XP	34	(1)
Session 2 Quick Check	35	(1)
Tutorial Summary	35	(1)
Key Terms	36	(1)
Review Assignments	36	(1)
Case Problems	37	(3)
SAM Assessment and Training	40	(1)
Lab Assignments	40	(1)
Quick Check Answers	40
File Management	1	(1)
Read This Before You Begin	2	(1)
Managing Your Files	3
Creating and Working with Files and Folders in Windows XP	3	(1)
Organizing Files and Folders	4	(3)
Understanding the Need for Organizing Files and Folders	5	(1)
Developing Strategies for Organizing Files and Folders	6	(1)
Planning Your Organization	7	(1)
Exploring Files and Folders	7	(5)
Using Windows Explorer	9	(1)
Navigating to Your Data Files	10	(2)
Working with Folders and Files	12	(6)
Creating Folders	12	(2)
Moving and Copying Files and Folders	14	(2)
Naming and Renaming Files	16	(1)
Deleting Files and Folders	17	(1)
Working with Compressed Files	18	(2)
Quick Check	20	(1)
Tutorial Summary	21	(1)
Key Terms	21	(1)
Review Assignments	21	(1)
Case Problems	22	(2)
SAM Assessment and Training	24	(1)
Lab Assignments	24	(1)
Quick Check Answers	24
Internet	1	(1)
Read This Before You Begin	2	(1)
Browser and E-mail Basics	3
Introduction to Microsoft Internet Explorer and Microsoft Outlook Express	3	(1)
Session 1	4	(1)
The Internet and the World Wide Web	4	(3)
Home Pages and Web Browsers	6	(1)
Starting Microsoft Internet Explorer	7	(1)
Uniform Resource Locators	8	(4)
Entering a URL in the Address Bar	10	(2)
Navigating Links on a Web Page	12	(2)
Returning to the Home Page	13	(1)
Reloading a Web Page	13	(1)
Stopping a Web Page Transfer	13	(1)
Unavailable Sites	14	(1)
Using the History List	14	(1)
Using the Favorites Feature	15	(3)
Organizing Favorites	16	(2)
Printing a Web Page	18	(1)
Saving a Web Page	18	(3)
Saving a Web Page Graphic	19	(2)
Copyright Law for the Internet	21	(1)
Session 1 Quick Check	21	(1)
Session 2	22	(1)
Exploring E-mail	22	(2)
Examining How E-mail Works	22	(1)
Addressing E-mail	23	(1)
Observing E-mail Etiquette	24	(1)
Sending and Receiving E-mail Using Outlook Express	24	(6)
Viewing Sent Messages	27	(1)
Working with E-mail Messages	28	(1)
Replying to E-mail Messages	29	(1)
Deleting E-mail Messages	30	(1)
Adding Contacts to the Address Book	30	(5)
Attaching a File to a Message	32	(3)
Session 2 Quick Check	35	(1)
Tutorial Summary	35	(1)
Key Terms	35	(1)
Review Assignments	36	(1)
Case Problems	37	(2)
SAM Assessment and Training	39	(1)
Lab Assignments	39	(1)
Quick Check Answers	40
Office	1	(1)
Read This Before You Begin	2	(1)
Using Common Features of Microsoft Office 2003	3	(1)
Preparing Promotional Materials	3	(1)
Exploring Microsoft Office 2003	4	(1)
Integrating Office Programs	5	(1)
Starting Office Programs	5	(4)
Switching Between Open Programs and Files	8	(1)
Exploring Common Window Elements	9	(1)
Using the Window Sizing Buttons	9	(2)
Using Menus and Toolbars	11	(3)
Viewing Personalized Menus and Toolbars	11	(3)
Using Task Panes	14	(2)
Opening and Closing Task Panes	14	(1)
Navigating Among Task Panes	15	(1)
Using the Research Task Pane	16	(2)
Working with Files	18	(5)
Creating a File	19	(1)
Saving a File	19	(2)
Closing a File	21	(1)
Opening a File	22	(1)
Getting Help	23	(6)
Using ScreenTips	23	(1)
Using the Type a Question for Help Box	23	(2)
Using the Help Task Pane	25	(2)
Using Microsoft Office Online	27	(2)
Printing a File	29	(1)
Exiting Programs	30	(1)
Quick Check	31	(1)
Tutorial Summary	31	(1)
Key Terms	31	(1)
Review Assignments	31	(1)
SAM Assessment and Training	32	(1)
Quick Check Answers	32
Word
Read This Before You Begin	2	(1)
Creating a Document	3	(38)
Writing a Business Letter	3	(1)
Session 1.1	4	(1)
Four Steps to a Professional Document	4	(1)
Exploring the Word Window	5	(1)
Setting Up the Window Before You Begin Each Tutorial	6	(4)
Setting the Document View to Normal	6	(1)
Displaying the Toolbars, Task Pane, and Ruler	7	(1)
Setting Up Other Screen Elements	8	(1)
Displaying Nonprinting Characters	9	(1)
Beginning a Letter	10	(3)
Entering Text	13	(3)
Session 1.1 Quick Check	16	(1)
Session 1.2	16	(1)
Continuing Work on the Letter	16	(1)
Scrolling a Document	17	(3)
Correcting Errors	20	(4)
Working with AutoCorrect	21	(1)
Correcting Spelling and Grammar Errors	22	(1)
Proofreading the Letter	23	(1)
Inserting a Date with AutoComplete	24	(2)
Moving the Insertion Point Around a Document	26	(1)
Using the Undo and Redo Commands	27	(1)
Removing Smart Tags	28	(1)
Previewing and Printing a Document	29	(1)
Creating an Envelope	30	(2)
Session 1.2 Quick Check	32	(1)
Tutorial Summary	32	(1)
Key Terms	32	(1)
Review Assignments	33	(1)
Case Problems	34	(5)
Internet Assignments	39	(1)
SAM Assessment and Training	39	(1)
Lab Assignments	39	(1)
Quick Check Answers	39	(2)
Editing and Formatting a Document	41	(48)
Preparing an FAQ Document	41	(1)
Session 2.1	42	(1)
Reviewing the Document	42	(4)
Using the Spelling and Grammar Checker	46	(3)
Selecting Parts of a Document	49	(1)
Deleting Text	50	(1)
Moving Text within a Document	51	(7)
Dragging and Dropping Text	51	(3)
Cutting or Copying and Pasting Text	54	(4)
Finding and Replacing Text	58	(2)
Session 2.1 Quick Check	60	(1)
Session 2.2	60	(1)
Changing Margins and Page Orientation	60	(2)
Changing Line Spacing	62	(2)
Aligning Text	64	(1)
Indenting a Paragraph	65	(1)
Using the Format Painter	66	(2)
Adding Bullets and Numbers	68	(2)
Changing the Font and Font Size	70	(2)
Emphasizing Text Using Bold, Underline, and Italic Styles	72	(2)
Bolding Text	72	(1)
Underlining Text	73	(1)
Italicizing Text	73	(1)
Previewing Formatted Text	74	(1)
Adding Comments	75	(1)
Using the Research Task Pane	76	(2)
Session 2.2 Quick Check	78	(1)
Tutorial Summary	79	(1)
Key Terms	79	(1)
Review Assignments	79	(2)
Case Problems	81	(6)
Internet Assignments	87	(1)
SAM Assessment and Training	87	(1)
Quick Check Answers	88	(1)
Creating a Multiple-Page Report	89	(46)
Writing a Recommendation	89	(1)
Session 3.1	90	(1)
Planning the Document	90	(1)
Opening the Report	90	(2)
Setting Tab Stops	92	(4)
Formatting the Document in Sections	96	(3)
Changing the Vertical Alignment of a Section	99	(2)
Adding Headers	101	(2)
Inserting Tables	103	(5)
Creating a Table	104	(1)
Inserting a Page Break	105	(1)
Inserting a Blank Table	105	(1)
Entering Text in a Table	106	(2)
Session 3.1 Quick Check	108	(1)
Session 3.2	109	(1)
Displaying the Tables and Borders Toolbar	109	(1)
Sorting Rows in a Table	110	(1)
Modifying an Existing Table Structure	111	(4)
Inserting Columns in a Table	112	(1)
Inserting Rows in a Table	113	(1)
Deleting Rows and Columns in a Table	114	(1)
Formatting Tables	115	(3)
Changing Column Width and Row Height	115	(2)
Aligning Text Within Cells	117	(1)
Changing Borders	118	(2)
Adding Shading	120	(1)
Centering a Table	121	(1)
Reviewing a Document in Reading Layout View	122	(4)
Session 3.2 Quick Check	126	(1)
Tutorial Summary	126	(1)
Key Terms	126	(1)
Review Assignments	126	(2)
Case Problems	128	(5)
Internet Assignments	133	(1)
SAM Assessment and Training	133	(1)
Quick Check Answers	133	(2)
Desktop Publishing and Mail Merge	135
Creating a Newsletter and Cover Letter	135	(1)
Session 4.1	136	(1)
Planning the Newsletter Document	136	(1)
Elements of Desktop Publishing	136	(1)
Working with Hyperlinks	137	(2)
Using WordArt to Create a Headline	139	(7)
Selecting a WordArt Object	141	(1)
Editing a WordArt Object	142	(1)
Changing the Shape of a WordArt Object	142	(1)
Wrapping Text Below the WordArt Object	143	(1)
Positioning and Sizing the WordArt Object	144	(2)
Anchoring the WordArt Object	146	(1)
Formatting Text in Newspaper-Style Columns	147	(2)
Session 4.1 Quick Check	149	(1)
Session 4.2	149	(1)
Inserting Graphics	149	(9)
Resizing a Graphic	153	(1)
Cropping a Graphic	154	(1)
Rotating a Graphic	155	(1)
Wrapping Text Around a Graphic	156	(1)
Moving a Graphic	157	(1)
Inserting Drop Caps	158	(2)
Inserting Symbols and Special Characters	160	(2)
Balancing the Columns	162	(1)
Drawing a Border Around the Page	163	(2)
Understanding the Merge Process	165	(5)
Using the Mail Merge Task Pane	166	(1)
Selecting a Data Source	167	(1)
Inserting Merge Fields	167	(3)
Previewing the Merged Document	170	(1)
Merging the Main Document and Data Source	171	(2)
Session 4.2 Quick Check	173	(1)
Tutorial Summary	173	(1)
Key Terms	173	(1)
Review Assignments	174	(1)
Case Problems	175	(7)
Internet Assignments	182	(1)
SAM Assessment and Training	183	(1)
Quick Check Answers	183
Excel
Read This Before You Begin	2	(1)
Using Excel to Manage Data	3	(48)
Creating a Sales Order Report	3	(1)
Session 1.1	4	(1)
Introducing Excel	4	(3)
Understanding Spreadsheets	4	(1)
Parts of the Excel Window	5	(2)
Navigating a Worksheet	7	(2)
Navigating Between Worksheets	9	(1)
Developing a Worksheet	9	(2)
Entering Data into a Worksheet	11	(8)
Entering Text	11	(1)
Entering Several Lines of Text Within a Cell	12	(1)
Entering Dates	13	(1)
Entering Values	14	(1)
Entering Formulas	14	(3)
Using AutoComplete	17	(2)
Changing the Size of a Column or Row	19	(4)
Session 1.1 Quick Check	23	(1)
Session 1.2	23	(1)
Working with Ranges	23	(3)
Selecting Ranges	24	(1)
Other Selection Techniques	25	(1)
Moving a Selection of Cells	26	(2)
Calculating Sums with AutoSum	28	(2)
Working with Rows and Columns	30	(3)
Inserting a Row or Column	30	(2)
Deleting a Row or Column	32	(1)
Editing Your Worksheet	33	(1)
Undoing an Action	34	(1)
Working with Worksheets	35	(2)
Adding and Removing Worksheets	35	(1)
Renaming a Worksheet	36	(1)
Moving a Worksheet	37	(1)
Using the Spell Checker	37	(1)
Previewing and Printing a Worksheet	38	(5)
Working with Portrait and Landscape Orientation	40	(1)
Printing the Worksheet Formulas	41	(2)
Session 1.2 Quick Check	43	(1)
Tutorial Summary	43	(1)
Key Terms	44	(1)
Review Assignments	44	(2)
Case Problems	46	(3)
Internet Assignments	49	(1)
SAM Assessment and Training	50	(1)
Lab Assignments	50	(1)
Quick Check Answers	50	(1)
Working with Formulas and Functions	51	(44)
Developing a Family Budget	51	(1)
Session 2.1	52	(1)
Working with Excel Functions	52	(4)
Copying and Pasting Formulas	56	(6)
Using Relative and Absolute References	58	(3)
Working with Other Paste Options	61	(1)
Changing the Magnification of a Worksheet	62	(3)
Using the Insert Function Dialog Box	65	(3)
Filling in Formulas and Series	68	(4)
Auto Fill Options	70	(1)
Filling a Series	70	(2)
Working with Date Functions	72	(1)
Session 2.1 Quick Check	73	(1)
Session 2.2 (Optional)	74	(1)
Working with Financial Functions	74	(8)
Using the PMT Function	77	(5)
Working with Logical Functions	82	(2)
Using the IF Function	82	(2)
Session 2.2 Quick Check	84	(1)
Tutorial Summary	84	(1)
Key Terms	85	(1)
Review Assignments	85	(2)
Case Problems	87	(6)
Internet Assignments	93	(1)
SAM Assessment and Training	93	(1)
Quick Check Answers	94	(1)
Developing a Professional-Looking Worksheet	95	(50)
Formatting a Sales Report	95	(1)
Session 3.1	96	(1)
Formatting Worksheet Data	96	(6)
Using the Formatting Toolbar	97	(2)
Copying Formats	99	(1)
Using the Format Cells Dialog Box	100	(2)
Changing Font Type, Size, Style, and Color	102	(3)
Aligning Cell Contents	105	(3)
Indenting and Wrapping Text	106	(2)
Other Formatting Options	108	(1)
Working with Cell Borders and Backgrounds	108	(6)
Adding a Cell Border	108	(3)
Applying Background Colors and Patterns	111	(3)
Session 3.1 Quick Check	114	(1)
Session 3.2	114	(1)
Formatting the Worksheet	114	(5)
Merging Cells into One Cell	115	(1)
Hiding Rows, Columns and Worksheets	116	(1)
Adding a Background Image	117	(2)
Formatting Sheet Tabs	119	(1)
Clearing and Replacing Formats	119	(3)
Using Styles	122	(2)
Creating a Style	122	(1)
Applying a Style	123	(1)
Using AutoFormat	124	(2)
Formatting the Printed Worksheet	126	(9)
Defining the Page Setup	126	(2)
Working with Headers and Footers	128	(3)
Working with the Print Area and Page Breaks	131	(4)
Session 3.2 Quick Check	135	(1)
Tutorial Summary	135	(1)
Key Terms	135	(1)
Review Assignments	135	(2)
Case Problems	137	(7)
Internet Assignments	144	(1)
SAM Assessment and Training	144	(1)
Quick Check Answers	144	(1)
Working with Charts and Graphics	145
Charting Sales Data	145	(1)
Session 4.1	146	(1)
Excel Charts	146	(1)
Creating a Chart Using the Chart Wizard	147	(11)
Choosing a Chart Type	149	(2)
Choosing a Data Source	151	(2)
Choosing Chart Options	153	(3)
Choosing the Chart Location	156	(2)
Moving and Resizing an Embedded Chart	158	(1)
Updating a Chart	159	(1)
Creating a Pie Chart	159	(4)
Rotating the Pie Chart	161	(1)
Exploding a Slice of a Pie Chart	162	(1)
Session 4.1 Quick Check	163	(1)
Session 4.2	164	(1)
Modifying a Chart	164	(4)
Editing the Data Source	164	(2)
Changing the Chart Location	166	(1)
Changing Chart Options	167	(1)
Formatting Chart Elements	168	(10)
Formatting Chart Text	168	(2)
Inserting Unattached Text	170	(2)
Working with Colors and Fills	172	(2)
Using a Graphic Image as a Background	174	(2)
Changing the Axis Scale	176	(2)
Working with Three-Dimensional Charts	178	(2)
Using the Drawing Toolbar	180	(5)
Displaying the Drawing Toolbar	181	(1)
Working with AutoShapes	181	(2)
Formatting an AutoShape	183	(2)
Printing Your Charts	185	(1)
Session 4.2 Quick Check	186	(1)
Tutorial Summary	186	(1)
Key Terms	186	(1)
Review Assignments	187	(1)
Case Problems	187	(5)
Internet Assignments	192	(1)
SAM Assessment and Training	192	(1)
Quick Check Answers	192
Integration	1	(1)
Read This Before You Begin	2	(1)
Integrating Word and Excel	3	(1)
Creating a Letter that Includes a Chart and a Table	3	(1)
Object Linking and Embedding	4	(4)
Embedding an Excel Chart in a Word Document	8	(3)
Modifying an Embedded Object	11	(2)
Linking an Object from Excel to Word	13	(8)
Updating Linked Objects	16	(2)
Breaking Links	18	(3)
Quick Check	21	(1)
Tutorial Summary	21	(1)
Key Terms	21	(1)
Review Assignments	21	(1)
Case Problems	22	(2)
Quick Check Answers	24
Access
Read This Before You Begin	2	(1)
Introduction to Microsoft Access 2003	3	(32)
Viewing and Working with a Table Containing Employer Data	3	(1)
Session 1.1	4	(1)
Introduction to Database Concepts	4	(3)
Organizing Data	4	(1)
Databases and Relationships	5	(1)
Relational Database Management Systems	6	(1)
Opening an Existing Database	7	(3)
Exploring the Access and Database Windows	9	(1)
Opening an Access Table	10	(2)
Navigating an Access Datasheet	11	(1)
Printing a Datasheet	12	(1)
Saving a Database	12	(1)
Session 1.1 Quick Check	13	(1)
Session 1.2	13	(1)
Working with Queries	13	(5)
Opening an Existing Query	14	(1)
Creating, Sorting, and Navigating a Query	15	(3)
Creating and Navigating a Form	18	(2)
Creating, Previewing, and Navigating a Report	20	(4)
Printing Specific Pages of a Report	23	(1)
Managing a Database	24	(4)
Backing up and Restoring a Database	24	(1)
Compacting and Repairing a Database	25	(1)
Compacting a Database Automatically	26	(1)
Converting an Access 2000 Database	27	(1)
Session 1.2 Quick Check	28	(1)
Tutorial Summary	29	(1)
Key Terms	29	(1)
Review Assignments	29	(1)
Case Problems	30	(3)
Internet Assignments	33	(1)
SAM Assessment and Training	33	(1)
Lab Assignments	34	(1)
Quick Check Answers	34	(1)
Creating and Maintaining a Database	35	(46)
Creating the Northeast Database, and Creating, Modifying, and Updating the Position Table	35	(1)
Session 2.1	36	(1)
Guidelines for Designing Databases	36	(2)
Guidelines for Setting Field Properties	38	(3)
Naming Fields and Objects	38	(1)
Assigning Field Data Types	38	(1)
Setting Field Sizes	39	(1)
Setting Field Captions	40	(1)
Creating a New Database	41	(1)
Creating a Table	42	(8)
Defining Fields	43	(7)
Specifying the Primary Key	50	(3)
Saving the Table Structure	52	(1)
Session 2.1 Quick Check	53	(1)
Session 2.2	53	(1)
Adding Records to a Table	53	(3)
Modifying the Structure of an Access Table	56	(9)
Deleting a Field	57	(1)
Moving a Field	58	(1)
Adding a Field	59	(1)
Changing Field Properties	60	(1)
Updating Field Property Changes	61	(4)
Obtaining Data from Another Access Database	65	(3)
Copying Records from Another Access Database	65	(2)
Importing a Table from Another Access Database	67	(1)
Updating a Database	68	(3)
Deleting Records	68	(1)
Changing Records	69	(2)
Session 2.2 Quick Check	71	(1)
Tutorial Summary	71	(1)
Key Terms	72	(1)
Review Assignments	72	(2)
Case Problems	74	(5)
Internet Assignments	79	(1)
SAM Assessment and Training	80	(1)
Quick Check Answers	80	(1)
Querying a Database	81	(48)
Retrieving Information About Employers and Their Positions	81	(1)
Session 3.1	82	(1)
Introduction to Queries	82	(1)
Query Window	82	(2)
Creating and Running a Query	84	(3)
Updating Data Using a Query	87	(1)
Defining Table Relationships	87	(6)
One-to-Many Relationships	88	(1)
Referential Integrity	89	(1)
Defining a Relationship Between Two Tables	89	(4)
Creating a Multi-table Query	93	(2)
Sorting Data in a Query	95	(5)
Using a Toolbar Button to Sort Data	95	(1)
Sorting Multiple Fields in Design View	96	(4)
Filtering Data	100	(2)
Session 3.1 Quick Check	102	(1)
Session 3.2	102	(1)
Defining Record Selection Criteria for Queries	102	(5)
Specifying an Exact Match	103	(2)
Changing a Datasheet's Appearance	105	(1)
Using a Comparison Operator to Match a Range of Values	106	(1)
Defining Multiple Selection Criteria for Queries	107	(5)
The And Logical Operator	108	(1)
Using Multiple Undo and Redo	109	(2)
The Or Logical Operator	111	(1)
Performing Calculations	112	(9)
Creating a Calculated Field	113	(4)
Using Aggregate Functions	117	(2)
Using Record Group Calculations	119	(2)
Session 3.2 Quick Check	121	(1)
Tutorial Summary	121	(1)
Key Terms	121	(1)
Review Assignments	122	(1)
Case Problems	123	(4)
Internet Assignments	127	(1)
SAM Assessment and Training	128	(1)
Quick Check Answers	128	(1)
Creating Forms and Reports	129
Creating a Position Data Form, an Employer Positions Form, and an Employers and Positions Report	129	(1)
Session 4.1	130	(1)
Creating a Form Using the Form Wizard	130	(3)
Changing a Form's AutoFormat	133	(2)
Finding Data Using a Form	135	(3)
Previewing and Printing Selected Form Records	138	(1)
Maintaining Table Data Using a Form	139	(2)
Session 4.1 Quick Check	141	(1)
Session 4.2	142	(1)
Creating a Form with a Main Form and a Subform	142	(5)
Modifying a Form in Design View	145	(2)
Creating a Report Using the Report Wizard	147	(11)
Checking Errors in a Report	155	(3)
Inserting a Picture in a Report	158	(2)
Session 4.2 Quick Check	160	(1)
Tutorial Summary	161	(1)
Key Terms	161	(1)
Review Assignments	161	(2)
Case Problems	163	(5)
Internet Assignments	168	(1)
SAM Assessment and Training	168	(1)
Quick Check Answers	168
Integration	1	(1)
Read This Before You Begin	2	(1)
Integrating Word, Excel, and Access	3	(1)
Creating a Brochure	3	(1)
Planning the Brochure	4	(1)
Using the Task Panes	5	(8)
Collecting Information on the Clipboard Task Pane	5	(2)
Finding Files Using the File Search Task Panes	7	(3)
Pasting Items from the Clipboard Task Pane	10	(3)
Using Excel Data in Access	13	(3)
Preparing an Excel List for Import	13	(1)
Importing an Excel List into an Access Table	14	(2)
Using Access Data in a Word Document	16	(5)
Querying Data in an Access Database	16	(3)
Exporting a Query from Access to Word	19	(2)
Quick Check	21	(1)
Tutorial Summary	21	(1)
Key Terms	21	(1)
Review Assignments	21	(2)
Case Problems	23	(1)
Quick Check Answers	24
PowerPoint
Read This Before You Begin	2	(1)
Creating a Presentation	3	(38)
Presenting Information About Humanitarian Projects	3	(1)
Session 1.1	4	(1)
What Is PowerPoint?	4	(1)
Opening an Existing PowerPoint Presentation	5	(1)
Switching Views and Navigating a Presentation	6	(1)
Viewing a Presentation in Slide Show View	7	(3)
Planning a Presentation	10	(1)
Using the AutoContent Wizard	10	(3)
Session 1.1 Quick Check	13	(1)
Session 1.2	13	(1)
Modifying a Presentation	13	(11)
Editing Slides	14	(3)
Deleting Slides	17	(2)
Adding a New Slide and Choosing a Layout	19	(2)
Promoting, Demoting, and Moving Outline Text	21	(2)
Moving Slides in Slide Sorter View	23	(1)
Checking the Spelling and Style in a Presentation	24	(5)
Checking the Spelling	24	(1)
Using the Style Checker	25	(2)
Using the Research Task Pane	27	(2)
Creating Speaker Notes	29	(1)
Previewing and Printing a Presentation	30	(2)
Session 1.2 Quick Check	32	(1)
Tutorial Summary	33	(1)
Key Terms	33	(1)
Review Assignments	33	(1)
Case Problems	34	(6)
Internet Assignments	40	(1)
SAM Assessment and Training	40	(1)
Quick Check Answers	40	(1)
Applying and Modifying Text and Graphic Objects	41
Presenting and Preparing for an Expedition to Peru	41	(1)
Session 2.1	42	(1)
Planning a Presentation	42	(1)
Creating a New Presentation from a Design Template	42	(2)
Applying a Design Template	44	(1)
Understanding Graphics	45	(5)
Inserting Clip Art	46	(1)
Resizing Clip Art	47	(1)
Recoloring Clip Art	48	(2)
Modifying the Design Template in the Slide Master	50	(2)
Inserting and Modifying a Bitmap Image on a Slide	52	(3)
Modifying Text on a Slide	55	(3)
Modifying the Format of Text on a Slide	55	(2)
Resizing a Text Box on a Slide	57	(1)
Applying a Second Design Template	58	(2)
Adding and Modifying Tab Stops	60	(2)
Inserting Footers and Slide Numbers	62	(3)
Session 2.1 Quick Check	65	(1)
Session 2.2	66	(1)
Creating a Table in a Slide	66	(3)
Creating a Diagram on a Slide	69	(3)
Creating and Manipulating a Shape	72	(2)
Inserting Text Boxes	74	(3)
Adding Text to the Diagram	74	(1)
Rotating and Moving Text Boxes	75	(2)
Adding a Summary Slide	77	(2)
Session 2.2 Quick Check	79	(1)
Tutorial Summary	79	(1)
Key Terms	79	(1)
Review Assignments	79	(2)
Case Problems	81	(5)
Internet Assignments	86	(1)
SAM Assessment and Training	86	(1)
Quick Check Answers	87
Integration	1	(1)
Read This Before You Begin	2	(1)
Integrating Word, Excel, Access, and PowerPoint	3
Creating a Form Letter and an Integrated Presentation	3	(1)
Planning the Form Letter	4	(1)
Merging Access Data with a Word Document	4	(7)
Selecting a Starting Document and Recipients	5	(2)
Inserting the Merge Fields	7	(3)
Performing the Mail Merge	10	(1)
Creating a Word Outline	11	(3)
Creating PowerPoint Slides from a Word Outline	14	(2)
Copying and Pasting an Access Query into a PowerPoint Presentation	16	(2)
Linking an Excel Chart to a PowerPoint Presentation	18	(2)
Quick Check	20	(1)
Tutorial Summary	21	(1)
Key Terms	21	(1)
Review Assignments	21	(2)
Case Problems	23	(1)
Quick Check Answers	24
Internet	1	(1)
Read This Before You Begin	2	(1)
Creating Web Pages with Microsoft Office 2003	3
Using Word, Excel, Access, and PowerPoint to Create Web Pages	3	(1)
Sharing Office Files Online	4	(1)
Creating Web Pages in Word	5	(6)
Inserting Hyperlinks	11	(1)
Previewing Web Pages in a Browser	12	(1)
Creating Web Pages in Excel	13	(7)
Creating Web Pages in Access	20	(6)
Creating Web Pages in PowerPoint	26	(3)
Publishing Web Pages	29	(1)
Quick Check	30	(1)
Tutorial Summary	30	(1)
Key Terms	30	(1)
Review Assignments	30	(2)
SAM Assessment and Training	32	(1)
Lab Assignments	32	(1)
Quick Check Answers	32
Glossary/Index	1	(24)
Task Reference	25