| Project 1 Getting Started with MS Office Professional |
|
1 | (1) |
|
Opening, Switching, and Closing Microsoft Office Applications |
|
|
2 | (6) |
|
|
|
8 | (3) |
|
Saving and Closing an Office Document |
|
|
11 | (2) |
|
Opening an Existing Document and Saving It with a New Name |
|
|
13 | (3) |
|
Using the Microsoft Office Shortcut Bar |
|
|
16 | (5) |
|
|
|
21 | |
|
|
|
27 | (2) |
|
|
|
29 | (1) |
|
|
|
29 | (3) |
|
|
|
32 | |
| Project 2 Working with Word Documents |
|
1 | (26) |
|
Opening an Existing Document |
|
|
2 | (2) |
|
Moving around in a Document |
|
|
4 | (3) |
|
|
|
7 | (4) |
|
|
|
11 | (3) |
|
|
|
14 | (13) |
|
|
|
17 | (1) |
|
|
|
18 | (3) |
|
|
|
21 | (6) |
|
|
|
21 | (2) |
|
|
|
23 | (4) |
| Project 3 Editing Word Documents |
|
27 | (28) |
|
|
|
28 | (4) |
|
|
|
32 | (3) |
|
|
|
35 | (4) |
|
|
|
39 | (2) |
|
Checking a Document for Spelling and Grammatical Errors |
|
|
41 | (5) |
|
|
|
46 | (9) |
|
|
|
47 | (1) |
|
|
|
48 | (3) |
|
|
|
51 | (4) |
|
|
|
51 | (2) |
|
|
|
53 | (2) |
| Project 4 Formatting Word Documents |
|
55 | (30) |
|
|
|
56 | (2) |
|
|
|
58 | (3) |
|
|
|
61 | (2) |
|
|
|
63 | (3) |
|
|
|
66 | (2) |
|
|
|
68 | (2) |
|
Changing the Font and Font Size |
|
|
70 | (4) |
|
|
|
74 | (11) |
|
|
|
76 | (1) |
|
|
|
77 | (3) |
|
|
|
80 | (5) |
|
|
|
80 | (3) |
|
|
|
83 | (2) |
| Project 5 Using Tables and Graphics in Word |
|
85 | |
|
|
|
86 | (3) |
|
Entering Text into a Table |
|
|
89 | (2) |
|
|
|
91 | (4) |
|
Calculating Values in a Table |
|
|
95 | (3) |
|
|
|
98 | (3) |
|
Moving and Resizing a Picture |
|
|
101 | |
|
|
|
106 | (1) |
|
|
|
107 | (3) |
|
|
|
110 | |
|
|
|
110 | (3) |
|
|
|
113 | |
| Project 6 Building a Spreadsheet |
|
1 | (26) |
|
Opening an Existing Worksheet |
|
|
2 | (2) |
|
Selecting Worksheet Items |
|
|
4 | (2) |
|
|
|
6 | (3) |
|
Adding and Removing Rows and Columns |
|
|
9 | (3) |
|
Undoing and Redoing Actions |
|
|
12 | (1) |
|
|
|
13 | (3) |
|
|
|
16 | (11) |
|
|
|
19 | (1) |
|
|
|
20 | (3) |
|
|
|
23 | (4) |
|
|
|
23 | (1) |
|
|
|
24 | (3) |
| Project 7 Creating Formulas |
|
27 | (22) |
|
Creating Formulas Using Mathematical Operators |
|
|
28 | (3) |
|
Creating Formulas by Selecting Cells |
|
|
31 | (4) |
|
|
|
35 | (3) |
|
Using Absolute Cell References |
|
|
38 | (11) |
|
|
|
41 | (1) |
|
|
|
41 | (4) |
|
|
|
45 | (4) |
|
|
|
45 | (2) |
|
|
|
47 | (2) |
| Project 8 Calculating with Functions |
|
49 | (30) |
|
|
|
50 | (3) |
|
|
|
53 | (3) |
|
|
|
56 | (7) |
|
Building Formulas with Functions |
|
|
63 | (4) |
|
Using Conditional Statements |
|
|
67 | (12) |
|
|
|
70 | (1) |
|
|
|
71 | (3) |
|
|
|
74 | (5) |
|
|
|
74 | (2) |
|
|
|
76 | (3) |
| Project 9 Improving the Appearance of a Worksheet |
|
79 | (30) |
|
Using Fonts and Their Attributes |
|
|
80 | (4) |
|
|
|
84 | (2) |
|
Aligning Text and Numbers |
|
|
86 | (3) |
|
|
|
89 | (2) |
|
Adding Borders and Patterns |
|
|
91 | (4) |
|
Using Conditional Formatting |
|
|
95 | (2) |
|
|
|
97 | (2) |
|
Checking the Spelling in a Worksheet |
|
|
99 | (10) |
|
|
|
102 | (1) |
|
|
|
103 | (3) |
|
|
|
106 | (3) |
|
|
|
106 | (2) |
|
|
|
108 | (1) |
| Project 10: Using Charts and Maps |
|
109 | |
|
|
|
110 | (5) |
|
Formatting Text in a Chart |
|
|
115 | (3) |
|
|
|
118 | (5) |
|
|
|
123 | (4) |
|
|
|
127 | (2) |
|
|
|
129 | |
|
|
|
134 | (1) |
|
|
|
134 | (3) |
|
|
|
137 | |
|
|
|
137 | (2) |
|
|
|
139 | |
| Project 11: Using Excel with Other Programs |
|
35 | |
|
Switching among Applications |
|
|
36 | (3) |
|
Copying Data between Applications |
|
|
39 | (2) |
|
Linking Data between Applications |
|
|
41 | (4) |
|
Working with Embedded Data |
|
|
45 | (3) |
|
Sharing Data across Different Applications |
|
|
48 | |
|
|
|
51 | (1) |
|
|
|
51 | (3) |
|
|
|
54 | |
|
|
|
54 | (3) |
|
|
|
57 | |
| Project 12: Creating a Database |
|
1 | (26) |
|
|
|
2 | (3) |
|
|
|
5 | (3) |
|
Saving a Table and Creating a Primary Key |
|
|
8 | (3) |
|
|
|
11 | (2) |
|
|
|
13 | (2) |
|
Changing Views and Moving Fields |
|
|
15 | (2) |
|
|
|
17 | (10) |
|
|
|
18 | (1) |
|
|
|
19 | (8) |
|
|
|
22 | (1) |
|
|
|
22 | (3) |
|
|
|
25 | (2) |
| Project 13: Entering and Editing Data |
|
27 | (28) |
|
|
|
28 | (3) |
|
|
|
31 | (2) |
|
|
|
33 | (2) |
|
Inserting and Deleting Records |
|
|
35 | (3) |
|
Adjusting Column Widths and Hiding Columns |
|
|
38 | (3) |
|
|
|
41 | (2) |
|
|
|
43 | (12) |
|
|
|
45 | (1) |
|
|
|
46 | (3) |
|
|
|
49 | (6) |
|
|
|
49 | (3) |
|
|
|
52 | (3) |
| Project 14: Querying Your Database |
|
55 | (26) |
|
|
|
56 | (2) |
|
Choosing Fields for a Query |
|
|
58 | (3) |
|
|
|
61 | (2) |
|
|
|
63 | (2) |
|
|
|
65 | (2) |
|
|
|
67 | (3) |
|
Saving the Query with a New Name and Opening Multiple Queries |
|
|
70 | (11) |
|
|
|
72 | (1) |
|
|
|
73 | (3) |
|
|
|
76 | (5) |
|
|
|
76 | (3) |
|
|
|
79 | (2) |
| Project 15: Creating and Using Forms |
|
81 | (28) |
|
|
|
82 | (2) |
|
Entering and Editing Data Using a Form |
|
|
84 | (3) |
|
Saving, Closing, and Opening a Form |
|
|
87 | (1) |
|
Creating a New Form from Scratch |
|
|
88 | (2) |
|
|
|
90 | (3) |
|
Moving and Resizing Fields in Forms |
|
|
93 | (3) |
|
Adding a Form Header and Label |
|
|
96 | (13) |
|
|
|
99 | (1) |
|
|
|
100 | (3) |
|
|
|
103 | (6) |
|
|
|
103 | (2) |
|
|
|
105 | (4) |
| Project 16: Creating and Printing Reports |
|
109 | |
|
|
|
110 | (3) |
|
Creating a Report Using the Report Wizards |
|
|
113 | (4) |
|
Printing and Renaming a Report |
|
|
117 | (2) |
|
Modifying a Report Design |
|
|
119 | (2) |
|
Saving the Report with a New Name |
|
|
121 | (1) |
|
Adding Fields to the Report |
|
|
122 | (2) |
|
Creating a Two-Column Report |
|
|
124 | |
|
|
|
127 | (1) |
|
|
|
128 | (3) |
|
|
|
131 | |
|
|
|
131 | (3) |
|
|
|
134 | |
| Project 17: Managing Data and Files |
|
59 | |
|
Switching between Applications Using the Taskbar |
|
|
60 | (2) |
|
Copying Tables and Queries to Microsoft Word Documents |
|
|
62 | (2) |
|
Copying Tables or Queries to a Spreadsheet for Data Analysis |
|
|
64 | (2) |
|
Merging Data from Access into Documents in Microsoft Word |
|
|
66 | (7) |
|
Importing Tables from Databases, Spreadsheets, and Text Files |
|
|
73 | (8) |
|
Linking Tables to Access from Other Databases |
|
|
81 | |
|
|
|
83 | (1) |
|
|
|
84 | (3) |
|
|
|
87 | |
|
|
|
87 | (3) |
|
|
|
90 | |
| Project 18: Getting Started with PowerPoint |
|
1 | (36) |
|
|
|
2 | (2) |
|
Creating a New Presentation |
|
|
4 | (4) |
|
|
|
8 | (4) |
|
Moving among Slides in a Presentation |
|
|
12 | (3) |
|
Running an Electronic Slide Show |
|
|
15 | (2) |
|
Saving and Closing Your Presentation |
|
|
17 | (2) |
|
|
|
19 | (6) |
|
|
|
25 | (12) |
|
|
|
26 | (1) |
|
|
|
27 | (3) |
|
|
|
30 | (7) |
|
|
|
30 | (3) |
|
|
|
33 | (4) |
| Project 19: Changing the Appearance of a Presentation |
|
37 | (56) |
|
|
|
38 | (4) |
|
Working with Color Schemes |
|
|
42 | (2) |
|
Changing the Slide Background |
|
|
44 | (2) |
|
Working with a Slide Master |
|
|
46 | (3) |
|
|
|
49 | (5) |
|
Selecting and Modifying Drawn Objects |
|
|
54 | (4) |
|
|
|
58 | (35) |
|
|
|
61 | (1) |
|
|
|
62 | (4) |
|
|
|
66 | (27) |
|
|
|
66 | (2) |
|
|
|
68 | (25) |
| Project 20: Integrating Office Applications |
|
93 | |
|
Merging an Access Table with a Word Letter |
|
|
94 | (6) |
|
Creating an Access Report from an Excel List |
|
|
100 | (5) |
|
Creating a PowerPoint Presentation from a Word Outline |
|
|
105 | (3) |
|
Creating a Word Handout from a PowerPoint Presentation |
|
|
108 | (2) |
|
Creating and Printing Binders |
|
|
110 | |
|
|
|
115 | (2) |
|
|
|
117 | |
|
|
|
117 | (2) |
|
|
|
119 | |
| Appendix A: Working with Windows 95 |
|
1 | (1) |
|
|
|
2 | (1) |
|
|
|
3 | (1) |
|
Understanding the Start Menu |
|
|
4 | (1) |
|
Identifying the Elements of a Window |
|
|
5 | (1) |
|
|
|
6 | (2) |
|
|
|
8 | |
| Appendix B: Getting Started with Microsoft Outlook 97 |
|
1 | (1) |
|
|
|
2 | (4) |
|
Exploring the Outlook Window |
|
|
6 | (6) |
|
Using Menus and Dialog Boxes |
|
|
12 | (2) |
|
|
|
14 | (3) |
|
Using the Office Assistant for Help |
|
|
17 | (4) |
|
|
|
21 | |
|
|
|
22 | (1) |
|
|
|
22 | (2) |
|
|
|
24 | |
|
|
|
24 | |
| Glossary |
|
G-1 | |
| Index |
|
1 | |
