Here is how you can create an AppleWorks/ClarisWorks
Database where you can total numerical data. Follow these steps:
1. Start the AppleWorks/ClarisWorks application. Or, if you're
already using AppleWorks/ClarisWorks, go to the File menu
and pull down to New, to create a new document.
2. Choose Database, click OK.
3. The first thing you will see is the Define Fields dialog
box.
4. In the Define Fields dialog box, type the names of these
fields in your database (DB).
Type these names to use as practice fields:
Trip (Click Text below, then Create)
Miles Traveled (Click Number below, then Create)
Total Miles (Click Summary below, then Create)
After you click Create for the Total Miles field, another
dialog box will open.
5. In the Enter Formulas dialog box, do the following:
a. Scroll down in the function box to SUM, then highlight
it. The word SUM appears in the formula box below
b. Then, on the left, click on the name of the field that you
want to total. In this case, Miles Traveled.
c. Miles Traveled will replace the "number 1"
in parenthesis with the field name you chose. (It will not eliminate
the number 2. You must do that by selecting "number 2"
and deleting it.)
d. Your formula should read this way:
SUM('Miles Traveled')
Make sure it has the parenthesis and the single quote marks on
each side. If it doesn't, make the necessary changes by typing
them. Then click OK.
e. Now you're back in the Define Fields dialog box. Click, Done.
6. You'll now see two field titles and their data boxes. Go to
Layout, then pull down to Layout.
7. You now see the Body part labeled. Now you need to insert
two more parts. One for the titles and one to total the numerical
data.
a. Go to Layout, Insert Part. Choose Header,
then click OK.
b. Go to Layout, Insert Part again. Choose Trailing
grand summary.
"Trailing" means that it will appear at the end of the
database. If you had chosen "Leading grand summary,"
the totals would appear at the top of the document.
c. Then click OK, and you'll be back in the layout. You
now have three labeled parts.
d. Go to Layout, Insert Field, and you'll see the
field named, Total Miles. Click on it, then click OK.
e. You'll be back in the layout again. Drag the titles Trip
and Miles Traveled (in bold type) up into the Header
Part. Drag a handle on the right side to allow the whole title
"Miles Traveled" to be shown.
f. Next, resize and drag the field boxes themselves (for Trip
and Miles Traveled) underneath the titles. Make sure the
boxes stay in the Body part.
g. Drag the title Total Miles and the field box for "Total
Miles" into the Grand Summary section of the layout.
Move and resize them directly below the Miles Traveled column,
so that the totals will appear underneath the column of numbers
that will result after many records have been entered.
h. Go to Layout and pull down to Browse.
8. Now you can enter your data. After you've entered the complete
records below, you'll see how the totaling works. Click beneath
the title Trip to make the insertion point blink in the
Trip field. Click approximately where you see the arrow in the
diagram below. You may need to click around a bit until you see
a flashing insertion point in a blank data field box.
To enter data, click in each field, then type. To move from one
field to another quickly, press the tab key. To begin entering
a new record, you can go to the Edit menu, and then pull
down to New Record, or use the keyboard shortcut, command-R.
When you've entered these records, go to the next step.
Type these records (each line is a separate record):
Trip Miles Traveled
Bakersfield 275
Fresno 458
Canyon Country 46
9. To see the totals at the bottom of your
database, go to the View menu, then pull down to Page
View. The words Total Miles and the resulting numerical
total appear at the bottom.
10. To add more records, just go to Edit, then pull down
to New Record. Enter some more practice records. In Page
View, the Total Miles will change each time you click or tab to
the next field.
11. To tighten up the appearance of your database, go to Layout,
Layout. Click on the label Body, and drag upward.
You can also add a horizontal line below the Body fields with
the line tool. Hold down the shift key when you draw it, to ensure
that the line is straight.
More info:
To delete a record, click on the records line (anywhere but in
a field itself), and the entire record will be selected (the selected
record will apear as a thick black bar). Go to Edit, Cut
to delete it (the delete key will not work here).
To change the Font, Size, Style or Text Color for the entire document,
make the changes in Layout by clicking on a title or field box
and make change(s) in the Format menu. To change the appearance
of only a single data entry, make the changes in Browse.
To scroll through a list of records, you can use the standard
up & down scroll arrows on the right side of the Macintosh
window, or you can click on the pages of the booklet in the upper
left, or drag the bookmark up and down.
Use the Organize menu to Sort Records. In the dialog
box, click the name(s) of the field(s) you want to sort by, then
click the >>Move>> button. The field name(s)
will appear on the Sort Order side. Then click OK.
The records are sorted according to your instructions.
Now try to create your own database with your own data. Try to
create one that will help you keep track of student information,
a professional group you work with. Follow the same steps, with
different field names and numerical data. Save it when you're
done. Open it and update it each time there is a change. Make
sure you save it each time you make changes to it.