Meet the PC

Course Objectives

You will be able to:
1. Understand computer terminology.
2. State some important things to consider when purchasing, upgrading, or repairing a computer.
3. Use Windows to start programs, and work with disks and files.
4. Write and edit a document using Word.
5. Construct a spreadsheet using Excel.
6. Identify a form, query, and report in Access.
7. Use the Internet to visit various locations and perform a search.

Course Outline

Class 1 - The Basic Computer - Read p. 1-97.
            Parts, terms, and specifications - Visit Dave's Guide, and
            Computer Buying: Four Steps to Making the Right Choice.
            Introduction to Windows 95/98.

Class 2 - Windows 95 - Read p. 136-7, 144-7
            Word processing with Word - Read p. 112-19.

Class 3 - Editing with Word. Do the Starting Word 97 as a Beginner tutorial.
            Working with spreadsheets using Excel - Read p. 120-7. Do the Beginning Excel Tutorial.

Class 4- Becoming familiar with Access - Read p. 128-31. 
            An introduction to surfing the net - Read p. 178-215.



Text: Maran, R. and Feistmantl, Ed. Computers Simplified (Fourth Edition), Mississaugua, Canada, marangraphics, 1997. $24.99. (The marangraphics series is distributed in the US by IDG.)

Don't know what a word means? Look it up at whatis?com.


Parts of the Computer

Input Devices
Keyboard - The keyboard is used to send text and commands to the computer for processing. Better quality keyboards tend to be heavier and have a better "feel" than those of lower quality. If you purchase an inexpensive   computer that someone "made" for you, chances are that an inexpensive keyboard was used rather than a quality keyboard.

Mouse - The mouse is used to select objects, move around in a program, or perform actions. When you hold a mouse, grasp it firmly, place the index finger of your right hand over the left mouse button or, if you are left-handed, your right index finger of your left hand over the right mouse button. That will be your primary mouse button. As you move the mouse away from you, a pointer or arrow on the screen will move will move up. As you move the mouse toward you, the pointer will move down. As you move the mouse to the left, the pointer moves left. As you move the mouse to the right, the pointer moves right. Move the mouse perpendicular or parallel to the edge of the table.

There are four basic mouse commands. The first is a single CLICK. When you click, hold the mouse steady and press the primary mouse button one time. To DOUBLE CLICK, press the primary button twice rapidly. Be careful not to move the mouse while you are clicking. The third command is called CLICK and DRAG or DRAG SELECT. To click and drag, move the pointer to the beginning of the text which you want to select, press the primary mouse button and hold it down while you move the mouse. The text will become marked or highlighted. The fourth command is the RIGHT CLICK (or Left Click if you are left-handed). To perform this action, just press the other or secondary mouse button.

A mouse may have two or three buttons. Many programs do not support the middle button. Sometimes the middle button can be programmed to perform special tasks. A mouse may be connected to the computer’s serial port, or directly to the main circuit board, the bus. When you buy a mouse, make sure that you get the type that you need. Bring your old mouse to the store so you can match the connector on the mouse cable.

For more information on the mouse commands, see the section on Mouse Commands.

Central Processing Unit (CPU)
The CPU is a special chip that is the brain or boss of the computer. It controls what instruction will be performed next, where data will be placed in memory, and performs all the arithmetic functions of the computer (addition, subtraction. and comparison). The CPU is referred to by its number. The higher the number - consider the Pentium to be an 80586 - the more powerful and the more expensive the computer is. Current CPUs are Pentiums, manufactured by Intel, or a similar chips made by Advanced Micro Devices or Cyrix under license from Intel.

The chips with the higher numbers are more powerful can transport more data at a given time. The 8088 is an 8 bit chip. The 80286 Is a 16 bit chip. The 80386DX and both 80486 chips are 32 bit chips. The Pentium is a 64 bit chip.

The second indicator of the power and speed of the chip is its "clock speed". This is a number expressed in MHz (megahertz or millions of cycles per second) or GHz (gigahertz or billions of cycles per second). The faster the speed, the faster the CPU will complete its processing. To run current applications, your computer should have a minimum speed of 66 MHz or more for the most basic uses. A good CPU for most people and businesses would be a mid-range (1 GHz) Pentium. Pentium MMX CPUs have an enhanced instruction set to make better use of multimedia software and hardware. The MMX means MultiMedia EXtended instruction set. Pentium  P4 CPUs are high-end business/workstation machines which run at speeds of up to 2 GHz. The $800 computers typically use CPUs made by AMD or Cyrix rather than Intel.

Main Memory (Random Access Memory)
Main memory or RAM is used for short-term storage of your program and work. As a rule, the more memory the computer has, the better. This is especially true if you use Windows' programs. Many DOS programs cannot access or use more than 640 KB (Kilobytes). Windows programs require a lot of RAM. Windows uses all the available RAM in an efficient manner.

RAM is measured in megabytes or MB. A megabyte of RAM can hold approximately one million characters or letters. Office XP needs 128, or better yet, 196 MB of RAM. People who work with CAD (computer aided design), graphics, or large databases will require even more memory. Additional RAM is inexpensive and is easily added. If your needs change or you use a number of different programs at the same time, you should consider adding additional RAM.

Auxiliary Storage Devices
Auxiliary Storage Devices include hard and floppy disk drives, CD ROMs, and Tape Backup Units.

There are two types of disk drives: floppy disk drives and hard disk drives. Your computer will have one or more floppy drives and usually one hard drive There are two sizes of floppy disk drives. These are 5.25" and the 3.5" drives. These come in different capacities. The more common type of drive is a 3.5", 1.44 MB drive. The second type of disk drive is the hard or fixed disk. Hard disks retrieve data about 10 times faster than a floppy disk and have a greater capacity. A typical hard disk will store between at least 16 GB of data. Today's programs are more powerful than ever before and continue to grow larger and larger. It is far less expensive to purchase a hard drive which is larger than you ever expect to use than it is to replace the existing drive or add a second hard disk. Purchase the largest, fastest hard drive that you can afford. The smallest that you should purchase for average use is about a 16 GB hard drive. A 20 GB hard drive or larger is better. 

CD-ROM (Compact Disk Read Only Memory) units allow your computer to access large amounts of data stored on CDs. Some of the disks may have an encyclopedia, world atlas, business data, or a desktop publishing program with large numbers of fonts. Newer programs also come on a CD-ROM which make installing the program much easier. Get the fastest CD-ROM available - look for at least an 12X speed CD-ROM. The fastest common CD-ROMs now operate at 40X. This means that they spin 40 times faster than the original audio CD ROMs.

A Tape Backup Unit allows users to make a complete backup of their hard disk easily and quickly. This is especially important for businesses. It could prove useful for home users, but is not as necessary. Tape backup units cost about $200.

If you share floppy disks (even bringing work home from the office counts), use shareware or public domain software, or download software from the Internet, you may infect your computer with a virus. A VIRUS is a very small program written by electronic vandals with the soul purpose of annoying you or destroying the contents of your hard disk. Viruses most commonly are transmitted on programs (executable or command file types) or document files as destructive macros. Unless you never install non-commercial software, floppies that have been in another computer,, or download files from the Internet, you need virus protection software. This will detect, prevent infection, and eliminate the virus, and repair damage to your disk. Two highly-rated antivirus software products are Norton AntiVirus, and McAfee Total Virus Defense.  To learn more about viruses, go to HowStuffWorks.


Output Devices (Monitors and Printers)
Output devices allow you to see the work that the computer is doing or has done. The two most Important types of output devices are monitors and printers

Monitors
Monitors may either be single color (monochrome - frequently used for network file servers) or multi-color (what you will use). The most common monitors today are VGA (Video Graphics Array) or SVGA (Super VGA)- Either type gives good resolution and colors for common text-based work. If you will be working with graphics at all you should d get an SVGA monitor A better quality monitor is non-interlaced, and has a dot pitch (the distance between dots of the same color on the screen) of about .28 millimeters. The most common size for a monitor is 14". A 15" or larger monitor is better - easier on your eyes - for extended use. A 15” ,or better yet a 17”, monitor is recommended for most users. Users who work with desktop publishing, CAD, or graphics applications should consider a 19" or larger monitor.

Printers
There are two different types of printers: impact printers and non-impact printers Choose an Impact printer if you are going to print multi-part forms, if cost is a factor, and noise and true letter quality are not factors. Impact printers are typically dot-matrix printers.

There are two types of non-impact printers. The first is a laser printer. Laser printers are expensive, fast, quiet, and give and fine quality printed document. Ink jet printers are slower, but print almost as well and frequently have color capabilities. Laser printers print from 4 to 12 Pages Per Minute (PPM). Inkjet printers print about 4 PPM in black, but slow to between 1 to 2 PPM if you are printing in color. The best quality ink jet printers will print up to 9 pages per minute in black and produce near photographic quality color printing.

Hewlett-Packard printers have proven to be consistently high quality and very reliable. HP is my first choice for a printer.

Buying Guide

A good minimum system for an average user would consist of a 1 GHz Pentium, 128 MB RAM, a 16 GB hard disk, a 56K modem, a 17" monitor, and an ink jet printer. This is a system that you won't be dissatisfied within a week or two. It would provide very good performance at a reasonable price. The exact system that you need would depend on your particular needs. You could certainly perform basic tasks with a less expensive system, but if you are working with graphics, CAD (Computer Aided Design), or desktop publishing, you would need a much more powerful system. Don't get an underpowered system. It will not function well enough to meet your current, let alone your future needs.

Based on my experience, reports in magazines, and rumor and hearsay, I recommend the following brands for quality, reliability, and value:

  IBMHewlett-PackardDell, and  Gateway.

Visit Dave's Guide to purchasing a computer. You may find it helpful and it is updated periodically.


 
Mouse Commands

The mouse is a type of input device. You can use the mouse to move the pointer, select from a menu, highlight a block of text, or move an object.

POINT - Move the mouse so that the arrow pointer is on the desired menu command name, graphic item, or place the I-beam where you want the insertion point.

CLICK - Quickly press the left button of the mouse one time. Clicking is used to reposition the insertion point in text, select a menu, or select an option from a dialog box.

DOUBLE-CLICK - Rapidly press the left button twice. DOUBLE CLICKing on an icon or file name opens an application or window related to that icon

RIGHT-CLICK
- Click the right button instead of the left button. (If you are left-handed, you will left-click instead.) This displays a context sensitive menu.

CLICK and DRAG - Keep the left mouse button depressed. Move the pointer to the new position and release. This command is used to move text, files, etc. and may be used in conjunction with other keys.

SHIFT+CLICK - Press and hold the SHIFT key as you press the left mouse button. SHIFT+CLICKing selects multiple adjoining file names in the file manager or text between the current insertion point and the place where you press SHIFT+CLICK.

CONTROL+CLICK - Press and hold the CONTROL key as you press the left mouse button. CONTROL+CLICKing selects multiple file names in the file manager. The files do not have to be adjoining.

Click here to return to the MOUSE section.


Common Tasks for Windows 95 Users


Starting a Program - Double click on the icon or click on Start, Programs, the Group (if there is one), and the Program name.

Closing a Window or Program - Click on the Close Icon (the X) in the upper right corner of the window on the Title Bar.

Sizing a Window -
Minimize - Click on the Minimize Icon (the underscore symbol), the first button in the upper right corner of the window on the Title Bar.
Restore - Click on the Restore Icon (the two boxes) in the upper right corner of the window or click on the program name on the Title Bar.
Maximize - Click on the Maximize Icon (the single full box) in the upper right corner of the window on the Title Bar.
Size - Move the pointer to the gray border where it will change to a double-headed arrow pointer. Click and drag on the border - top, bottom, side, or slightly above or below any corner.

Moving a Window - Click and drag on the Title Bar of a restored window. You cannot move a minimized or maximized window.

Showing, Hiding, and Changing the Taskbar - Click on Start, Settings, Taskbar, Taskbar
Options, select the desired options, click on OK

Shutting Down the Computer - Click on Start, Shut Down, Yes.

Getting Help -
Windows 95 Help - Click on Start, Help, select the topic from the display or index or Find, click Display.

Program Help - Click on Help, the Office Assistant button, press ALT H, or press F1. Select Contents or Index or Find and click Display.

Adding a Start Menu Item -
  1. Right Click on the Task Bar-
  2. Click on Properties.
  3. Click on Start Menu Programs.
  4. Select Add.
  5. Click on Browse to find the program.
  6. Click on the folder.
  7. Click on Open.
  8. Click on the file.
  9. Click on Open.
10. Click on Next two times
11. Click on Finish.


Moving an Icon
1. Move the pointer to an icon.
2. Click and drag the icon to its new position.
3. When you are satisfied with its position, release the mouse button.


Changing the Active Window
1. Move the pointer to any part of the window that you wish to make active.
2. Click on that window.

Copying a Document
Starting the first window
1. Start a program such as WordPad. Type a document.
2. Copy the document. (CTRL - A, Edit-Copy or select the desired text or graphic then give the copy command - Right-Click Copy)
3. Size the document window so that it fits in the left half of the screen

Starting the second window

4. Open a second WordPad file or new document in another program.
5. Size the window so that it fits in the right half of the screen.
6. Paste the text into the second document. (Right-Click Paste)
7. Click on the title bar to make the window active.


Cutting and Pasting Text between Two Windows

1. Mark text in a document in the active window by clicking and dragging.
2. Right-Click CUT.
3. Make the second document active by clicking on it.
4. Move the I beam to the place where you want to insert the text.
5. Right-Click PASTE.


Installing Software

1. Insert the first disk into drive A-: or the CD-ROM.
2. Click on My Computer.
3. Double-click Add/Remove Programs.
4. Select Install.
5. Follow the directions on the screen.


Note that many CDs will start automatically so you can just follow the directions on the screen to install your software. This is normally a very straight-forward task.


Working with Disks and Files

To Format a Disk -
1. Place a disk in drive A:.
2. Double Click on My Computer.
3. Right-Click on 3 1/2 Floppy A:.
4. Click FORMAT.
5. Click on FULL.
6. Click on Start.
7. Click on Close.
8. Click on Close.


To Delete Files -
1. Right Click Start.
2. Click on Explorer.
3. Click on the Folder on the left side of the window.
4. Click on the File on the right side of the window. (NOTE: Make sure that you don't double-click.)
5. Press the Delete key.
6. Click on Yes.


To Copy Files -
1. Right Click Start.
2. Click on Explorer.
3. Click on the Directory on the left side of the window.
4. Right Click on the File that you want to copy on the right side of the window.
5. Select Copy.
6. Right Click on the destination directory on the left side of window. Select Paste.


Parts of the Word Screen


Titlebar -

Sizing Icons -
Minimize -
Maximize -
Restore -

Menu bar -

Toolbars -
Standard -
Formatting Toolbar -

Ruler -

Scroll bars -

Status line -


Working with Files


Naming files

Filename - The filename can be between 1 to 250 characters long. Use letters, numbers, and spaces. Do not use punctuation marks. There are some punctuation marks that you can use and others that you can't. If you don't use them, you won't have to worry about which are which. Name your file so that the name will remind you of the file's contents.

Extension - After the filename, there is a dot or period followed by a three character extension name. This is added automatically by the program. You don't have to worry about adding it and shouldn't. The extension tells the type of file and the program with which it is associated. Here are some common extensions for Microsoft Office programs.

DOC - Word document files
DOT - Word document template files
XLS - Excel spreadsheet files
MDB - Access database files
PPT - PowerPoint presentation files

Folders - are used to organize your hard disk. You can create folders so you can better organize your work. Folders can either hold files or other folders.

Changing Folders

Creating Folders

Drives
A:
C:

Changing drives -

File Menu selections -
SAVE -

SAVE AS -

NEW -

OPEN -

CLOSE -


Moving around a Document


Mouse -

Menu -

EDIT GOTO -


Single keys
Arrow keys -

Home -

End -

Page Up -

Page Down -

Control key combinations
CTRL Left or CTRL Right Arrow keys

CTRL-Home- -

CTRL End -

Selecting Text with the Mouse
Click and drag -

Double click -

Using the Text Selection Area
Click -

Double click -

Click and drag -

Control click -

Selecting Text with the Keyboard
Shift - Left or Right Arrow keys -

Shift -Home -

Shift -End -

Shift-Page Up -

Shift-Page Down -

CTRL-SHIFT-HOME-

CTRL-SHIFT END -

CTRL A -


Editing a Document

Insert/Overstrike modes -
Office 97 - Double-Click on the small OVR button located in the lower-right corner of the window.
Older versions of Office - Press the INSERT key to toggle between the insert and overstrike modes.

Deleting text
BACKSPACE-

DELETE-

CTRL-BACKSPACE -

CTRL-DELETE -

Replacing text
Switching to the Overstrike mode -

  1. Select the text.

  2. Type the replacement text -

Moving Text (Cut and Paste)
Menu -

  1. Select the text.

  2. Click on EDIT.

  3. Click on CUT.

  4. Click on the location to which you want to place the text.

  5. Click on EDIT.

  6. Click on PASTE.

Tool Buttons -

  1. Select the text.

  2. Click on the Cut Button (Scissors) on the Standard Tool Bar.

  3. Click on the location to which you want to place the text.

  4. Click on the Paste Button (Clipboard).

Right Mouse Button -

  1. Select the text.

  2. Right-Click on the highlighted text.

  3. Click on CUT.

  4. Right-Click on the location to which you want to place the text.

  5. Click on the Paste. Button (Clipboard).



Copying Text (Copy and Paste) -
Menu -

  1. Select the text.

  2. Click on EDIT.

  3. Click on CUT.

  4. Click on the location to which you want to place the text.

  5. Click on EDIT.

  6. Click on PASTE.

Tool Buttons -

  1. Select the text.

  2. Click on the Cut Button (Scissors) on the Standard Tool Bar.

  3. Click on the location to which you want to place the text.

  4. Click on the Paste Button (Clipboard).

Right Mouse Button -

  1. Select the text.

  2. Right-Click on the highlighted text.

  3. Click on CUT.

  4. Right-Click on the location to which you want to place the text.

  5. Click on the Paste. Button (Clipboard).


Changing the Appearance of Your Document

Font -

Style -

Size -

Menu -

Format Fonts -

Right Mouse button -

Formatting Tool bar -

CTRL key combinations
CTRL B -
CTRL I -
CTRL U -

For other CTRL key combinations look in the Word class.


Spreadsheet Basics


Text or Labels - Words or numbers which will not be used for calculation (i.e. Social Security numbers, Zip Codes, telephone numbers, etc.).

Numbers or Values - Numbers must start with a numeral, no more than one decimal point, a + or - sign, a $ sign, or enclosed within parentheses Numbers may end with a % sign (this tells Excel to divide the number by 100) Numbers may also be entered using scientific notation.

Formulas - Formulas are entered in the cell in which the result is to appear. Formulas start with an equal sign (=). Do not end a formula with an equal sign. Formulas may start with the following characters: 0 1 2 3 4 5 6 7 8 9 + -. ( @ # $

This is done so that Excel will recognize that the cell contains a formula rather than a label. Formulas can contain special built-in formulas, like for Tangent or Net Present Value, which are called functions. Functions always begin with the "=" symbol. Special functions are available for mathematics, strings (words), logic operations (true/false conditions), and even the date and time,

Formatting - Even though you can not see it, cells also contain formatting. The default formatting setting for a cell is general which means that there is no specific formatting assigned.


Designing and Developing a Spreadsheet


1. Sketch out the spreadsheet. It is not necessary that everything is planned perfectly, but you need to know what data you have, and what you want to do with it.

2. Enter the labels into the spreadsheet.

3. Enter the formulas into the spreadsheet. Check for accuracy.

4. Enter the values into the spreadsheet. Do the calculated answers make sense? Check for mistakes or erroneous assumptions.

5. Format the spreadsheet so that it looks good and can be easily understood by others. Formatting should be done after you enter the values because you can sometimes see mistakes that might otherwise go unnoticed.

6. Add titles, references, statement of purpose, etc.


Annual Interest Spreadsheet

In this cell              Enter


B2                          Compute Annual Interest
B4                          Rate
C4                          5.5%
B6                          Year
C6                          Balance
D6                          Interest
B7                          1997
C7                          5000
D7                          =C7*C4
B8                          1998
C8                          =C7+D7
D8                          =C8*C4
B9                          1999
C9                          =C8+D8
D9                          =C9*C4
B11                         Totals
C11                        =C9+D9
D11                        =D7+D8+D9

Format the spreadsheet. Click and drag from C7 to D11. Click on the $ on the Standard Tool Button. Next adjust the column width of column C. Move the pointer to the vertical line between columns C and D. You will see a double-headed horizontal pointer appear. Double-click. This will automatically adjust the column width.


The Football Spreadsheet

You are responsible for income made at school football  games, Your goal is to take in $1200 at each game. Prior to each season you must estimate attendance for both   students and adults and set ticket prices.Your income from ticket sales is supplemented by food sales at  the concession stand. You've found from experience that  on the  average, each adult spends $1.25 and each student spends $1.75 on   food.

Set up your spreadsheet labels as shown.

          A            B            C          D          E        
  ----------------------------------------------------
1|Adult  Price            |               |              |    
  ----------------------------------------------------
2|              |                  |               |              |    
  ----------------------------------------------------
3|Student Price        |               |               |    
  ----------------------------------------------------
4|               |                |              |                |    
  ----------------------------------------------------
5|Expected Adults    |              |                |    
  ----------------------------------------------------
6|               |                |               |               |    
  ----------------------------------------------------
7|Expected Students               |               |     
  ----------------------------------------------------
8|               |               |                |               |    
  ----------------------------------------------------
9|               |               |                |               |    
  ----------------------------------------------------
10|Ticket Sales Income         |                |    
  ----------------------------------------------------
11|            |                 |             |                |    
  ----------------------------------------------------
12|Food Stand Income         |               |    
  ----------------------------------------------------
13|            |                 |             |------------|     
  ----------------------------------------------------
14|             |Total Income         |              |     
  ----------------------------------------------------
15|            |                 |             |               |    
  ----------------------------------------------------

Note: All formulas and amounts should be in column D.

Format the appropriate cells for currency.

Optional: Redesign the spreadsheet so that you can change the amount that is spent on food.


Price Forecasting Spreadsheet


You run a computer manufacturing company. You are trying to forecast  the retail price of your basic computer system for the next four years.  Construct a spreadsheet that computes the system price for projected  price changes. Electronic parts will decrease, while labor, facilities, and  advertising will increase.

Set up your spreadsheet as shown. Enter the formulas, and then  the values. finally, format your spreadsheet. Use the AutoSum for the Projected Price.

      A                B               C            D           E             F
  ----------------------------------------------------------------------
1|ITEM     |Change   | 1997     |  1998    | 1999    | 2000
  ----------------------------------------------------------------------
2|Monitor  |     -3%    |       100 |                |            |
  ----------------------------------------------------------------------
3|Sys.Un.  |    - 7%   |      195   |               |             |
  ----------------------------------------------------------------------
4|Keyboard|     -5%  |      45     |              |              |
  ----------------------------------------------------------------------
5|Labor      |    30%   |       50    |              |             |
  ----------------------------------------------------------------------
6|Facilties  |     10%  |      30     |              |             |
  ----------------------------------------------------------------------
7|Advert.    |      50% |       25     |              |             |
  ----------------------------------------------------------------------
8|               |               |========|=======|=====|===  
------------------------------------------------------------------------
9|Projected Price      |               |              |              |
  ----------------------------------------------------------------------


1. Type the labels.
2. Use the BORDER tool for cells C8:F8. Either Top or Bottom.
3. Type the formulas in D2, E2, and F2.
4. Copy the formulas from D2..F2 to D3..F7.
5. Type the formula in D9.
6. Copy the formula from D9 to E9..F9.
7. Enter the values.
8. Change the column width if necessary.
9. Format the spreadsheet for zero decimal places in columns C  through F.

Optional Assignment: Redesign the spreadsheet so that you can compare your expected income with the expected expenses.


Hotel Customers Spreadsheet

As a manager of a hotel, you want to develop a graphical profile of your hotel's customers for a year. First, you must enter the data into a spreadsheet.

Month General Business Convention
Jan. 225 309 88
Feb. 747 303 471
Mar. 578 521 211
Apr. 370 222 287
May. 519 546 837
Jun. 382 815 354
Jul. 684 228 524
Aug. 520 537 85
Sep. 700 660 921
Oct. 431 439 414
Nov. 1260 717 743
Dec. 673 991 712

.                                   
.                                     
.                                  
.                                  

Add a row and column of data to your spreadsheet for totals.

Use the Chart Wizard to create a chart.

Select the best type of graph to show the following:
1. A comparison of the percentage of each type of customer for the entire year.
2.The trend of the numbers of each type of customer.
3. A comparison of the number of each type of customer for each month.
4. A comparison of the total number of customers for each month.


Access

Tables



Forms



Queries



Reports


Macros


Modules


Visit the Database Case next for a fun overview of Access.


The Customer Database


1. Create a new database called CUSTOMER. Click on File, New.

2. Create a new Table called NAMES.

Click on the Table tab, New, Design View. Enter the Field names and the Field Properties.

Fields Name     Data Type     Field Size
FIRST NAME    Text                    15
SURNAME        Text                    15
STREET            Text                    15
CITY                   Text                    20
STATE               Text                      2
ZIPCODE          Text                      5

Close the table.

Select Yes to Save the Table.
Save the table as NAME.
Select Yes to have Access create a Primary Key.

3. Create a Form and enter the data.
Click on the Form tab.
Click on New.
Select Auto Form- Columnar.
Click on the list box arrow and select NAME as the table.
Click on OK

4. Enter the following data.

FIRST NAME

SURNAME

STREET

CITY

STATE

ZIPCODE

Samuel

Green

7 Boardwalk

Philadelphia

PA

19123

Brent

Wilcox

88 Penns Way

Los Angeles

CA

90155

John

Goodbar

57 S. Forest Rd.

Madison

WI

53722

Ivan

Bronsky

16 Green St.

Reno

NV

89513

Ever

Sharp

490 Center St.

Chicago

IL

60606

Marlow

Crowbar

39 Henry St.

Boston

MA

02137

Efron

Baker

123 Mann Dr.

St. Louis

MO

63129

Barney

Goggle

234 Apple Dr.

Topeka

KS

66615

Richard

Tracy

18 Meadow Ave.

Miami

FL

33123



After entering the data in a table, complete the following.

Find Baker

Click on the Find tool (It looks like a pair of binoculars).

Change Green and Goggle's addresses to Boston, MA, 02137.

Find the record.

Modify the data.

Press ENTER or TAB.

Delete Crowbar.

Find the record.

Click on Edit on the Menu Bar.

Click on Delete.

Sort by surname in descending order.

Click on the SURNAME field.

Click on Records, click on Sort, click on Descending.

Create a report showing Surname, City, and State. Display your report on the screen.

1. Click on the Report tab.

2. Click on New.

3. Click on Report Wizard.

4. Enter NAME for the selected table.

5. Click on OK

6. Click on SURNAME then > to select and move SURNAME field to the right.

7. Click on CITY > to select and move CITY field to the right.

8. Click on STATE > to select and move STATE field to the right,

9. Click on Next.

10. Select Surname from the list box. Sort in Descending (Z-A) order.

11. Click on Next.

12. Click on the Vertical option button.

13. Click on Next.

14. Select a style - your choice.

15. Click on Next.

16. Name the report Surname Report.

17. Click on Finish.


Add



Lily Gilded 578 Rodeo Dr. Boise (D 83752
Grayfold Cretin 1980 University Ave. Madison WI 53722

Use the Report Wizard to create a Report that will print mailing labels.


The Internet

Getting on the Net

You need:

Computer

Modem

Software

Internet Service Provider


What happens when you connect:

  1. Your computer dials your ISP (Internet Service Provider) on a regular phone line.

  2. The phone connection is routed to the central phone office nearest your ISP.

  3. The ISP receives your incoming call and processes your request to log on. I gets and verifies your user name and password. The ISP has banks of modems to process many simultaneous requests.

  4. Computers with dedicated links to the Internet backbone are always on. These machines have a permanent IP (Internet Protocol) address (i.e. 155.40.200.45. Note: we use a URL - Universal Resource Locator name such as http://www.microsoft.com rather than the IP address.). This address allows other machines to find it. When you connect to the Internet backbone, your computer is assigned a temporary IP address.

  5. The host runs special web server software that reads and processes your requests and sends the appropriate information back to your computer. It is connected to the backbone by a very fast telephone line called a T1 or T3 connection.


What can you do on the Net?

World Wide Web
Information

Commerce


newsgroups


email


software


college classes


meeting people

 

Read the Tutorial for Internet Beginners.


Some Neat Web Sites

This day in rock and roll history - http://www.arrowfm.com/cgi/history.pl

Travel by Microsoft - http://www.expedia.com

Jobs - http://www.careerpath.com
            http://www.monster.com

Visit Paris - http://www.paris.org

The White House - http://www.whitehouse.gov

Bartlett's familiar quotations - http://www.cc.columbia.edu/acis/bartleby/bartlett

Dilbert - http://www.unitedmedia.com/comics/dilbert

Disney - http://www.disney.com

Sports - http://www.espn.com

News, weather, and more - http://www.snap.com

Local television stations - http://www.wfsb.com
                                             http://www.wvit.com

Books - http://www.amazon.com
              http://www.barnes&noble.com

PC Magazines 100 Best Websites - http://www.zdnet.com/products/stories/reviews/0,4161,2394453,00.html

People search - http://www.yahoo.com/search/people

Home

Classes