computer icon MYOD - Make Your Own Database - a tutorial
by Cindy O'Hora

Planning

Begin

Define Fields

Radio buttons

Pop-up Menu

Date

Value List

Checkbox

Number

Summary

Grand Summary

Sort & Page view

Data Entry

Harnessing

Loverly Layout

New View

Find

Find by date

Calculating RadioButtons

Fields: Name, address, phone, grade, gender, school, teacher/advisor, project name, category. Other data: Entry date, fee paid, paper work received, ranking or award.

Step 11. Making the database. Summary Fields

It can be disconcerting to successfully create a summary field, but then it appears to be missing when you drop back to your database. Have no fear. It is there. Let's make it visible.

1. Go : Layout .. Layout

2. Go Layout .. Insert Part

3. A window opens that has multiple options.

4. Select Trailing Grand Summary. Click OK.

5. You will return to the layout view of your database. At the bottom of the layout, you'll see a new bar added. It is labeled Grand Summary.

6. Go Layout .. Insert Field

7. A window will open showing those fields that can be inserted. Select Total Fees.

8. Drag the Total Fees label and the box for Total Fees into the area between the Body bar and the Grand Summary bar.

9. Save your database.

10. Go Layout .. Browse to return to the Browse view of the database.

Next - Sorting and Page view bring the summary to life.

BACK / NEXT

Database Internet Hunt

Harnessing Databases

Harnessing online databases 2

Database Activity - vocabulary

Database - organizing AppleWorks database tips

 

Internet Hunts / Nature / Computers / Puzzles & Projects / Site map / Home / Search

All trademarks, copyright and logos belong to their respective owners.

Copyright 3/2004 Cynthia O'Hora All Rights Reserved. Posted 3/2004 by Cindy O'Hora