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 computers 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:
IBM, Hewlett-Packard, Dell, 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 -
Select the text.
Type the replacement text -
Moving Text (Cut and Paste)
Menu -
Select the text.
Click on EDIT.
Click on CUT.
Click on the location to which you want to place the text.
Click on EDIT.
Click on PASTE.
Tool Buttons -
Select the text.
Click on the Cut Button (Scissors) on the Standard Tool Bar.
Click on the location to which you want to place the text.
Click on the Paste Button (Clipboard).
Right Mouse Button -
Select the text.
Right-Click on the highlighted text.
Click on CUT.
Right-Click on the location to which you want to place the text.
Click on the Paste. Button (Clipboard).
Copying Text (Copy and Paste) -
Menu -
Select the text.
Click on EDIT.
Click on CUT.
Click on the location to which you want to place the text.
Click on EDIT.
Click on PASTE.
Tool Buttons -
Select the text.
Click on the Cut Button (Scissors) on the Standard Tool Bar.
Click on the location to which you want to place the text.
Click on the Paste Button (Clipboard).
Right Mouse Button -
Select the text.
Right-Click on the highlighted text.
Click on CUT.
Right-Click on the location to which you want to place the text.
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:
Your computer dials your ISP (Internet Service Provider) on a regular phone line.
The phone connection is routed to the central phone office nearest your ISP.
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.
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.
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