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.