Preface |
|
iv | |
How to Use This Book |
|
vi | |
What's New |
|
viii | |
Start-Up Checklist |
|
ix | |
Guide for Using This Book |
|
x | |
The Microsoft Office User Specialist Program |
|
xii | |
UNIT INTRODUCTION |
|
|
Office 2000 Basics and the Internet |
|
|
2 | (1) |
|
Introduction to Office 2000 |
|
|
2 | (6) |
|
|
8 | (3) |
|
|
11 | (2) |
|
|
13 | |
UNIT INTRODUCTION TO MICROSOFT WORD |
|
|
|
2 | (16) |
|
Introduction to Word Processing |
|
|
2 | (1) |
|
Creating a New Word Document |
|
|
2 | (2) |
|
Understanding the Normal View Screen |
|
|
4 | (1) |
|
Viewing the Document Screen |
|
|
4 | (1) |
|
|
5 | (1) |
|
|
6 | (1) |
|
Navigating Through a Document |
|
|
6 | (2) |
|
|
8 | (1) |
|
Locating and Opening an Existing Document |
|
|
9 | (1) |
|
|
10 | (1) |
|
|
11 | (1) |
|
Printing in Landscape Orientation |
|
|
12 | (1) |
|
|
13 | (1) |
|
|
14 | (4) |
|
|
18 | (12) |
|
|
18 | (2) |
|
Using the Backspace and Delete Keys |
|
|
20 | (1) |
|
|
20 | (1) |
|
Using Undo, Redo, and Repeat |
|
|
20 | (2) |
|
|
22 | (3) |
|
|
25 | (5) |
|
|
30 | (14) |
|
|
30 | (6) |
|
|
36 | (1) |
|
Changing Vertical Alignment |
|
|
37 | (1) |
|
|
38 | (2) |
|
|
40 | (1) |
|
|
40 | (4) |
|
|
44 | (20) |
|
Changing Indents and Spacing |
|
|
44 | (5) |
|
|
49 | (2) |
|
|
51 | (2) |
|
Sorting Text in a Document |
|
|
53 | (1) |
|
Using Bullets and Numbering |
|
|
54 | (6) |
|
|
60 | (4) |
|
|
64 | (19) |
|
|
64 | (7) |
|
Using the Spelling and Grammar Checker |
|
|
71 | (1) |
|
Inserting the Date and Time |
|
|
72 | (1) |
|
|
73 | (1) |
|
|
74 | (2) |
|
|
76 | (3) |
|
|
79 | (4) |
|
Desktop Publishing with Word |
|
|
83 | (17) |
|
What Is Desktop Publishing? |
|
|
83 | (1) |
|
|
83 | (2) |
|
|
85 | (10) |
|
|
95 | (5) |
|
More Desktop Publishing with Word |
|
|
100 | (19) |
|
|
100 | (4) |
|
|
104 | (2) |
|
|
106 | (5) |
|
Using Borders and Shading |
|
|
111 | (3) |
|
|
114 | (5) |
|
|
119 | (21) |
|
Switching Between Documents |
|
|
119 | (1) |
|
Copying and Pasting Text Between Documents |
|
|
120 | (1) |
|
|
121 | (1) |
|
Working with Multipage Documents |
|
|
122 | (3) |
|
Inserting Headers and Footers |
|
|
125 | (2) |
|
Creating Footnotes and Endnotes |
|
|
127 | (2) |
|
Creating a Section with Formatting That Differs from Other Sections |
|
|
129 | (2) |
|
|
131 | (1) |
|
Organize a Document in Outline View |
|
|
132 | (2) |
|
Assigning Outline Levels to Paragraphs |
|
|
134 | (2) |
|
|
136 | (4) |
|
Increasing Efficiency Using Word |
|
|
140 | (1) |
|
Using Templates and Wizards |
|
|
140 | (6) |
|
Inserting and Formatting Tables |
|
|
146 | (6) |
|
Creating and Printing Envelopes |
|
|
152 | (1) |
|
Creating and Printing Labels |
|
|
153 | (1) |
|
|
154 | (4) |
|
|
158 | (2) |
|
Send a Word Document via E-mail |
|
|
160 | (1) |
|
|
161 | (3) |
|
|
164 | (4) |
|
|
168 | |
UNIT INTRODUCTION TO MICROSOFT EXCEL |
|
|
|
2 | (14) |
|
|
2 | (9) |
|
|
11 | (5) |
|
Changing the Appearance of a Worksheet |
|
|
16 | (18) |
|
|
16 | (11) |
|
|
27 | (7) |
|
|
34 | (22) |
|
Basics of Worksheet Organization |
|
|
34 | (13) |
|
|
47 | (9) |
|
|
56 | (17) |
|
|
56 | (10) |
|
|
66 | (7) |
|
|
73 | (16) |
|
|
73 | (10) |
|
|
83 | (6) |
|
Making the Worksheet Useful |
|
|
89 | (18) |
|
|
89 | (9) |
|
Inserting a Picture in a Worksheet |
|
|
98 | (4) |
|
|
102 | (5) |
|
Working with Other Software Tools |
|
|
107 | (16) |
|
Integrating Data Between Applications |
|
|
107 | (13) |
|
|
120 | (3) |
|
|
123 | (1) |
|
What Is a Worksheet Chart? |
|
|
123 | (16) |
|
|
139 | (7) |
|
|
146 | (8) |
|
|
154 | |
UNIT INTRODUCTION TO MICROSOFT ACCESS |
|
|
|
2 | (23) |
|
|
2 | (1) |
|
|
3 | (1) |
|
|
3 | (4) |
|
|
7 | (11) |
|
|
18 | (7) |
|
|
25 | (17) |
|
|
25 | (5) |
|
Changing Datasheet Layout |
|
|
30 | (6) |
|
|
36 | (6) |
|
Creating and Modifying Forms |
|
|
42 | (18) |
|
|
42 | (7) |
|
|
49 | (6) |
|
Compacting and Repairing a Database |
|
|
55 | (1) |
|
|
56 | (4) |
|
Finding and Ordering Data |
|
|
60 | (24) |
|
|
60 | (2) |
|
|
62 | (2) |
|
|
64 | (7) |
|
|
71 | (1) |
|
|
72 | (1) |
|
|
72 | (5) |
|
Creating a Multitable Query |
|
|
77 | (2) |
|
|
79 | (5) |
|
|
84 | (21) |
|
|
84 | (13) |
|
|
97 | (4) |
|
|
101 | (4) |
|
|
105 | (1) |
|
|
105 | (3) |
|
|
108 | (6) |
|
|
114 | (5) |
|
|
119 | |
UNIT INTRODUCTION TO MICROSOFT POWERPOINT |
|
|
|
2 | (17) |
|
Introduction to PowerPoint |
|
|
2 | (1) |
|
|
3 | (1) |
|
Opening an Existing Presentation |
|
|
3 | (1) |
|
|
4 | (1) |
|
Navigating Through a Presentation |
|
|
5 | (1) |
|
|
6 | (1) |
|
Applying a Design Template |
|
|
7 | (1) |
|
|
8 | (1) |
|
|
9 | (2) |
|
|
11 | (1) |
|
|
12 | (2) |
|
|
14 | (1) |
|
Closing a Presentation and Exiting PowerPoint |
|
|
15 | (1) |
|
|
16 | (3) |
|
Enhancing a PowerPoint Presentation |
|
|
19 | (20) |
|
|
19 | (2) |
|
|
21 | (1) |
|
|
22 | (2) |
|
Checking Spelling and Style |
|
|
24 | (2) |
|
|
26 | (1) |
|
Changing Alignment, Spacing, Case, and Tabs |
|
|
27 | (1) |
|
|
28 | (1) |
|
|
29 | (1) |
|
|
30 | (1) |
|
|
31 | (2) |
|
|
33 | (1) |
|
|
33 | (2) |
|
|
35 | (4) |
|
Working with Visual Elements |
|
|
39 | (20) |
|
Working with Organization Charts |
|
|
39 | (4) |
|
|
43 | (3) |
|
|
46 | (1) |
|
Creating Shapes and Objects |
|
|
47 | (2) |
|
|
49 | (5) |
|
|
54 | (1) |
|
|
55 | (4) |
|
Expanding on the Basics of PowerPoint |
|
|
59 | (1) |
|
Creating a Presentation from Existing Slides |
|
|
59 | (1) |
|
Formatting Text and Objects |
|
|
60 | (2) |
|
Delivering a Presentation |
|
|
62 | (2) |
|
Sending a Presentation via E-mail |
|
|
64 | (1) |
|
|
65 | (1) |
|
|
66 | (2) |
|
Publishing a Presentation to the Web |
|
|
68 | (2) |
|
Integrating PowerPoint and Word |
|
|
70 | (2) |
|
|
72 | (4) |
|
|
76 | |
UNIT INTRODUCTION TO MICROSOFT OUTLOOK |
|
|
|
2 | (30) |
|
|
2 | (13) |
|
|
15 | (7) |
|
|
22 | (1) |
|
|
23 | (3) |
|
|
26 | (1) |
|
|
27 | (5) |
|
|
32 | (1) |
|
|
32 | (5) |
|
|
37 | (3) |
|
|
40 | (2) |
|
|
42 | (3) |
|
|
45 | (6) |
|
|
51 | |
UNIT INTRODUCTION TO MICROSOFT PUBLISHER & MICROSOFT FRONTPAGE |
|
|
|
2 | (13) |
|
Introduction to Publisher |
|
|
2 | (9) |
|
|
11 | (4) |
|
|
15 | |
|
Introduction to FrontPage |
|
|
13 | (10) |
|
Viewing, Printing, and Publishing Your Web Page |
|
|
23 | (1) |
|
|
24 | (3) |
|
|
27 | |
Capstone Simulation |
|
1 | (1) |
Appendix A |
|
1 | (1) |
Appendix B |
|
1 | (1) |
Appendix C |
|
1 | (1) |
Glossary |
|
1 | (1) |
Index |
|
1 | |