Essential Introduction to Computers |
|
|
|
1 | (1) |
|
Why Study Computers and Application Software? |
|
|
2 | (1) |
|
|
3 | (1) |
|
|
3 | (1) |
|
How Does a Computer Know What to Do? |
|
|
4 | (1) |
|
What Are the Components of a Computer? |
|
|
4 | (9) |
|
|
5 | (2) |
|
The Central Processing Unit |
|
|
7 | (1) |
|
|
7 | (1) |
|
|
7 | (3) |
|
|
10 | (3) |
|
|
13 | (1) |
|
|
13 | (1) |
|
|
13 | (1) |
|
Personal Computer Application Software |
|
|
14 | (1) |
|
|
14 | (1) |
|
|
14 | (1) |
|
|
14 | (1) |
|
|
15 | (1) |
|
Networks and the Internet |
|
|
15 | (3) |
|
|
16 | (1) |
|
|
17 | (1) |
|
How to Purchase, Install, and Maintain a Personal Computer |
|
|
18 | (12) |
|
How to Purchase a Personal Computer |
|
|
18 | (5) |
|
How to Purchase a Laptop Computer |
|
|
23 | (2) |
|
How to Install a Personal Computer |
|
|
25 | (3) |
|
How to Maintain a Personal Computer |
|
|
28 | (2) |
|
|
30 | (2) |
|
Student Assignment 1: True/False |
|
|
30 | (1) |
|
Student Assignment 2: Multiple Choice |
|
|
30 | (1) |
|
Student Assignment 3: Visiting WEB INFO Sites |
|
|
31 | (1) |
|
Student Assignment 4: Using the Shelly Cashman Series Web Guide |
|
|
31 | (1) |
|
Student Assignment 5: Comparing Personal Computer Advertisements |
|
|
31 | (1) |
|
Student Assignment 6: Evaluating Online Information Services |
|
|
31 | (1) |
|
Student Assignment 7: Visiting Local Computer Retail Stores |
|
|
32 | |
|
Student Assignment 8: Understanding the Y2K Problem |
|
|
31 | (1) |
|
|
32 | (1) |
|
|
32 | |
Windows 98 and Microsoft Office 2000 |
|
|
An Introduction to Windows 98 and Office 2000 |
|
|
|
|
1 | (3) |
|
|
4 | (1) |
|
What Is Microsoft Windows 98? |
|
|
5 | (3) |
|
What Is a User Interface? |
|
|
5 | (1) |
|
Launching Microsoft Windows 98 |
|
|
6 | (2) |
|
Closing the Welcome Screen |
|
|
8 | (1) |
|
The Desktop as a Work Area |
|
|
8 | (1) |
|
Communicating with Microsoft Windows 98 |
|
|
8 | (18) |
|
|
8 | (1) |
|
|
9 | (2) |
|
|
11 | (2) |
|
|
13 | (1) |
|
|
14 | (1) |
|
|
14 | (2) |
|
Maximize and Restore Buttons |
|
|
16 | (3) |
|
|
19 | (1) |
|
|
20 | (1) |
|
Sizing a Window by Dragging |
|
|
21 | (1) |
|
|
22 | (2) |
|
|
24 | (1) |
|
|
24 | (1) |
|
|
24 | (2) |
|
Summary of Mouse and Windows Operations |
|
|
26 | (1) |
|
The Keyboard and Keyboard Shortcuts |
|
|
26 | (1) |
|
The Windows 98 Desktop Views |
|
|
27 | (1) |
|
Launching an Application Program |
|
|
27 | (3) |
|
Launching an Application Using the Start Button |
|
|
27 | (2) |
|
|
29 | (1) |
|
|
30 | (7) |
|
Starting Windows Explorer and Maximizing Its Window |
|
|
30 | (1) |
|
The Exploring - My Computer Window |
|
|
31 | (2) |
|
Displaying the Contents of a Folder |
|
|
33 | (2) |
|
|
35 | (1) |
|
|
36 | (1) |
|
Copying Files to a Folder on a Floppy Disk |
|
|
37 | (12) |
|
|
37 | (3) |
|
Displaying the Destination Folder |
|
|
40 | (1) |
|
Displaying the Contents of the Windows Folder |
|
|
40 | (2) |
|
|
42 | (1) |
|
Selecting a Group of Files |
|
|
43 | (2) |
|
|
45 | (1) |
|
Displaying the Contents of the My Files Folder |
|
|
46 | (1) |
|
Renaming a File or Folder |
|
|
47 | (2) |
|
Deleting a File or Folder |
|
|
49 | (3) |
|
Deleting a File by Right-Clicking Its File Name |
|
|
49 | (2) |
|
|
51 | (1) |
|
Quitting Windows Explorer |
|
|
52 | (1) |
|
|
52 | (6) |
|
|
52 | (4) |
|
|
56 | (2) |
|
|
58 | (1) |
|
What Is Microsoft Office 2000? |
|
|
59 | (2) |
|
The Internet, World Wide Web, and Intranets |
|
|
60 | (1) |
|
Microsoft Office 2000 and the Internet |
|
|
60 | (1) |
|
|
61 | (2) |
|
Microsoft Word 2000 and the Internet |
|
|
62 | (1) |
|
|
63 | (1) |
|
Microsoft Excel 2000 and the Internet |
|
|
63 | (1) |
|
|
64 | (2) |
|
Microsoft Access 2000 and the Internet |
|
|
65 | (1) |
|
Microsoft PowerPoint 2000 |
|
|
66 | (2) |
|
Microsoft PowerPoint 2000 and the Internet |
|
|
66 | (2) |
|
|
68 | (1) |
|
|
69 | (1) |
|
Microsoft Publisher and the Internet |
|
|
70 | (1) |
|
|
70 | (1) |
|
|
71 | (1) |
|
|
72 | (2) |
|
The Microsoft Office 2000 Help System |
|
|
74 | (1) |
|
|
75 | (1) |
|
|
75 | (1) |
|
|
76 | |
Microsoft Word 2000 |
|
|
Creating and Editing a Word Document |
|
|
|
|
1 | (5) |
|
What Is Microsoft Word 2000? |
|
|
6 | (1) |
|
|
6 | (2) |
|
|
8 | (1) |
|
|
9 | (7) |
|
|
9 | (2) |
|
|
11 | (3) |
|
Resetting Menus and Toolbars |
|
|
14 | (1) |
|
Displaying the Entire Standard Toolbar |
|
|
14 | (1) |
|
|
15 | (1) |
|
Changing the Default Font Size |
|
|
16 | (1) |
|
|
17 | (9) |
|
Entering Blank Lines into a Document |
|
|
19 | (1) |
|
Displaying Formatting Marks |
|
|
20 | (1) |
|
|
21 | (1) |
|
|
21 | (1) |
|
Checking Spelling Automatically as You Type |
|
|
22 | (2) |
|
Entering Text that Scrolls the Document Window |
|
|
24 | (2) |
|
|
26 | (3) |
|
Formatting Paragraphs and Characters in a Document |
|
|
29 | (13) |
|
Selecting and Formatting Paragraphs and Characters |
|
|
29 | (1) |
|
Selecting Multiple Paragraphs |
|
|
30 | (1) |
|
Changing the Font of Selected Text |
|
|
30 | (1) |
|
Changing the Font Size of Selected Text |
|
|
31 | (1) |
|
|
32 | (1) |
|
|
33 | (1) |
|
|
34 | (1) |
|
Undoing Commands or Actions |
|
|
35 | (1) |
|
Selecting a Line and Formatting It |
|
|
36 | (1) |
|
|
37 | (2) |
|
|
39 | (1) |
|
|
39 | (1) |
|
Selecting a Group of Words |
|
|
40 | (1) |
|
Underlining Selected Text |
|
|
41 | (1) |
|
Inserting Clip Art into a Word Document |
|
|
42 | (6) |
|
|
43 | (3) |
|
Selecting and Centering a Graphic |
|
|
46 | (1) |
|
|
47 | (1) |
|
Restoring a Resized Graphic to Its Original Size |
|
|
48 | (1) |
|
Saving an Existing Document with the Same File Name |
|
|
48 | (1) |
|
|
49 | (1) |
|
|
50 | (1) |
|
|
51 | (2) |
|
|
53 | (2) |
|
Types of Changes Made to Documents |
|
|
53 | (1) |
|
Inserting Text into an Existing Document |
|
|
54 | (1) |
|
Deleting Text from an Existing Document |
|
|
54 | (1) |
|
Closing the Entire Document |
|
|
54 | (1) |
|
|
55 | (3) |
|
Using the Office Assistant |
|
|
55 | (3) |
|
|
58 | (1) |
|
|
58 | (1) |
|
|
59 | (1) |
|
|
60 | (3) |
|
|
63 | |
|
Creating a Research Paper |
|
|
|
|
1 | (3) |
|
|
4 | (1) |
|
Web Publishing Research Paper |
|
|
4 | (3) |
|
|
6 | (1) |
|
|
6 | (1) |
|
Resetting Menus and Toolbars |
|
|
7 | (1) |
|
Displaying Formatting Marks |
|
|
7 | (1) |
|
|
7 | (2) |
|
|
9 | (1) |
|
|
9 | (2) |
|
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 |
|
|
13 | (2) |
|
Typing the Body of the Research Paper |
|
|
15 | (19) |
|
Changing the Default Font Size |
|
|
15 | (1) |
|
Entering Name and Course Information |
|
|
15 | (1) |
|
Applying Formatting Using Shortcut Keys |
|
|
16 | (2) |
|
Saving the Research Paper |
|
|
18 | (1) |
|
|
18 | (2) |
|
Using Word's AutoCorrect Feature |
|
|
20 | (3) |
|
|
23 | (2) |
|
|
25 | (6) |
|
|
31 | (2) |
|
Inserting Arrows, Faces, and Other Symbols Automatically |
|
|
33 | (1) |
|
Creating an Alphabetical Works Cited Page |
|
|
34 | (7) |
|
|
34 | (1) |
|
Centering the Title of the Works Cited Page |
|
|
35 | (1) |
|
Creating a Hanging Indent |
|
|
36 | (2) |
|
|
38 | (1) |
|
|
39 | (2) |
|
Proofing and Revising the Research Paper |
|
|
41 | (12) |
|
Going to a Specific Location in a Document |
|
|
41 | (2) |
|
Finding and Replacing Text |
|
|
43 | (2) |
|
|
45 | (1) |
|
|
45 | (3) |
|
|
48 | (1) |
|
|
48 | (2) |
|
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 | (5) |
|
|
62 | |
|
Using a Wizard to Create a Resume and Creating a Cover Letter with a Table |
|
|
|
|
1 | (3) |
|
|
4 | (1) |
|
|
4 | (2) |
|
Using Word's Resume Wizard to Create a Resume |
|
|
6 | (9) |
|
Resetting Menus and Toolbars |
|
|
13 | (2) |
|
|
15 | (9) |
|
Displaying Formatting Marks |
|
|
15 | (1) |
|
|
15 | (1) |
|
|
16 | (1) |
|
|
17 | (1) |
|
Selecting and Replacing Text |
|
|
18 | (3) |
|
|
21 | (3) |
|
Viewing and Printing the Resume in Print Preview |
|
|
24 | (3) |
|
|
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) |
|
Inserting Symbols into a Document |
|
|
37 | (2) |
|
Adding a Bottom Border to a Paragraph |
|
|
39 | (2) |
|
|
41 | (17) |
|
Components of a Business Letter |
|
|
41 | (1) |
|
Saving the Cover Letter with a New File Name |
|
|
42 | (1) |
|
Setting Tab Stops Using the Ruler |
|
|
42 | (2) |
|
Creating an AutoText Entry |
|
|
44 | (2) |
|
Entering a Nonbreaking Space |
|
|
46 | (1) |
|
Inserting an AutoText Entry |
|
|
47 | (2) |
|
|
49 | (3) |
|
Creating a Table with the Insert Table Button |
|
|
52 | (1) |
|
Entering Data into a Word Table |
|
|
53 | (2) |
|
|
55 | (1) |
|
Changing the Table Alignment |
|
|
56 | (2) |
|
Saving Again and Printing the Cover Letter |
|
|
58 | (1) |
|
Preparing and Printing an Envelope Address |
|
|
58 | (3) |
|
|
61 | (1) |
|
|
61 | (1) |
|
|
62 | (1) |
|
|
63 | (2) |
|
|
65 | |
WEB FEATURE Creating Web Pages Using Word |
|
|
|
1 | (2) |
|
Saving a Word Document as a Web Page |
|
|
3 | (1) |
|
Formatting the E-mail Address as a Hyperlink |
|
|
4 | (1) |
|
Using Word's Web Page Wizard to Create a Web Page |
|
|
4 | (4) |
|
|
8 | (5) |
|
Viewing the Web Page in Your Default Browser |
|
|
11 | (1) |
|
Editing a Web Page from Your Browser |
|
|
11 | (2) |
|
|
13 | (1) |
|
|
14 | |
Microsoft Excel 2000 |
|
|
Creating a Worksheet and Embedded Chart |
|
|
|
|
1 | (5) |
|
What Is Microsoft Excel 2000? |
|
|
6 | (1) |
|
Fun-N-Sun Sojourn First Quarter Sales |
|
|
6 | (3) |
|
|
8 | (1) |
|
|
9 | (2) |
|
|
9 | (2) |
|
|
11 | (4) |
|
|
12 | (1) |
|
Standard Toolbar and Formatting Toolbar |
|
|
12 | (2) |
|
Resetting Menus and Toolbars |
|
|
14 | (1) |
|
|
14 | (1) |
|
|
14 | (1) |
|
|
15 | (1) |
|
|
15 | (5) |
|
Entering the Worksheet Title |
|
|
16 | (1) |
|
Correcting a Mistake While Typing |
|
|
17 | (1) |
|
|
18 | (1) |
|
|
18 | (1) |
|
|
19 | (1) |
|
|
20 | (2) |
|
|
22 | (2) |
|
Using the Fill Handle to Copy a Cell to Adjacent Cells |
|
|
24 | (3) |
|
|
25 | (2) |
|
|
27 | (7) |
|
Fonts, Font Size, and Font Style |
|
|
28 | (1) |
|
Displaying the Formatting Toolbar in Its Entirety |
|
|
28 | (1) |
|
|
28 | (2) |
|
|
30 | (1) |
|
Using AutoFormat to Format the Body of a Worksheet |
|
|
31 | (2) |
|
Centering the Worksheet Title Across Columns |
|
|
33 | (1) |
|
Using the Name Box to Select a Cell |
|
|
34 | (2) |
|
Adding a 3-D Column Chart to the Worksheet |
|
|
36 | (5) |
|
|
41 | (4) |
|
|
45 | (1) |
|
|
46 | (1) |
|
Starting Excel and Opening a Workbook |
|
|
47 | (2) |
|
|
49 | (2) |
|
|
51 | (3) |
|
Correcting Errors While You Are Typing Data into a Cell |
|
|
51 | (1) |
|
|
51 | (1) |
|
|
52 | (1) |
|
Clearing a Cell or Range of Cells |
|
|
53 | (1) |
|
Clearing the Entire Worksheet |
|
|
54 | (1) |
|
|
54 | (4) |
|
Using the Office Assistant |
|
|
54 | (3) |
|
|
57 | (1) |
|
|
58 | (1) |
|
|
58 | (1) |
|
|
59 | (1) |
|
|
60 | (3) |
|
|
63 | |
|
Formulas, Functions, Formatting, and Web Queries |
|
|
|
|
1 | (3) |
|
|
4 | (1) |
|
|
4 | (3) |
|
Starting Excel and Resetting the Toolbars |
|
|
6 | (1) |
|
Entering the Titles and Numbers into the Worksheet |
|
|
7 | (2) |
|
|
9 | (7) |
|
|
10 | (1) |
|
Entering Formulas Using Point Mode |
|
|
11 | (1) |
|
Copying the Formulas Using the Fill Handle |
|
|
12 | (2) |
|
Determining the Totals Using the AutoSum Button |
|
|
14 | (1) |
|
Determining the Total Percentage Gain/Loss |
|
|
15 | (1) |
|
Using the Average, Max, and Min Functions |
|
|
16 | (7) |
|
Determining the Average of a Range of Numbers |
|
|
16 | (2) |
|
Determining the Highest Number in a Range of Numbers |
|
|
18 | (2) |
|
Determining the Lowest Number in a Range of Numbers |
|
|
20 | (1) |
|
Copying the AVERAGE, MAX, and MIN Functions |
|
|
21 | (2) |
|
|
23 | (3) |
|
Verifying a Formula Using Range Finder |
|
|
24 | (1) |
|
Verifying a Formula Using the Auditing Commands |
|
|
24 | (2) |
|
|
26 | (22) |
|
Changing the Font and Centering the Worksheet Title |
|
|
28 | (2) |
|
Changing the Worksheet Title Background and Font Colors and Applying an Outline Border |
|
|
30 | (2) |
|
Applying Formats to the Column Titles |
|
|
32 | (1) |
|
Centering the Stock Symbols and Formatting the Numbers in the Worksheet |
|
|
33 | (2) |
|
Formatting Numbers Using the Formatting Toolbar |
|
|
35 | (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 the Workbook a Second Time Using the Same File Name |
|
|
50 | (1) |
|
Previewing and Printing the Worksheet |
|
|
51 | (4) |
|
Printing a Section of the Worksheet |
|
|
54 | (1) |
|
Displaying and Printing the Formulas Version of the Worksheet |
|
|
55 | (3) |
|
Changing the Print Scaling Option Back to 100% |
|
|
57 | (1) |
|
Getting External Data from a Web Source Using a Web Query |
|
|
58 | (3) |
|
|
61 | (1) |
|
E-mailing a Workbook from within Excel |
|
|
62 | (2) |
|
|
64 | (1) |
|
|
64 | (1) |
|
|
65 | (1) |
|
|
66 | (2) |
|
|
68 | (9) |
|
|
77 | |
|
What-If Analysis, Charting, and Working with Large Worksheets |
|
|
|
|
1 | (3) |
|
|
4 | (2) |
|
Hyperlink.com Six-Month Projected Revenue, Expenses, and Net Income |
|
|
6 | (2) |
|
Starting Excel and Resetting Toolbars and Menus |
|
|
6 | (1) |
|
Changing the Font of the Entire Worksheet to Bold |
|
|
7 | (1) |
|
Entering the Worksheet Titles |
|
|
7 | (1) |
|
Rotating Text and Using the Fill Handle to Create a Series |
|
|
8 | (2) |
|
Copying a Cell's Format Using the Format Painter Button |
|
|
10 | (3) |
|
Increasing the Column Widths and Entering Row Titles |
|
|
11 | (2) |
|
Copying a Range of Cells to a Nonadjacent Paste Area |
|
|
13 | (3) |
|
Using Drag and Drop to Move or Copy Cells |
|
|
15 | (1) |
|
Inserting and Deleting Cells in a Worksheet |
|
|
16 | (2) |
|
|
16 | (1) |
|
|
17 | (1) |
|
Inserting Individual Cells or a Range of Cells |
|
|
17 | (1) |
|
Deleting Columns and Rows |
|
|
18 | (1) |
|
Deleting Individual Cells or a Range of Cells |
|
|
18 | (1) |
|
Entering Numbers with a Format Symbol |
|
|
18 | (1) |
|
Freezing Worksheet Titles |
|
|
19 | (2) |
|
Entering the Projected Revenue |
|
|
20 | (1) |
|
Displaying the System Date |
|
|
21 | (3) |
|
Absolute Versus Relative Addressing |
|
|
24 | (3) |
|
Entering the July Administrative, Marketing, and Commission Formulas |
|
|
25 | (2) |
|
Making Decisions - The IF Function |
|
|
27 | (5) |
|
Entering the Remaining Projected Expense and Net Income Formulas for July |
|
|
29 | (1) |
|
Copying the Projected July 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 |
|
|
32 | (1) |
|
|
32 | (11) |
|
|
33 | (3) |
|
Formatting the Worksheet Titles |
|
|
36 | (1) |
|
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) |
|
Adding a 3-D Pie Chart to the Workbook |
|
|
43 | (13) |
|
Drawing a 3-D Pie Chart on a Separate Chart Sheet |
|
|
44 | (5) |
|
Formatting the Chart Title and Chart Labels |
|
|
49 | (1) |
|
Changing the Colors of the Slices |
|
|
50 | (2) |
|
Exploding the 3-D Pie Chart |
|
|
52 | (1) |
|
Rotating and Tilting the 3-D Pie Chart |
|
|
52 | (3) |
|
Adding Leader Lines to the Data Labels |
|
|
55 | (1) |
|
Changing the Names of the Sheets and Rearranging the Order of the Sheets |
|
|
56 | (1) |
|
Checking Spelling, Saving, Previewing, and Printing the Workbook |
|
|
57 | (2) |
|
Checking Spelling in Multiple Sheets |
|
|
57 | (1) |
|
Previewing and Printing the Workbook |
|
|
57 | (2) |
|
Changing the View of the Worksheet |
|
|
59 | (4) |
|
Shrinking and Magnifying the View of a Worksheet or Chart |
|
|
59 | (2) |
|
Splitting the Window into Panes |
|
|
61 | (2) |
|
|
63 | (4) |
|
|
65 | (2) |
|
|
67 | (1) |
|
|
67 | (1) |
|
|
68 | (1) |
|
|
69 | (1) |
|
|
70 | (9) |
|
|
79 | |
WEB FEATURE Creating Static and Dynamic Web Pages Using Excel |
|
|
|
1 | (3) |
|
Saving an Excel Workbook as a Static Web Page |
|
|
4 | (3) |
|
Viewing the Static Web Page Using Your Browser |
|
|
6 | (1) |
|
Saving an Excel Chart as a Dynamic Web Page |
|
|
7 | (6) |
|
Viewing and Manipulating the Dynamic Web Page Using Your Browser |
|
|
10 | (1) |
|
Modifying the Worksheet on a Dynamic Web Page |
|
|
11 | (2) |
|
|
13 | (1) |
|
|
14 | (1) |
|
|
15 | |
Microsoft Access 2000 |
|
|
Creating a Database Using Design and Datasheet Views |
|
|
|
|
1 | (5) |
|
What Is Microsoft Access 2000? |
|
|
6 | (1) |
|
Bavant Marine Services Database |
|
|
6 | (6) |
|
Starting Access and Creating a New Database |
|
|
9 | (3) |
|
The Access Desktop and the Database Window |
|
|
12 | (1) |
|
|
13 | (6) |
|
|
15 | (3) |
|
Correcting Errors in the Structure |
|
|
18 | (1) |
|
|
19 | (1) |
|
Adding Records to a Table |
|
|
20 | (4) |
|
Closing a Table and a Database and Quitting Access |
|
|
24 | (1) |
|
|
25 | (2) |
|
Adding Additional Records |
|
|
27 | (3) |
|
Correcting Errors in the Data |
|
|
29 | (1) |
|
Previewing and Printing the Contents of a Table |
|
|
30 | (4) |
|
Creating Additional Tables |
|
|
34 | (2) |
|
Adding Records to the Additional Table |
|
|
35 | (1) |
|
Using a Form to View Data |
|
|
36 | (7) |
|
|
37 | (1) |
|
Closing and Saving the Form |
|
|
38 | (1) |
|
|
39 | (1) |
|
|
40 | (1) |
|
Switching Between Form View and Datasheet View |
|
|
41 | (2) |
|
|
43 | (6) |
|
Selecting the Fields for the Report |
|
|
44 | (2) |
|
|
46 | (2) |
|
|
48 | (1) |
|
|
49 | (1) |
|
|
49 | (2) |
|
Using the Office Assistant |
|
|
49 | (2) |
|
|
51 | (3) |
|
|
54 | (1) |
|
|
54 | (1) |
|
|
55 | (2) |
|
|
57 | (6) |
|
|
63 | |
|
Querying a Database Using the Select Query Window |
|
|
|
|
1 | (3) |
|
|
4 | (1) |
|
Querying the Bavant Marine Services Database |
|
|
4 | (2) |
|
|
6 | (1) |
|
|
6 | (8) |
|
Using the Select Query Window |
|
|
9 | (1) |
|
Displaying Selected Fields in a Query |
|
|
9 | (2) |
|
|
11 | (1) |
|
Printing the Results of a Query |
|
|
12 | (1) |
|
|
12 | (2) |
|
|
14 | (1) |
|
Including All Fields in a Query |
|
|
14 | (2) |
|
|
16 | (1) |
|
|
17 | (6) |
|
Using Text Data in Criteria |
|
|
17 | (1) |
|
|
18 | (1) |
|
Criteria for a Field Not in the Result |
|
|
19 | (2) |
|
Using Numeric Data in Criteria |
|
|
21 | (1) |
|
Using Comparison Operators |
|
|
22 | (1) |
|
|
23 | (3) |
|
|
23 | (2) |
|
|
25 | (1) |
|
|
26 | (5) |
|
|
27 | (2) |
|
|
29 | (2) |
|
|
31 | (4) |
|
Restricting Records in a Join |
|
|
34 | (1) |
|
Using Calculated Fields in a Query |
|
|
35 | (3) |
|
|
38 | (4) |
|
Using Criteria in Calculating Statistics |
|
|
40 | (1) |
|
|
41 | (1) |
|
|
42 | (1) |
|
|
43 | (1) |
|
|
43 | (1) |
|
|
43 | (1) |
|
|
44 | (1) |
|
|
45 | (3) |
|
|
48 | |
|
Maintaining a Database Using the Design and Update Features of Access |
|
|
|
|
1 | (3) |
|
|
4 | (1) |
|
Maintaining the Bavant Marine Services Database |
|
|
5 | (1) |
|
|
6 | (1) |
|
Adding, Changing, and Deleting Records in a Table |
|
|
6 | (9) |
|
Adding Records in a Table |
|
|
6 | (2) |
|
|
8 | (2) |
|
Changing the Contents of a Record |
|
|
10 | (1) |
|
|
11 | (1) |
|
|
12 | (2) |
|
|
14 | (1) |
|
Changing the Structure of a Database |
|
|
15 | (13) |
|
Changing the Size of a Field |
|
|
15 | (2) |
|
|
17 | (2) |
|
Deleting a Field from a Table |
|
|
19 | (1) |
|
Updating the Restructured Database |
|
|
19 | (1) |
|
|
20 | (3) |
|
|
23 | (3) |
|
Using a Delete Query to Delete a Group of Records |
|
|
26 | (2) |
|
Creating Validation Rules |
|
|
28 | (10) |
|
Specifying a Required Field |
|
|
28 | (1) |
|
|
29 | (1) |
|
Specifying a Default Value |
|
|
30 | (1) |
|
Specifying a Collection of Legal Values |
|
|
31 | (1) |
|
|
32 | (1) |
|
Saving Rules, Values, and Formats |
|
|
33 | (1) |
|
Updating a Table that Contains Validation Rules |
|
|
34 | (2) |
|
Making Individual Changes to a Field |
|
|
36 | (2) |
|
Specifying Referential Integrity |
|
|
38 | (3) |
|
|
41 | (1) |
|
|
42 | (2) |
|
Ordering Records on Multiple Fields |
|
|
43 | (1) |
|
Creating and Using Indexes |
|
|
44 | (6) |
|
How Does Access Use an Index? |
|
|
46 | (1) |
|
When Should You Create an Index? |
|
|
47 | (1) |
|
Creating Single-Field Indexes |
|
|
47 | (1) |
|
Creating Multiple-Field Indexes |
|
|
48 | (2) |
|
|
50 | (1) |
|
|
51 | (1) |
|
|
51 | (1) |
|
|
52 | (1) |
|
|
53 | (6) |
|
|
59 | |
WEB FEATURE Publishing to the Internet Using Data Access Pages |
|
|
|
1 | (2) |
|
|
3 | (1) |
|
Creating a Data Access Page |
|
|
3 | (5) |
|
Previewing the Data Access Page |
|
|
8 | (1) |
|
Using the Data Access Page |
|
|
9 | (1) |
|
|
10 | (1) |
|
|
10 | (1) |
|
|
11 | |
Microsoft PowerPoint 2000 |
|
|
Using a Design Template and Autolayouts to Create a Presentation |
|
|
|
|
1 | (5) |
|
What Is Microsoft PowerPoint 2000? |
|
|
6 | (2) |
|
|
8 | (2) |
|
Starting a Presentation as a New Office Document |
|
|
10 | (2) |
|
|
12 | (6) |
|
|
13 | (1) |
|
Placeholders, Title Area, Object Area, Mouse Pointer, and Scroll Bars |
|
|
13 | (1) |
|
Menu Bar, Standard Toolbar, Formatting Toolbar, Drawing Toolbar, and Status Bar |
|
|
14 | (3) |
|
Resetting Menus and Toolbars |
|
|
17 | (1) |
|
Displaying the Formatting Toolbar in Its Entirety |
|
|
17 | (1) |
|
Choosing a Design Template |
|
|
18 | (2) |
|
|
20 | (4) |
|
Entering the Presentation Title |
|
|
20 | (2) |
|
Correcting a Mistake When Typing |
|
|
22 | (1) |
|
Entering the Presentation Subtitle |
|
|
23 | (1) |
|
|
24 | (4) |
|
|
24 | (3) |
|
Changing the Style of Text to Italic |
|
|
27 | (1) |
|
Saving the Presentation on a Floppy Disk |
|
|
28 | (3) |
|
Adding a New Slide to a Presentation |
|
|
31 | (2) |
|
Creating a Bulleted List Slide |
|
|
33 | (7) |
|
|
34 | (1) |
|
Selecting an Object Area Placeholder |
|
|
35 | (1) |
|
Typing a Multi-level Bulleted List |
|
|
36 | (4) |
|
Adding New Slides with the Same AutoLayout |
|
|
40 | (2) |
|
Ending a Slide Show with a Black Slide |
|
|
42 | (2) |
|
Saving a Presentation with the Same File Name |
|
|
44 | (1) |
|
Moving to Another Slide in Normal View |
|
|
44 | (2) |
|
Using the Scroll Box on the Slide Pane to Move to Another Slide |
|
|
44 | (2) |
|
Viewing the Presentation Using Slide Show |
|
|
46 | (4) |
|
|
46 | (1) |
|
Advancing Through a Slide Show Manually |
|
|
47 | (1) |
|
Using the Popup Menu to Go to a Specific Slide |
|
|
48 | (2) |
|
Using the Popup Menu to End a Slide Show |
|
|
50 | (1) |
|
|
50 | (1) |
|
|
51 | (3) |
|
Opening an Existing Presentation |
|
|
51 | (3) |
|
Checking a Presentation for Spelling and Consistency |
|
|
54 | (3) |
|
Checking a Presentation for Spelling Errors |
|
|
54 | (1) |
|
Starting the Spelling Checker |
|
|
54 | (2) |
|
Checking a Presentation for Style Consistency |
|
|
56 | (1) |
|
|
57 | (1) |
|
Types of Corrections Made to Presentations |
|
|
57 | (1) |
|
|
57 | (1) |
|
Replacing Text in an Existing Slide |
|
|
57 | (1) |
|
|
57 | (6) |
|
Displaying the Slide Master |
|
|
58 | (1) |
|
Changing Line Spacing on the Slide Master |
|
|
59 | (4) |
|
Displaying a Presentation in Black and White |
|
|
63 | (1) |
|
|
64 | (3) |
|
Saving a Presentation Before Printing |
|
|
64 | (1) |
|
Printing the Presentation |
|
|
65 | (2) |
|
|
67 | (1) |
|
|
67 | (2) |
|
Using the Office Assistant |
|
|
67 | (2) |
|
|
69 | (1) |
|
|
70 | (1) |
|
|
70 | (1) |
|
|
71 | (1) |
|
|
72 | (5) |
|
|
77 | |
|
Using Outline View and Clip Art to Create a Slide Show |
|
|
|
|
1 | (3) |
|
Creating a Presentation from an Outline |
|
|
4 | (1) |
|
Searching for Scholarships |
|
|
5 | (1) |
|
Starting a New Presentation |
|
|
6 | (1) |
|
|
7 | (3) |
|
The PowerPoint Window in Outline View |
|
|
10 | (1) |
|
Creating a Presentation in Outline View |
|
|
10 | (2) |
|
Creating a Title Slide in Outline View |
|
|
11 | (1) |
|
Adding a Slide in Outline View |
|
|
12 | (1) |
|
Creating Multi-level Bulleted List Slides in Outline View |
|
|
13 | (5) |
|
Creating Subordinate Slides |
|
|
15 | (1) |
|
Creating a Second Subordinate Slide |
|
|
16 | (1) |
|
Creating a Third Subordinate Slide |
|
|
17 | (1) |
|
Creating a Closing Slide in Outline View |
|
|
18 | (1) |
|
|
19 | (1) |
|
Reviewing a Presentation in Slide Sorter View |
|
|
20 | (2) |
|
|
22 | (2) |
|
Adding Clip Art to a Slide |
|
|
24 | (7) |
|
Inserting Clip Art into an Object Area Placeholder |
|
|
24 | (3) |
|
Inserting Clip Art on Other Slides |
|
|
27 | (3) |
|
Inserting Clip Art on a Slide without a Clip Art Region |
|
|
30 | (1) |
|
|
31 | (1) |
|
Changing the Size of Clip Art |
|
|
32 | (3) |
|
|
35 | (1) |
|
Saving the Presentation Again |
|
|
35 | (1) |
|
Adding a Header and Footer to Outline Pages |
|
|
35 | (2) |
|
Using the Notes and Handouts Sheet to Add Headers and Footers |
|
|
36 | (1) |
|
|
37 | (5) |
|
|
37 | (1) |
|
Adding Slide Transitions to a Slide Show |
|
|
38 | (4) |
|
Applying Animation Effects to Bulleted Slides |
|
|
42 | (4) |
|
Animating Clip Art Objects |
|
|
46 | (1) |
|
Displaying a Slide in Slide View |
|
|
46 | (1) |
|
|
46 | (1) |
|
Formatting and Animating a Title Slide |
|
|
47 | (2) |
|
Saving the Presentation Again |
|
|
49 | (1) |
|
Running an Animated Slide Show |
|
|
49 | (2) |
|
|
51 | (4) |
|
|
51 | (3) |
|
Printing Presentation Slides |
|
|
54 | (1) |
|
E-mailing a Slide Show from within PowerPoint |
|
|
55 | (3) |
|
Saving and Quitting PowerPoint |
|
|
57 | (1) |
|
|
58 | (1) |
|
|
58 | (1) |
|
|
59 | (1) |
|
|
60 | (6) |
|
|
66 | |
WEB FEATURE Creating a Presentation on the Web Using PowerPoint |
|
|
|
1 | (2) |
|
Saving a PowerPoint Presentation as a Web Page |
|
|
3 | (3) |
|
Viewing a Presentation as a Web Page |
|
|
6 | (3) |
|
Editing a Web Page through a Browser |
|
|
9 | (3) |
|
|
12 | (1) |
|
|
12 | (1) |
|
|
13 | |
Microsoft Outlook 2000 |
|
|
Schedule and Contact Management Using Outlook |
|
|
|
|
3 | (3) |
|
What Is Microsoft Outlook 2000? |
|
|
6 | (1) |
|
Tamara Wilson's Dim System |
|
|
6 | (2) |
|
|
8 | (1) |
|
Opening the Calendar Folder |
|
|
8 | (1) |
|
The Calendar -- Microsoft Outlook Window |
|
|
9 | (4) |
|
Creating a Personal Subfolder in the Calendar Folder |
|
|
11 | (2) |
|
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 |
|
|
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 |
|
|
38 | (1) |
|
|
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 | (2) |
|
|
55 | |
Microsoft Integration 2000 |
|
|
Integrating Office 2000 Applications and the World Wide Web |
|
|
|
|
1 | (3) |
|
|
4 | (1) |
|
Integration Project -- Global Computers Web Site |
|
|
5 | (1) |
|
Adding Hyperlinks to a Word Document |
|
|
5 | (8) |
|
Inserting a Table into a Word Document |
|
|
8 | (2) |
|
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 | (1) |
|
Resizing the Scrolling Text |
|
|
22 | (2) |
|
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 |
|
|
27 | (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 | (4) |
|
Adding a Title and Image to a Data Access Page |
|
|
36 | (1) |
|
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 | (4) |
|
|
47 | |
Appendix A Microsoft Office 2000 Help System |
|
1 | (1) |
|
Using the Microsoft Office Help System |
|
|
1 | (1) |
|
|
2 | (3) |
|
Showing and Hiding the Office Assistant |
|
|
3 | (1) |
|
Turning the Office Assistant On and Off |
|
|
3 | (1) |
|
Using the Office Assistant |
|
|
4 | (1) |
|
The Microsoft Word Help Window |
|
|
5 | (4) |
|
|
6 | (1) |
|
Using the Answer Wizard Sheet |
|
|
7 | (1) |
|
|
8 | (1) |
|
What's This? Command and Question Mark Button |
|
|
9 | (1) |
|
|
9 | (1) |
|
|
9 | (1) |
|
Office on the Web Command |
|
|
10 | (1) |
|
|
10 | (1) |
|
|
10 | (1) |
|
Detect and Repair Command |
|
|
10 | (1) |
|
About Microsoft Word Command |
|
|
10 | (1) |
|
|
11 | |
Appendix B Publishing Office Web Pages to a Web Server |
|
1 | (1) |
Appendix C Resetting the Menus and Toolbars |
|
1 | (1) |
Appendix D Microsoft Office User Specialist Certification Program |
|
1 | (1) |
|
Why Should You Get Certified? |
|
|
1 | (1) |
|
|
1 | (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 | (1) |
|
Microsoft Office User Specialist Certification Map |
|
|
3 | |
|
Microsoft Word 2000 Core and Expert Skill Sets and Activities |
|
|
3 | (2) |
|
Microsoft Excel 2000 Core and Expert Skill Sets and Activities |
|
|
5 | (2) |
|
Microsoft Access 2000 Core and Proposed Expert Skill Sets and Activities |
|
|
7 | (2) |
|
Microsoft PowerPoint 2000 Core and Proposed Expert Skill Sets and Activities |
|
|
9 | |
Index |
|
1 | (1) |
Microsoft Office 2000 Quick Reference Summary |
|
1 | |