CREATING A DATABASE

[Guest]

Is there a good template for making a fire department activities attendance
database?
I have a membership sign in sheet and would like to track how many fires,
drills, meetings, and extra credit assignments they have attended for a query
of all categories individualy and firefighters seaperately.

 

[Jason Lepack]

People
- person_id - Priamry Key
- first_name
- last_name

Event_Types
- event_type_id - Primary Key
- event_type_name

Events
- event_id - Primary Key
- event_type_id - Foreign Key - references Event_Types(event_type_id)
- event_name
- event_date

Attendance - Primary Key = (person_id, event_id)
- person_id - Foreign Key - references People(person_id)
- event_id - Foreign Key - references Events(event_id)

This structure stores the information about the people in the people
table and the event info in the events table. If someone attended the
event then there would be a record in the attendance table.

I would create a form based on the events table. On that form would
be a subform based on Attendance that is linked to the main form on
event_id. On the subform would be a drop down list to choose a
person.

Cheers,
Jason Lepack