Essential Introduction to Computers |
|
|
|
1 | (1) |
|
|
2 | (1) |
|
|
3 | (1) |
|
Why Is a Computer So Powerful? |
|
|
3 | (1) |
|
How Does a Computer Know What to Do? |
|
|
3 | (1) |
|
What Are the Components of a Computer? |
|
|
4 | (1) |
|
|
4 | (2) |
|
|
4 | (1) |
|
|
5 | (1) |
|
The Central Processing Unit |
|
|
6 | (1) |
|
|
6 | (1) |
|
|
6 | (2) |
|
|
6 | (2) |
|
|
8 | (1) |
|
|
8 | (4) |
|
|
8 | (2) |
|
|
10 | (1) |
|
|
10 | (1) |
|
|
11 | (1) |
|
|
11 | (1) |
|
|
11 | (1) |
|
|
12 | (2) |
|
|
12 | (1) |
|
|
12 | (2) |
|
Networks and the Internet |
|
|
14 | (3) |
|
|
14 | (1) |
|
|
15 | (1) |
|
|
15 | (2) |
|
How to Purchase a Desktop Computer |
|
|
17 | (5) |
|
How to Purchase a Notebook Computer |
|
|
22 | (2) |
|
How to Purchase a Handheld Computer |
|
|
24 | (2) |
|
How to Install a Personal Computer |
|
|
26 | (3) |
|
How to Maintain a Personal Computer |
|
|
29 | (2) |
|
|
31 | (1) |
|
|
32 | (1) |
|
|
32 | |
Microsoft Windows 2000 and Office XP |
|
1 PROJECT ONE |
|
|
An Introduction to Windows 2000 Professional and Office XP |
|
|
|
|
1 | (3) |
|
|
4 | (1) |
|
What Is Microsoft Windows 2000 Professional? |
|
|
5 | (4) |
|
What Is a User Interface? |
|
|
5 | (1) |
|
Launching Microsoft Windows 2000 Professional |
|
|
6 | (2) |
|
Closing the Getting Started with Windows 2000 Dialog Box |
|
|
8 | (1) |
|
The Desktop as a Work Area |
|
|
9 | (1) |
|
Communicating with Microsoft Windows 2000 |
|
|
9 | (18) |
|
|
9 | (1) |
|
|
9 | (3) |
|
|
12 | (1) |
|
|
13 | (1) |
|
|
14 | (1) |
|
|
15 | (1) |
|
Maximize and Restore Down Buttons |
|
|
16 | (2) |
|
|
18 | (2) |
|
|
20 | (1) |
|
Sizing a Window by Dragging |
|
|
21 | (2) |
|
|
23 | (2) |
|
|
25 | (1) |
|
|
25 | (1) |
|
|
25 | (2) |
|
Summary of Mouse and Windows Operations |
|
|
27 | (1) |
|
The Keyboard and Keyboard Shortcuts |
|
|
27 | (1) |
|
Launching an Application Program |
|
|
28 | (3) |
|
Launching an Application Using the Start Button |
|
|
28 | (2) |
|
|
30 | (1) |
|
|
31 | (7) |
|
Starting Windows Explorer and Maximizing Its Window |
|
|
31 | (1) |
|
|
32 | (2) |
|
Displaying the Contents of a Folder |
|
|
34 | (1) |
|
|
35 | (2) |
|
|
37 | (1) |
|
Copying Files to a Folder on a Floppy Disk |
|
|
38 | (12) |
|
|
38 | (3) |
|
Displaying the Destination Folder |
|
|
41 | (1) |
|
Displaying the Contents of the WINNT Folder |
|
|
42 | (2) |
|
Selecting a Group of Files |
|
|
44 | (2) |
|
|
46 | (1) |
|
Displaying the Contents of the My Files Folder |
|
|
47 | (1) |
|
Renaming a File or Folder |
|
|
48 | (2) |
|
Deleting a File or Folder |
|
|
50 | (3) |
|
Deleting a File by Right-Clicking Its File Name |
|
|
50 | (2) |
|
|
52 | (1) |
|
Quitting Windows Explorer |
|
|
53 | (1) |
|
|
53 | (8) |
|
|
53 | (4) |
|
|
57 | (2) |
|
Shutting Down Windows 2000 |
|
|
59 | (2) |
|
What Is Microsoft Office XP? |
|
|
61 | (1) |
|
The Internet, World Wide Web, and Intranets |
|
|
62 | (1) |
|
Microsoft Office XP and the Internet |
|
|
62 | (1) |
|
|
62 | (2) |
|
Microsoft Word 2002 and the Internet |
|
|
63 | (1) |
|
|
64 | (2) |
|
Microsoft Excel 2002 and the Internet |
|
|
64 | (2) |
|
|
66 | (1) |
|
Microsoft Access 2002 and the Internet |
|
|
66 | (1) |
|
Microsoft PowerPoint 2002 |
|
|
67 | (2) |
|
Microsoft PowerPoint 2002 and the Internet |
|
|
68 | (1) |
|
|
69 | (1) |
|
|
70 | (1) |
|
Microsoft Publisher and the Internet |
|
|
71 | (1) |
|
|
71 | (1) |
|
|
72 | (2) |
|
The Microsoft Office XP Help System |
|
|
74 | (1) |
|
|
75 | (1) |
|
|
75 | (1) |
|
|
76 | (1) |
|
|
77 | |
Microsoft Word 2002 |
|
1 PROJECT ONE |
|
|
Creating and Editing a Word Document |
|
|
|
|
3 | (3) |
|
|
6 | (1) |
|
Project One --- Hidden Lake Announcement |
|
|
6 | (1) |
|
Starting and Customizing Word |
|
|
7 | (5) |
|
|
12 | (7) |
|
|
12 | (2) |
|
|
14 | (3) |
|
Resetting Menus and Toolbars |
|
|
17 | (1) |
|
Speech Recognition and Handwriting Recognition |
|
|
17 | (1) |
|
|
18 | (1) |
|
Changing the Default Font Size |
|
|
19 | (2) |
|
|
21 | (8) |
|
Entering Blank Lines into a Document |
|
|
23 | (1) |
|
Displaying Formatting Marks |
|
|
23 | (1) |
|
|
24 | (1) |
|
|
25 | (1) |
|
Entering Text that Scrolls the Document Window |
|
|
26 | (1) |
|
Checking Spelling as You Type |
|
|
27 | (2) |
|
|
29 | (3) |
|
Formatting Paragraphs and Characters in a Document |
|
|
32 | (14) |
|
Selecting and Formatting Paragraphs and Characters |
|
|
33 | (1) |
|
Selecting Multiple Paragraphs |
|
|
33 | (1) |
|
Changing the Font Size of Selected Text |
|
|
34 | (2) |
|
Changing the Font of Selected Text |
|
|
36 | (1) |
|
|
36 | (2) |
|
|
38 | (1) |
|
Undoing Commands or Actions |
|
|
38 | (1) |
|
Selecting a Line and Formatting It |
|
|
39 | (2) |
|
|
41 | (1) |
|
|
41 | (1) |
|
|
42 | (1) |
|
Underlining Selected Text |
|
|
43 | (1) |
|
Selecting a Group of Words |
|
|
44 | (1) |
|
|
44 | (2) |
|
Inserting Clip Art into a Word Document |
|
|
46 | (7) |
|
|
46 | (4) |
|
|
50 | (3) |
|
Saving an Existing Document with the Same File Name |
|
|
53 | (1) |
|
|
54 | (1) |
|
|
55 | (1) |
|
|
55 | (2) |
|
|
57 | (2) |
|
Types of Changes Made to Documents |
|
|
57 | (1) |
|
Inserting Text into an Existing Document |
|
|
58 | (1) |
|
Deleting Text from an Existing Document |
|
|
58 | (1) |
|
Closing the Entire Document |
|
|
58 | (1) |
|
|
59 | (3) |
|
Obtaining Help Using the Ask a Question Box on the Menu Bar |
|
|
59 | (3) |
|
|
62 | (1) |
|
|
62 | (1) |
|
|
63 | (1) |
|
|
64 | (2) |
|
|
66 | (4) |
|
|
70 | |
2 PROJECT TWO |
|
|
Creating a Research Paper |
|
|
|
|
1 | (3) |
|
|
4 | (1) |
|
Project Two --- E-Retailing Research Paper |
|
|
4 | (3) |
|
|
6 | (1) |
|
|
6 | (1) |
|
Resetting Menus and Toolbars |
|
|
7 | (1) |
|
Displaying Formatting Marks |
|
|
7 | (1) |
|
|
7 | (3) |
|
|
9 | (1) |
|
|
10 | (1) |
|
Using a Header to Number Pages |
|
|
11 | (4) |
|
|
11 | (2) |
|
Entering Text Using Click and Type |
|
|
13 | (1) |
|
Entering a Page Number into the Header |
|
|
14 | (1) |
|
Typing the Body of the Research Paper |
|
|
15 | (19) |
|
Applying Formatting Using Shortcut Keys |
|
|
16 | (2) |
|
Saving the Research Paper |
|
|
18 | (1) |
|
|
18 | (2) |
|
Using Word's AutoCorrect Feature |
|
|
20 | (4) |
|
|
24 | (3) |
|
|
27 | (5) |
|
|
32 | (1) |
|
|
33 | (1) |
|
Recounting Words in a Document |
|
|
34 | (1) |
|
Creating an Alphabetical Works Cited Page |
|
|
34 | (8) |
|
|
35 | (1) |
|
Centering the Title of the Works Cited Page |
|
|
36 | (1) |
|
Creating a Hanging Indent |
|
|
36 | (2) |
|
Inserting Arrows, Faces, and Other Symbols Automatically |
|
|
38 | (1) |
|
|
39 | (2) |
|
|
41 | (1) |
|
Proofing and Revising the Research Paper |
|
|
42 | (11) |
|
Going to a Specific Location in a Document |
|
|
42 | (2) |
|
|
44 | (3) |
|
|
47 | (1) |
|
Finding and Replacing Text |
|
|
48 | (1) |
|
|
49 | (1) |
|
|
50 | (1) |
|
Checking Spelling and Grammar At Once |
|
|
50 | (2) |
|
Saving Again and Printing the Document |
|
|
52 | (1) |
|
Navigating to a Hyperlink |
|
|
53 | (1) |
|
E-Mailing a Copy of the Research Paper |
|
|
54 | (1) |
|
|
55 | (1) |
|
|
55 | (1) |
|
|
56 | (1) |
|
|
57 | (1) |
|
|
58 | (6) |
|
|
64 | |
3 PROJECT THREE |
|
|
Creating a Resume Using a Wizard and a Cover Letter with a Table |
|
|
|
|
01 | (3) |
|
|
04 | (1) |
|
Project Three --- Resume and Cover Letter |
|
|
05 | (3) |
|
|
06 | (1) |
|
Resetting Menus and Toolbars |
|
|
07 | (1) |
|
Displaying Formatting Marks |
|
|
07 | (1) |
|
Using Word's Resume Wizard to Create a Resume |
|
|
08 | (8) |
|
|
16 | (11) |
|
|
16 | (1) |
|
|
17 | (1) |
|
|
18 | (1) |
|
Selecting and Replacing Text |
|
|
19 | (2) |
|
|
21 | (1) |
|
|
22 | (3) |
|
Viewing and Printing the Resume in Print Preview |
|
|
25 | (1) |
|
|
26 | (1) |
|
|
27 | (14) |
|
Opening a New Document Window |
|
|
27 | (1) |
|
Adding Color to Characters |
|
|
28 | (2) |
|
Setting Tab Stops Using the Tabs Dialog Box |
|
|
30 | (2) |
|
|
32 | (5) |
|
Adding a Bottom Border to a Paragraph |
|
|
37 | (1) |
|
|
38 | (3) |
|
|
41 | (16) |
|
Components of a Business Letter |
|
|
41 | (1) |
|
Saving the Cover Letter with a New File Name |
|
|
41 | (1) |
|
Setting Tab Stops Using the Ruler |
|
|
42 | (1) |
|
Inserting the Current Date into a Document |
|
|
43 | (1) |
|
Creating an AutoText Entry |
|
|
44 | (2) |
|
Entering a Nonbreaking Space |
|
|
46 | (1) |
|
Inserting an AutoText Entry |
|
|
47 | (2) |
|
Creating a Table with the Insert Table Button |
|
|
49 | (1) |
|
Entering Data into a Word Table |
|
|
50 | (1) |
|
|
51 | (2) |
|
Changing the Table Alignment |
|
|
53 | (1) |
|
|
54 | (3) |
|
Saving Again and Printing the Cover Letter |
|
|
57 | (1) |
|
Addressing and Printing Envelopes and Mailing Labels |
|
|
57 | (1) |
|
|
58 | (3) |
|
|
61 | (1) |
|
|
61 | (1) |
|
|
62 | (1) |
|
|
63 | (1) |
|
|
64 | (2) |
|
|
66 | |
WEB FEATURE |
|
|
Creating Web Pages Using Word |
|
|
|
|
01 | (2) |
|
Saving a Word Document as a Web Page |
|
|
03 | (1) |
|
Formatting the E-Mail Address as a Hyperlink |
|
|
04 | (1) |
|
Using Word's Web Page Wizard to Create a Web Page |
|
|
04 | (4) |
|
|
08 | (6) |
|
Viewing the Web Page in Your Default Browser |
|
|
11 | (1) |
|
Editing a Web Page from Your Browser |
|
|
12 | (2) |
|
|
14 | (1) |
|
|
14 | |
Microsoft Excel 2002 |
|
1 PROJECT ONE |
|
|
Creating a Worksheet and Embedded Chart |
|
|
|
|
03 | (3) |
|
|
06 | (1) |
|
Project One --- Dynamite Music Fourth Quarter Sales |
|
|
06 | (1) |
|
Starting and Customizing Excel |
|
|
07 | (3) |
|
|
10 | (2) |
|
|
11 | (1) |
|
|
12 | (4) |
|
|
12 | (1) |
|
Standard Toolbar and Formatting Toolbar |
|
|
13 | (2) |
|
|
15 | (1) |
|
|
15 | (1) |
|
Speech Recognition and Speech Playback |
|
|
16 | (1) |
|
|
16 | (1) |
|
|
16 | (5) |
|
Entering the Worksheet Titles |
|
|
17 | (2) |
|
Correcting a Mistake While Typing |
|
|
19 | (1) |
|
|
19 | (1) |
|
|
19 | (1) |
|
|
20 | (1) |
|
|
21 | (2) |
|
|
23 | (1) |
|
Using the Fill Handle to Copy a Cell to Adjacent Cells |
|
|
24 | (4) |
|
|
26 | (2) |
|
|
28 | (7) |
|
Fonts, Font Color, Font Size, and Font Style |
|
|
29 | (1) |
|
|
29 | (1) |
|
|
29 | (1) |
|
Changing the Font Color of a Cell |
|
|
30 | (1) |
|
Centering the Worksheet Title across Columns |
|
|
31 | (1) |
|
Formatting the Worksheet Subtitle |
|
|
32 | (1) |
|
Using AutoFormat to Format the Body of a Worksheet |
|
|
33 | (2) |
|
Using the Name Box to Select a Cell |
|
|
35 | (2) |
|
Adding a 3-D Column Chart to the Worksheet |
|
|
37 | (3) |
|
|
40 | (4) |
|
|
44 | (1) |
|
|
45 | (1) |
|
Starting Excel and Opening a Workbook |
|
|
46 | (1) |
|
|
47 | (2) |
|
|
49 | (3) |
|
Correcting Errors While You Are Typing Data into a Cell |
|
|
49 | (1) |
|
|
49 | (1) |
|
|
50 | (1) |
|
Clearing a Cell or Range of Cells |
|
|
51 | (1) |
|
Clearing the Entire Worksheet |
|
|
51 | (1) |
|
|
52 | (3) |
|
Obtaining Help Using the Ask a Question Box on the Menu Bar |
|
|
52 | (2) |
|
|
54 | (1) |
|
|
55 | (1) |
|
|
55 | (1) |
|
|
56 | (1) |
|
|
57 | (1) |
|
|
58 | (5) |
|
|
63 | |
2 PROJECT TWO |
|
|
Formulas, Functions, Formatting, and Web Queries |
|
|
|
|
01 | (3) |
|
|
04 | (1) |
|
Project Two --- Greenback Stock Club |
|
|
04 | (3) |
|
Starting and Customizing Excel |
|
|
06 | (1) |
|
Entering the Titles and Numbers into the Worksheet |
|
|
07 | (2) |
|
|
09 | (7) |
|
|
10 | (1) |
|
Entering Formulas Using Point Mode |
|
|
11 | (2) |
|
Copying the Formulas Using the Fill Handle |
|
|
13 | (2) |
|
|
15 | (1) |
|
Determining the Totals Using the AutoSum Button |
|
|
15 | (1) |
|
Determining the Total Percent Gain/Loss |
|
|
16 | (1) |
|
Using the AVERAGE, MAX, and MIN Functions |
|
|
16 | (9) |
|
Determining the Average of a Range of Numbers |
|
|
17 | (1) |
|
Determining the Highest Number in a Range of Numbers |
|
|
18 | (2) |
|
Determining the Lowest Number in a Range of Numbers |
|
|
20 | (3) |
|
Copying the AVERAGE, MAX, and MIN Functions |
|
|
23 | (1) |
|
|
24 | (1) |
|
Verifying Formulas Using Range Finder |
|
|
25 | (1) |
|
|
26 | (22) |
|
Changing the Font and Centering the Worksheet Title |
|
|
27 | (3) |
|
Changing the Worksheet Title Background and Font Colors and Applying an Outline Border |
|
|
30 | (1) |
|
Applying Formats to the Column Titles |
|
|
31 | (1) |
|
Centering the Stock Symbols and Formatting the Dates and Numbers in the Worksheet |
|
|
32 | (1) |
|
Formatting Numbers Using the Formatting Toolbar |
|
|
33 | (3) |
|
Underlining the Row above the Title Row and Bolding the Total Row Titles |
|
|
36 | (1) |
|
Formatting Numbers Using the Format Cells Command on the Shortcut Menu |
|
|
36 | (3) |
|
Formatting Numbers Using the Percent Style Button and Increase Decimal Button |
|
|
39 | (1) |
|
|
40 | (3) |
|
Changing the Widths of Columns and Heights of Rows |
|
|
43 | (1) |
|
Changing the Widths of Columns |
|
|
43 | (3) |
|
Changing the Heights of Rows |
|
|
46 | (2) |
|
|
48 | (2) |
|
Saving a Workbook a Second Time Using the Same File Name |
|
|
50 | (1) |
|
Previewing and Printing the Worksheet |
|
|
51 | (5) |
|
Printing a Section of the Worksheet |
|
|
54 | (2) |
|
Displaying and Printing the Formulas Version of the Worksheet |
|
|
56 | (2) |
|
Changing the Print Scaling Option Back to 100% |
|
|
57 | (1) |
|
Importing External Data from a Web Source Using a Web Query |
|
|
58 | (4) |
|
|
62 | (1) |
|
E-Mailing a Workbook from within Excel |
|
|
63 | (2) |
|
Quitting Excel and Saving the Workbook |
|
|
64 | (1) |
|
|
65 | (1) |
|
|
65 | (1) |
|
|
66 | (1) |
|
|
67 | (2) |
|
|
69 | (9) |
|
|
78 | |
3 PROJECT THREE |
|
|
What-If Analysis, Charting, and Working with Large Worksheets |
|
|
|
|
01 | (3) |
|
|
04 | (2) |
|
Project Three---Awesome Intranets' Six-Month Financial Projections |
|
|
06 | (2) |
|
Starting and Customizing Excel |
|
|
06 | (1) |
|
Changing the Font of the Entire Worksheet to Bold |
|
|
07 | (1) |
|
Entering the Worksheet Titles |
|
|
07 | (1) |
|
Rotating Text and Using the Fill Handle to Create a Series |
|
|
08 | (3) |
|
Copying a Cell's Format Using the Format Painter Button |
|
|
11 | (2) |
|
Increasing the Column Widths and Entering Row Titles |
|
|
12 | (1) |
|
Copying a Range of Cells to a Nonadjacent Destination Area |
|
|
13 | (3) |
|
Using Drag and Drop to Move or Copy Cells |
|
|
16 | (1) |
|
Inserting and Deleting Cells in a Worksheet |
|
|
16 | (3) |
|
|
16 | (2) |
|
|
18 | (1) |
|
Inserting Individual Cells or a Range of Cells |
|
|
18 | (1) |
|
Deleting Columns and Rows |
|
|
18 | (1) |
|
Deleting Individual Cells or a Range of Cells |
|
|
18 | (1) |
|
Entering Numbers with a Format Symbol |
|
|
19 | (1) |
|
|
19 | (1) |
|
Freezing Worksheet Titles |
|
|
20 | (2) |
|
Entering the Projected Revenue |
|
|
21 | (1) |
|
Displaying the System Date |
|
|
22 | (3) |
|
Absolute Versus Relative Addressing |
|
|
25 | (2) |
|
Entering a Formula Containing Absolute Cell References |
|
|
26 | (1) |
|
Making Decisions --- The IF Function |
|
|
27 | (5) |
|
Entering the Remaining Projected Expense and Net Income Formulas for January |
|
|
29 | (1) |
|
Copying the Projected January Expenses and Net Income Formulas to the Other Months |
|
|
30 | (1) |
|
Determining the Projected Total Expenses by Category and Total Net Income |
|
|
31 | (1) |
|
Unfreezing Worksheet Titles and Saving the Workbook |
|
|
31 | (1) |
|
|
32 | (11) |
|
|
33 | (2) |
|
Formatting the Worksheet Titles |
|
|
35 | (2) |
|
Displaying the Drawing Toolbar |
|
|
37 | (1) |
|
Moving and Docking a Toolbar |
|
|
38 | (1) |
|
Adding a Drop Shadow to the Title Area |
|
|
39 | (1) |
|
Formatting the Category Row Titles and Net Income Row |
|
|
40 | (2) |
|
Formatting the Assumptions Table |
|
|
42 | (1) |
|
Hiding the Drawing Toolbar and Saving the Workbook |
|
|
43 | (1) |
|
Adding a 3-D Pie Chart to the Workbook |
|
|
43 | (11) |
|
Drawing a 3-D Pie Chart on a Separate Chart Sheet |
|
|
44 | (4) |
|
Formatting the Chart Title and Data Labels |
|
|
48 | (1) |
|
Changing the Colors of the Slices |
|
|
49 | (2) |
|
Exploding the 3-D Pie Chart |
|
|
51 | (1) |
|
Rotating and Tilting the 3-D Pie Chart |
|
|
51 | (2) |
|
Adding Leader Lines to the Data Labels |
|
|
53 | (1) |
|
Renaming and Reordering the Sheets and Coloring Their Tabs |
|
|
54 | (2) |
|
Checking Spelling, Saving, Previewing, and Printing the Workbook |
|
|
56 | (2) |
|
Checking Spelling in Multiple Sheets |
|
|
56 | (1) |
|
Previewing and Printing the Workbook |
|
|
56 | (2) |
|
Changing the View of the Worksheet |
|
|
58 | (3) |
|
Shrinking and Magnifying the View of a Worksheet or Chart |
|
|
58 | (1) |
|
Splitting the Window into Panes |
|
|
59 | (2) |
|
|
61 | (4) |
|
|
63 | (2) |
|
|
65 | (1) |
|
|
65 | (1) |
|
|
66 | (1) |
|
|
67 | (1) |
|
|
68 | (1) |
|
|
69 | (10) |
|
|
79 | |
WEB FEATURE |
|
|
Creating Static and Dynamic Web Pages Using Excel |
|
|
|
|
01 | (3) |
|
Using Web Page Preview and Saving an Excel Workbook as a Static Web Page |
|
|
04 | (6) |
|
|
04 | (2) |
|
Saving a Workbook as a Static Web Page to a New Folder |
|
|
06 | (2) |
|
Viewing the Static Web Page Using Your Browser |
|
|
08 | (2) |
|
Saving an Excel Chart as a Dynamic Web Page |
|
|
10 | (5) |
|
Viewing and Manipulating the Dynamic Web Page Using Your Browser |
|
|
12 | (1) |
|
Modifying the Worksheet on a Dynamic Web Page |
|
|
13 | (2) |
|
|
15 | (1) |
|
|
15 | (1) |
|
|
15 | |
Microsoft Access 2002 |
|
1 PROJECT ONE |
|
|
Creating A Database Using Design and Datasheet Views |
|
|
|
|
03 | (3) |
|
What Is Microsoft Access? |
|
|
06 | (1) |
|
Project One --- Alisa Vending Services |
|
|
06 | (2) |
|
|
08 | (2) |
|
|
10 | (1) |
|
|
11 | (2) |
|
The Access Desktop and the Database Window |
|
|
13 | (1) |
|
|
13 | (7) |
|
|
16 | (3) |
|
Correcting Errors in the Structure |
|
|
19 | (1) |
|
Saving and Closing a Table |
|
|
20 | (1) |
|
Adding Records to a Table |
|
|
21 | (3) |
|
Closing a Table and Database |
|
|
24 | (1) |
|
|
25 | (1) |
|
Adding Additional Records |
|
|
26 | (2) |
|
Correcting Errors in the Data |
|
|
28 | (1) |
|
Previewing and Printing the Contents of a Table |
|
|
28 | (4) |
|
Creating Additional Tables |
|
|
32 | (2) |
|
Adding Records to the Additional Table |
|
|
34 | (1) |
|
Using a Form to View Data |
|
|
34 | (6) |
|
|
35 | (1) |
|
Closing and Saving the Form |
|
|
36 | (1) |
|
|
37 | (1) |
|
|
38 | (1) |
|
Switching Between Form View and Datasheet View |
|
|
39 | (1) |
|
|
40 | (7) |
|
Selecting the Fields for the Report |
|
|
42 | (1) |
|
|
43 | (3) |
|
|
46 | (1) |
|
|
47 | (1) |
|
|
47 | (2) |
|
Obtaining Help Using the Ask a Question Box on the Menu Bar |
|
|
47 | (2) |
|
|
49 | (1) |
|
|
49 | (2) |
|
|
51 | (1) |
|
|
52 | (1) |
|
|
53 | (1) |
|
|
54 | (2) |
|
|
56 | (6) |
|
|
62 | |
2 PROJECT TWO |
|
|
Querying a Database Using the Select Query Window |
|
|
|
|
01 | (3) |
|
|
04 | (1) |
|
Project Two --- Querying the Alisa Vending Services Database |
|
|
04 | (2) |
|
|
06 | (1) |
|
|
06 | (8) |
|
Using the Select Query Window |
|
|
09 | (1) |
|
Displaying Selected Fields in a Query |
|
|
09 | (2) |
|
|
11 | (1) |
|
Printing the Results of a Query |
|
|
11 | (1) |
|
Returning to the Select Query Window |
|
|
12 | (1) |
|
|
12 | (2) |
|
Including All Fields in a Query |
|
|
14 | (1) |
|
|
15 | (1) |
|
|
16 | (6) |
|
Using Text Data in Criteria |
|
|
16 | (1) |
|
|
17 | (1) |
|
Criteria for a Field Not in the Result |
|
|
18 | (2) |
|
Using Numeric Data in Criteria |
|
|
20 | (1) |
|
Using Comparison Operators |
|
|
21 | (1) |
|
|
22 | (2) |
|
|
22 | (1) |
|
|
23 | (1) |
|
|
24 | (5) |
|
|
26 | (1) |
|
|
27 | (2) |
|
|
29 | (4) |
|
Restricting Records in a Join |
|
|
32 | (1) |
|
Using Calculated Fields in a Query |
|
|
33 | (3) |
|
|
36 | (5) |
|
Using Criteria in Calculating Statistics |
|
|
38 | (2) |
|
|
40 | (1) |
|
|
41 | (1) |
|
|
42 | (1) |
|
|
42 | (1) |
|
|
42 | (1) |
|
|
43 | (1) |
|
|
44 | (1) |
|
|
44 | (4) |
|
|
48 | |
3 PROJECT THREE |
|
|
Maintaining a Database Using the Design and Update Features of Access |
|
|
|
|
01 | (3) |
|
|
04 | (1) |
|
Project Three --- Maintaining the Alisa Vending Services Database |
|
|
04 | (1) |
|
|
05 | (1) |
|
Adding, Changing, and Deleting |
|
|
06 | (9) |
|
|
06 | (2) |
|
|
08 | (2) |
|
Changing the Contents of a Record |
|
|
10 | (1) |
|
|
10 | (2) |
|
|
12 | (2) |
|
|
14 | (1) |
|
|
15 | (7) |
|
Changing the Size of a Field |
|
|
15 | (2) |
|
|
17 | (2) |
|
|
19 | (1) |
|
Updating the Restructured Database |
|
|
19 | (1) |
|
|
20 | (2) |
|
|
22 | (3) |
|
|
25 | (2) |
|
Creating Validation Rules |
|
|
27 | (9) |
|
Specifying a Required Field |
|
|
27 | (2) |
|
|
29 | (1) |
|
Specifying a Default Value |
|
|
29 | (1) |
|
Specifying a Collection of Legal Values |
|
|
30 | (1) |
|
|
31 | (1) |
|
Saving Rules, Values, and Formats |
|
|
32 | (1) |
|
Updating a Table that Contains Validation Rules |
|
|
33 | (2) |
|
Making Individual Changes to a Field |
|
|
35 | (1) |
|
Specifying Referential Integrity |
|
|
36 | (4) |
|
|
39 | (1) |
|
|
40 | (3) |
|
Ordering Records on Multiple Fields |
|
|
41 | (2) |
|
Creating and Using Indexes |
|
|
43 | (5) |
|
How Does Access Use an Index? |
|
|
45 | (1) |
|
When Should You Create an Index? |
|
|
45 | (1) |
|
Creating Single-Field Indexes |
|
|
46 | (1) |
|
Creating Multiple-Field Indexes |
|
|
46 | (2) |
|
|
48 | (1) |
|
|
49 | (1) |
|
|
49 | (1) |
|
|
50 | (1) |
|
|
51 | (1) |
|
|
52 | (6) |
|
|
58 | |
WEB FEATURE |
|
|
Publishing to the Internet Using Data Access Pages |
|
|
|
|
01 | (1) |
|
|
01 | (1) |
|
Creating a Data Access Page |
|
|
02 | (5) |
|
Viewing the Data Access Page |
|
|
07 | (1) |
|
Using the Data Access Page |
|
|
08 | (1) |
|
|
09 | (1) |
|
|
09 | (1) |
|
|
10 | |
Microsoft PowerPoint 2002 |
|
1 PROJECT ONE |
|
|
Using a Design Template and Text Slide Layout to Create a Presentation |
|
|
|
|
03 | (3) |
|
What Is Microsoft PowerPoint? |
|
|
06 | (2) |
|
Project One --- Time to Start Making Friends |
|
|
08 | (2) |
|
Starting and Customizing PowerPoint |
|
|
10 | (3) |
|
|
13 | (5) |
|
|
14 | (1) |
|
Placeholders, Text Areas, Mouse Pointer, and Scroll Bars |
|
|
15 | (1) |
|
Status Bar, Menu Bar, Standard Toolbar, Formatting Toolbar, and Drawing Toolbar |
|
|
15 | (3) |
|
|
18 | (1) |
|
Choosing a Design Template |
|
|
19 | (3) |
|
|
22 | (3) |
|
Entering the Presentation Title |
|
|
22 | (1) |
|
Correcting a Mistake When Typing |
|
|
23 | (1) |
|
Entering the Presentation Subtitle |
|
|
23 | (2) |
|
|
25 | (4) |
|
Changing the Style of Text to Italic |
|
|
25 | (2) |
|
|
27 | (2) |
|
Saving the Presentation on a Floppy Disk |
|
|
29 | (3) |
|
Adding a New Slide to a Presentation |
|
|
32 | (1) |
|
Creating a Text Slide with a Single-Level Bulleted List |
|
|
33 | (3) |
|
|
33 | (1) |
|
Selecting a Text Placeholder |
|
|
34 | (1) |
|
Typing a Single-Level Bulleted List |
|
|
35 | (1) |
|
Creating a Text Slide with a Multi-Level Bulleted List |
|
|
36 | (7) |
|
Adding New Slides and Entering Slide Titles |
|
|
37 | (1) |
|
Typing a Multi-Level Bulleted List |
|
|
38 | (3) |
|
Creating a Third-Level Paragraph |
|
|
41 | (2) |
|
Ending a Slide Show with a Black Slide |
|
|
43 | (2) |
|
Saving a Presentation with the Same File Name |
|
|
45 | (1) |
|
Moving to Another Slide in Normal View |
|
|
45 | (2) |
|
Using the Scroll Box on the Slide Pane to Move to Another Slide |
|
|
45 | (2) |
|
Viewing the Presentation in Slide Show View |
|
|
47 | (4) |
|
|
47 | (2) |
|
Advancing Through a Slide Show Manually |
|
|
49 | (1) |
|
Using the Popup Menu to Go to a Specific Slide |
|
|
49 | (2) |
|
Using the Popup Menu to End a Slide Show |
|
|
51 | (1) |
|
|
51 | (2) |
|
|
53 | (2) |
|
Opening an Existing Presentation |
|
|
53 | (2) |
|
Checking a Presentation for Spelling and Consistency |
|
|
55 | (2) |
|
Checking a Presentation for Spelling Errors |
|
|
55 | (1) |
|
Starting the Spelling Checker |
|
|
55 | (2) |
|
|
57 | (1) |
|
Types of Corrections Made to Presentations |
|
|
57 | (1) |
|
|
58 | (1) |
|
Replacing Text in an Existing Slide |
|
|
58 | (1) |
|
Displaying a Presentation in Black and White |
|
|
58 | (2) |
|
|
60 | (1) |
|
|
60 | (1) |
|
Printing the Presentation |
|
|
60 | (1) |
|
|
61 | (1) |
|
|
61 | (4) |
|
Obtaining Help Using the Ask a Question Box on the Menu Bar |
|
|
62 | (2) |
|
|
64 | (1) |
|
|
65 | (1) |
|
|
66 | (1) |
|
|
67 | (1) |
|
|
68 | (1) |
|
|
69 | (7) |
|
|
76 | |
2 PROJECT TWO |
|
|
Using the Outline Tab and Clip Art to Create a Slide Show |
|
|
|
|
01 | (3) |
|
|
04 | (1) |
|
Project Two --- Enjoy Spring Break in the Caribbean |
|
|
04 | (2) |
|
|
06 | (1) |
|
|
07 | (3) |
|
Creating a Presentation on the Outline Tab |
|
|
10 | (2) |
|
Creating a Title Slide on the Outline Tab |
|
|
10 | (2) |
|
Adding a Slide on the Outline Tab |
|
|
12 | (1) |
|
Creating a Text Slide with a Single-Level Bulleted List on the Outline Tab |
|
|
12 | (2) |
|
Creating Text Slides with Multi-Level Bulleted Lists on the Outline Tab |
|
|
14 | (3) |
|
Creating a Second Text Slide with a Multi-Level Bulleted List |
|
|
15 | (1) |
|
Creating a Closing Slide on the Outline Tab |
|
|
16 | (1) |
|
|
17 | (1) |
|
Reviewing a Presentation in Slide Sorter View |
|
|
18 | (3) |
|
|
21 | (3) |
|
Adding Clip Art to a Slide |
|
|
24 | (7) |
|
Inserting Clip Art into a Content Placeholder |
|
|
24 | (3) |
|
Inserting a Second Clip into a Slide |
|
|
27 | (1) |
|
Inserting Clip Art into a Slide without a Content Placeholder |
|
|
28 | (2) |
|
|
30 | (1) |
|
Using the Automatic Layout Options Button to Undo a Layout Change |
|
|
31 | (2) |
|
|
33 | (1) |
|
Changing the Size of Clip Art |
|
|
33 | (3) |
|
Inserting, Moving, and Sizing a Clip into a Slide |
|
|
36 | (1) |
|
Saving the Presentation Again |
|
|
36 | (1) |
|
Adding a Header and Footer to Outline Pages |
|
|
37 | (2) |
|
Using the Notes and Handouts Sheet to Add Headers and Footers |
|
|
37 | (2) |
|
Applying Animation Schemes |
|
|
39 | (3) |
|
Adding an Animation Scheme to a Slide Show |
|
|
39 | (3) |
|
|
42 | (3) |
|
|
42 | (3) |
|
Saving the Presentation Again |
|
|
45 | (1) |
|
Running an Animated Slide Show |
|
|
45 | (2) |
|
Printing a Presentation Created on the Outline Tab |
|
|
47 | (4) |
|
|
47 | (3) |
|
Printing Presentation Slides |
|
|
50 | (1) |
|
E-Mailing a Slide Show from within PowerPoint |
|
|
51 | (2) |
|
Saving and Quitting PowerPoint |
|
|
53 | (1) |
|
|
53 | (1) |
|
|
54 | (1) |
|
|
55 | (1) |
|
|
56 | (1) |
|
|
57 | (7) |
|
|
64 | |
WEB FEATURE |
|
|
Creating a Presentation on the Web Using PowerPoint |
|
|
|
|
01 | (2) |
|
Saving a PowerPoint Presentation as a Web Page |
|
|
03 | (3) |
|
Viewing a Presentation as a Web Page |
|
|
06 | (2) |
|
Editing a Web Page through a Browser |
|
|
08 | (3) |
|
|
11 | (1) |
|
|
12 | (1) |
|
|
13 | |
Microsoft Outlook 2002 |
|
1 PROJECT ONE |
|
|
Schedule and Contact Management Using Outlook |
|
|
|
|
03 | (3) |
|
What Is Microsoft Outlook? |
|
|
06 | (1) |
|
Project One --- Personal Information Manager |
|
|
06 | (2) |
|
|
08 | (1) |
|
Opening the Calendar Folder |
|
|
08 | (1) |
|
The Calendar - Microsoft Outlook Window |
|
|
09 | (4) |
|
Creating a Personal Subfolder in the Calendar Folder |
|
|
11 | (2) |
|
Changing to a Personal Folder |
|
|
13 | (1) |
|
Entering Appointments Using the Appointment Area |
|
|
13 | (10) |
|
Entering Appointments Using the Appointment Window |
|
|
15 | (2) |
|
|
17 | (2) |
|
Moving to the Next Day in Calendar and Entering the Remaining Recurring Appointments |
|
|
19 | (1) |
|
Using Natural Language Phrases to Enter Appointment Dates and Times |
|
|
20 | (3) |
|
|
23 | (1) |
|
|
23 | (1) |
|
Moving Appointments to a New Time |
|
|
24 | (2) |
|
Moving Appointments to a New Date |
|
|
26 | (1) |
|
Moving an Appointment to a New Month |
|
|
27 | (2) |
|
|
29 | (1) |
|
Displaying the Calendar in Week and Month Views |
|
|
30 | (3) |
|
|
30 | (1) |
|
|
31 | (1) |
|
|
32 | (1) |
|
Creating a Task List Using the TaskPad |
|
|
33 | (2) |
|
|
35 | (2) |
|
|
35 | (1) |
|
|
36 | (1) |
|
|
36 | (1) |
|
|
36 | (1) |
|
|
37 | (9) |
|
Creating a Personal Subfolder in the Contacts Folder |
|
|
37 | (2) |
|
|
39 | (3) |
|
Finding a Contact Quickly |
|
|
42 | (1) |
|
|
43 | (2) |
|
Printing the Contact List |
|
|
45 | (1) |
|
Exporting, Deleting, and Importing Subfolders |
|
|
46 | (5) |
|
|
46 | (2) |
|
|
48 | (2) |
|
|
50 | (1) |
|
|
51 | (1) |
|
|
52 | (1) |
|
|
52 | (1) |
|
|
53 | (1) |
|
|
54 | (1) |
|
|
55 | |
Office XP Integration |
|
1 PROJECT ONE |
|
|
Integrating Office XP Applications and the World Wide Web |
|
|
|
|
01 | (3) |
|
|
04 | (1) |
|
Integration Project --- Garden National Bank Web Site |
|
|
05 | (1) |
|
Adding Hyperlinks to a Word Document |
|
|
05 | (8) |
|
Starting Word and Opening a Document |
|
|
08 | (1) |
|
Inserting a Table into a Word Document |
|
|
09 | (1) |
|
Eliminating the Table Border |
|
|
10 | (1) |
|
Inserting the Text for the Hyperlinks |
|
|
11 | (1) |
|
Inserting a Hyperlink to PowerPoint Web Pages |
|
|
12 | (1) |
|
Embedding an Excel Chart into a Word Document |
|
|
13 | (7) |
|
Changing the Size of an Embedded Object |
|
|
16 | (3) |
|
|
19 | (1) |
|
Adding Scrolling Text to a Word Document |
|
|
20 | (4) |
|
|
21 | (2) |
|
Resizing the Scrolling Text |
|
|
23 | (1) |
|
Viewing the Word Document in Your Browser and Saving It as a Web Page |
|
|
24 | (2) |
|
Creating a PowerPoint Presentation Web Page |
|
|
26 | (5) |
|
Adding Text for a Hyperlink |
|
|
28 | (1) |
|
|
28 | (1) |
|
Viewing and Saving the PowerPoint Web Page |
|
|
29 | (2) |
|
Saving the PowerPoint Presentation as a Web Page |
|
|
31 | (1) |
|
Creating a Data Access Page from an Access Database |
|
|
31 | (9) |
|
Creating a Data Access Page Using the Wizard |
|
|
32 | (3) |
|
Adding a Title and Resizing a Label on a Data Access Page |
|
|
35 | (2) |
|
Adding a Hyperlink to a Data Access Page |
|
|
37 | (2) |
|
Saving the Data Access Page and Viewing It |
|
|
39 | (1) |
|
|
40 | (2) |
|
Verifying the Hyperlinks in Your Browser |
|
|
41 | (1) |
|
|
42 | (1) |
|
|
42 | (1) |
|
|
43 | (5) |
|
|
48 | |
APPENDIX A Microsoft Office XP Help System |
|
|
Using the Microsoft Office Help System |
|
|
1 | (1) |
|
|
2 | (2) |
|
|
4 | (3) |
|
Showing and Hiding the Office Assistant |
|
|
4 | (1) |
|
Turning the Office Assistant On and Off |
|
|
4 | (1) |
|
Using the Office Assistant |
|
|
5 | (2) |
|
The Microsoft Word Help Window |
|
|
7 | (2) |
|
|
7 | (1) |
|
Using the Answer Wizard Sheet |
|
|
8 | (1) |
|
|
8 | (1) |
|
What's This? Command and Question Mark Button |
|
|
9 | (1) |
|
|
10 | (1) |
|
|
10 | (1) |
|
Office on the Web Command |
|
|
10 | (1) |
|
|
11 | (1) |
|
|
11 | (1) |
|
|
11 | (1) |
|
Detect and Repair Command |
|
|
11 | (1) |
|
About Microsoft Word Command |
|
|
11 | (1) |
|
|
12 | |
APPENDIX B Speech and Handwriting Recognition and Speech Playback |
|
|
|
1 | (1) |
|
|
1 | (4) |
|
Buttons on the Language Bar |
|
|
2 | (1) |
|
Customizing the Language Bar |
|
|
2 | (3) |
|
|
5 | (4) |
|
Getting Started with Speech Recognition |
|
|
6 | (2) |
|
|
8 | (1) |
|
|
9 | (5) |
|
|
9 | (3) |
|
|
12 | (1) |
|
|
12 | (1) |
|
|
13 | (1) |
|
|
14 | |
|
Customizing Speech Playback |
|
|
15 | |
APPENDIX C Publishing Office Web Pages to a Web Server |
|
|
Using Web Folders to Publish Office Web Pages |
|
|
1 | (1) |
|
Using FTP to Publish Office Web Pages |
|
|
1 | (1) |
APPENDIX D Resetting the Toolbars and Menus |
|
1 | (1) |
APPENDIX E Microsoft Office User Specialist Certification Program |
|
|
What Is MOUS Certification? |
|
|
1 | (1) |
|
Why Should You Get Certified? |
|
|
1 | (1) |
|
|
2 | (1) |
|
How Can You Prepare for the MOUS Exams? |
|
|
2 | (1) |
|
How to Find an Authorized Testing Center |
|
|
2 | (1) |
|
Shelly Cashman Series MOUS Web Page |
|
|
2 | |
Index |
|
1 | (1) |
Quick Reference Summary |
|
1 | |