Computers Level Two
Project 4 (Database)
1. Go to the Apple Menu. Open a ClarisWorks database.
2. From the Define Database Fields dialog box, type in the following
fields in order where it says Field Name:
Number (then hit return or click on Create)
Customer (then hit return or click on Create)
Address (then hit return or click on Create)
Phone Number (then hit return or click on Create)
Fax Number (then hit return or click on Create)
3. From Number go to Field Type and change it from Text to
Number. Hit return or click Modify (it should change to Number).
Do the same for Fax Number and Phone Number then click on
done. (Don't forget to click on Modify or it won't change.)
4. You are now ready to start typing from the list. Pick any 10 names
and address from the sample white pages and pick any 10 business
names and addresses from the sample yellow pages for a total of 20
names and addresses. After typing each entry, hit tab to get to the
next field.
What happened when you typed in the phone number? That mes -
sage you got happened because a dash (-) is not a number. We'll
have to fix that.
5. First, delete the phone number you just entered. Then go to Layout
in the menu bar and stop at Define Fields. That will bring you back
to the Define Fields Dialog box. Change Phone Number and Fax Num-
ber back to text (leave number as a number because that one will
really be only numbers). Don't forget to click on Modify. Click on
done when you are done to continue typing.
6. Now finish typing in the Names and Addresses. Use the Tab
key to get from one field to the next. To start a new record
go to Edit, then New Record or type Open-Apple and R.
7. Save your work in your file folder every few minutes so that you
don't lose any of it, call it Contacts. Now let's fix the layout of
the records. Goto Layout in the Menu bar and then go to Lay-
out. Here is where you can change the overall appearance of
your record. Extend the bottom line a little bit beyond the bot-
tom field.
Clicking on any field allows you to change its size.
8. Let's see what your list looks like. Go to Layout, List. This is
one way of viewing your records.
9. Go to Layout, Find. Type in the name of one of the people you
typed then click on Find in the lower left hand of your document
screen. Find is helpful when you have hundreds of records and
you need to find some specific ones.
10. Go to Organize, Show All Records. Use the bookmark on the
notebook found at the top right hand corner of your document
screen.
Now let's do what databases do best, Sort. Go to Organize,
then Sort Records. You should see the Sort Records dialog
box. Let's say that for today you want to your records by the
Customer's name:
Click once on Customer, then click once on Move.
Leave the Ascending order button pushed then click on Ok, no-
tice that on your right it says that the records have been sorted.
They are now in Alphabetical order according to the Customer's
or Business' name. You can always come back later and resort
according to their number. That way you can see your customer
list in order that you typed them in, numerically (in the real world
hat might mean the order in which they became your
customers).
11. Show Mr. González your list, sorted.