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 Radio Buttons

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 8. Making the database. Creating Fields. Checkbox

Why a Checkbox?

We should always use computer features to decrease the amount of redundant keyboarding that is necessary. Additionally, having this field will simplify sorting to see who has complied with the directions.

To resume adding fields:

1. Go : Layout .. Define Fields

2. Enter Forms returned in the Field Name.

3. Change the Field type to Checkbox. Click Create.

4. Click Options

5. Set the label as you desire.

6. Default Value - unclick the Initially checked box.

7. Click OK

8. Click Create.

9. Save your database.

I suggest unclicking the box Default Value. This setting requires the data entry person decide if the forms are back or not.

If it were left checked, you could just jump through the record without making a choice.

A good example of an important form would be a media consent release form or a parental consent form. It would critical that the data entry person verified the form was indeed returned.

Perhaps you disagree. Fine. Leave it checked.

More about Checkbox in my Database site

Next - Special field - Number (Radio Bullet, Popup Menu, Value List, Auto Date, Checkbox)

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

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