Exploring Microsoft Office 97 Professional

by Grauer, Robert T.; Barber, Maryann

• ISBN13: 9780137542505
• ISBN10: 013754250X
• Edition: 1st
• Format: Paperback
• Copyright: 1998-03-01
• Publisher: Pearson College Div

Summary

For any course teaching application software using Microsoft Office 97 applications. This book will appeal to students in a variety of disciplines including liberal arts, business, and the sciences. All books in this series offer consistent presentationcommon design, pedagogy, writing style, and level. Concepts as well as key-strokes are emphasized. Hands-on exercises in every lesson provide just the right amount of practice time. This best-selling author team's hands-on approach and conceptual framework helps students master important concepts, as well as the features of the powerful Office 97 applications.

Table of Contents

PREFACE	xi	(6)
Microsoft Office 97: Six Applications in One	xvii
EXPLORING MICROSOFT(R) WORD 97
1 Advanced Features: Outlines, Tables, Styles, and Sections	1	(54)
CHAPTER OBJECTIVES	1	(1)
OVERVIEW	1	(1)
Bullets and Lists	2	(1)
Creating an Outline	2	(2)
HANDS-ON EXERCISE 1: BULLETS, LISTS, AND OUTLINES	4	(7)
Tables	11	(2)
HANDS-ON EXERCISE 2: TABLES	13	(8)
Styles	21	(2)
The Outline View	23	(2)
The AutoFormat Command	24	(1)
HANDS-ON EXERCISE 3: STYLES	25	(8)
Working in Long Documents	33	(4)
Page Numbers	33	(1)
Headers and Footers	33	(2)
Sections	35	(1)
Table of Contents	36	(1)
The Go To Command	37	(1)
HANDS-ON EXERCISE 4: WORKING IN LONG DOCUMENTS	37	(9)
Summary	46	(1)
Key Words and Concepts	46	(1)
Multiple Choice	47	(2)
Practice with Microsoft Word	49	(5)
Case Studies	54	(1)
2 Desktop Publishing: Creating a Newsletter	55	(36)
CHAPTER OBJECTIVES	55	(1)
OVERVIEW	55	(1)
The Newsletter	56	(3)
Typography	58	(1)
The Columns Command	58	(1)
The Newsletter Wizard	59	(2)
HANDS-ON EXERCISE 1: NEWSPAPER COLUMNS	61	(9)
Elements of Graphic Design	70	(4)
The Grid	70	(2)
Clip Art	72	(1)
Emphasis	72	(2)
HANDS-ON EXERCISE 2: COMPLETE THE NEWSLETTER	74	(8)
Summary	82	(1)
Key Words and Concepts	83	(1)
Multiple Choice	83	(2)
Practice with Microsoft Word	85	(5)
Case Studies	90	(1)
3 Creating a Home Page: Introduction to HTML	91
CHAPTER OBJECTIVES	91	(1)
OVERVIEW	91	(1)
Introduction to HTML	92	(3)
Microsoft Word 97	94	(1)
Going on the Web	94	(1)
HANDS-ON EXERCISE 1: INTRODUCTION TO HTML	95	(5)
Hyperlinks	100	(3)
HANDS-ON EXERCISE 2: HYPERLINKS	103	(7)
Toward More Sophisticated Pages	110	(2)
HANDS-ON EXERCISE 3: TOWARD MORE SOPHISTICATED PAGES	112	(12)
Summary	124	(1)
Key Words and Concepts	124	(1)
Multiple Choice	124	(3)
Practice with Microsoft Word	127	(4)
Case Studies	131	(2)
APPENDIX A: OBJECT LINKING AND EMBEDDING	133	(18)
APPENDIX B: TOOLBAR SUMMARY	151	(6)
APPENDIX C: MAIL MERGE	157
EXPLORING MICROSOFT(R) EXCEL 97
1 List and Data Management: Converting Data to Information	1	(52)
CHAPTER OBJECTIVES	1	(1)
OVERVIEW	1	(1)
List and Data Management	2	(1)
Implementation in Excel	3	(4)
Data Form Command	4	(1)
Sort Command	5	(2)
Date Arithmetic	7	(1)
HANDS-ON EXERCISE 1: CREATING AND MAINTAINING A LIST	8	(7)
Data versus Information	15	(7)
AutoFilter Command	17	(1)
Advanced Filter Command	18	(1)
Criteria Range	18	(2)
Database Functions	20	(2)
Name Command	22	(1)
HANDS-ON EXERCISE 2: DATA VERSUS INFORMATION	22	(10)
Subtotals	32	(1)
Pivot Tables	33	(2)
HANDS-ON EXERCISE 3: SUBTOTALS AND PIVOT TABLES	35	(8)
Summary	43	(1)
Key Words and Concepts	43	(1)
Multiple Choice	44	(2)
Practice with Excel 97	46	(5)
Case Studies	51	(2)
2 Consolidating Data: 3-D Workbooks and File Linking	53	(40)
CHAPTER OBJECTIVES	53	(1)
OVERVIEW	53	(2)
The Three-Dimensional Workbook	55	(3)
Copying Worksheets	56	(2)
HANDS-ON EXERCISE 1: COPYING WORKSHEETS	58	(5)
Worksheet References	63	(3)
3-D Reference	65	(1)
Grouping Worksheets	65	(1)
HANDS-ON EXERCISE 2: 3-D REFERENCE	66	(7)
The Documentation Worksheet	73	(1)
HANDS-ON EXERCISE 3: THE DOCUMENTATION WORKSHEET	74	(4)
Linking Workbooks	78	(2)
HANDS-ON EXERCISE 4: LINKED WORKBOOKS	80	(4)
Summary	84	(1)
Key Words and Concepts	85	(1)
Multiple Choice	85	(2)
Practice with Excel 97	87	(4)
Case Studies	91	(2)
3 Automating Repetitive Tasks: Macros and Visual Basic	93
CHAPTER OBJECTIVES	93	(1)
OVERVIEW	93	(3)
Introduction to Macros	96	(1)
HANDS-ON EXERCISE 1: INTRODUCTION TO MACROS	96	(10)
Relative versus Absolute References	106	(2)
The Personal Macro Workbook	108	(1)
HANDS-ON EXERCISE 2: THE PERSONAL MACRO WORKBOOK	108	(7)
Data Management Macros	115	(2)
HANDS-ON EXERCISE 3: DATA MANAGEMENT MACROS	117	(8)
Creating Additional Macros	125	(1)
HANDS-ON EXERCISE 4: CREATING ADDITIONAL MACROS	126	(8)
Loops and Decision Making	134	(2)
If Statement	134	(1)
Do Statement	135	(1)
HANDS-ON EXERCISE 5: LOOPS AND DECISION MAKING	136	(7)
Summary	143	(1)
Key Words and Concepts	144	(1)
Multiple Choice	144	(2)
Practice with Excel 97	146	(4)
Case Studies	150	(1)
APPENDIX A: TOOLBARS	151	(6)
APPENDIX B: THE SPREADSHEET AUDIT	157	(14)
APPENDIX C: SOLVER	171	(18)
APPENDIX D: DATA MAPPING	189
EXPLORING MICROSOFT(R) ACCESS 97
1 One-to-Many Relationships: Subforms and Multiple Table Queries	1	(52)
CHAPTER OBJECTIVES	1	(1)
OVERVIEW	1	(1)
Case Study: Consumer Loans	2	(4)
Implementation in Access	5	(1)
Referential Integrity	6	(1)
HANDS-ON EXERCISE 1: ONE-TO-MANY RELATIONSHIPS	6	(7)
Subforms	13	(3)
The Subform Wizard	15	(1)
HANDS-ON EXERCISE 2: CREATING A SUBFORM	16	(9)
Multiple Table Queries	25	(2)
HANDS-ON EXERCISE 3: QUERIES AND REPORTS	27	(7)
Expanding the Database	34	(2)
Multiple Subforms	36	(1)
HANDS-ON EXERCISE 4: LINKED SUBFORMS	37	(7)
Summary	44	(1)
Key Words and Concepts	45	(1)
Multiple Choice	45	(2)
Practice with Access 97	47	(4)
Case Studies	51	(2)
2 Many-to-Many Relationships: A More Complex System	53	(62)
CHAPTER OBJECTIVES	53	(1)
OVERVIEW	53	(1)
Case Study: The Computer Super Store	54	(5)
The AutoNumber Field Type	57	(1)
The Relationship Window	57	(1)
Referential Integrity	58	(1)
HANDS-ON EXERCISE 1: RELATIONSHIPS AND REFERENTIAL INTEGRITY	59	(8)
Subforms, Queries, and AutoLookup	67	(3)
HANDS-ON EXERCISE 2: SUBFORMS AND MULTIPLE TABLE QUERIES	70	(9)
Advanced Queries	79	(4)
Parameter Queries	79	(2)
Total Queries	81	(2)
Learning by Doing	83	(1)
HANDS-ON EXERCISE 3: ADVANCED QUERIES	84	(8)
Expanding the Database	92	(3)
The Sales Commission Query	94	(1)
The Get External Data Command	95	(1)
HANDS-ON EXERCISE 4: EXPANDING THE DATABASE	95	(9)
Summary	104	(1)
Key Words and Concepts	105	(1)
Multiple Choice	105	(2)
Practice with Access 97	107	(5)
Case Studies	112	(3)
3 Building Applications: Introduction to Macros and Prototyping	115
CHAPTER OBJECTIVES	115	(1)
OVERVIEW	115	(1)
The Coral Springs Soccer Association	116	(1)
The Linked Tables Command	117	(2)
HANDS-ON EXERCISE 1: CREATING A USER INTERFACE	119	(10)
Macros	129	(3)
The Macro Window	129	(1)
The AutoExec Macro	130	(1)
Debugging	130	(2)
HANDS-ON EXERCISE 2: INTRODUCTION TO MACROS	132	(8)
The Player Draft	140	(4)
The Find Unmatched Query Wizard	142	(1)
Macro Groups	142	(2)
HANDS-ON EXERCISE 3: THE PLAYER DRAFT	144	(10)
Prototyping	154	(2)
HANDS-ON EXERCISE 4: PROTOTYPING	156	(8)
Summary	164	(1)
Key Words and Concepts	164	(1)
Multiple Choice	165	(2)
Practice with Access 97	167	(3)
Case Studies	170	(1)
APPENDIX A: TOOLBARS	171	(4)
APPENDIX B: DESIGNING A RELATIONAL DATABASE	175	(10)
APPENDIX C: AN ACCESS DATABASE WITH A WORD FORM LETTER	185	(10)
APPENDIX D: A SEMESTER PROJECT	195
EXPLORING MICROSOFT(R) POWERPOINT 97
1 Enhancing a Presentation: The Web and Other Resources	1
CHAPTER OBJECTIVES	1	(1)
OVERVIEW	1	(1)
Microsoft Graph	2	(3)
HANDS-ON EXERCISE 1: MICROSOFT GRAPH	5	(7)
Office Art	12	(3)
HANDS-ON EXERCISE 2: YOU DON'T HAVE TO BE AN ARTIST	15	(9)
Object Linking and Embedding	24	(4)
Microsoft Word Art	26	(1)
Organization Charts	26	(1)
Sound	26	(2)
HANDS-ON EXERCISE 3: OBJECT LINKING AND EMBEDDING	28	(12)
Resources from the Internet and World Wide Web	40	(3)
Copyright Protection	42	(1)
HANDS-ON EXERCISE 4: THE INTERNET AS A RESOURCE	43	(5)
Summary	48	(1)
Key Words and Concepts	49	(1)
Multiple Choice	49	(3)
Practice with PowerPoint 97	52	(5)
Case Studies	57	(2)
APPENDIX A: TOOLBARS	59	(6)
APPENDIX B: INTRODUCTION TO MULTIMEDIA	65
EXPLORING MICROSOFT(R) OUTLOOK 97: A DESKTOP INFORMATION MANAGER
CHAPTER OBJECTIVES	1	(1)
OVERVIEW	1	(1)
Introduction to Outlook	2	(4)
HANDS-ON EXERCISE 1: INTRODUCTION TO OUTLOOK	6	(9)
Introduction to E-Mail	15	(4)
Mail Folders	17	(1)
Anatomy of an E-Mail Message	18	(1)
Learning by Doing	19	(1)
HANDS-ON EXERCISE 2: WELCOME TO E-MAIL	19	(12)
Establishing an Internet Connection	31	(1)
Summary	32	(1)
Key Words and Concepts	32
INDEX