Please help in designing Tables

[dakboyan]

Hi all,

Excuse me for being new here...but i need some advice on a database im working on. Im currently in a school trying to develop a database that records my students' participation in some arts activities.

What we need is a database that could capture the number of participants that actually went for a particular event (sounds easy rite? - ).

To break it down:

1. The EVENTS are broke up into 3 categories : Exposure, Experience & Excursion.

2. Each EVENT consists of the number of PARTICIPANTS that is divided into Students, Teachers, Parents and Alumni.

3. Lastly, the PARTICIPANTS are further seperated into different interest groups such as Band, Choir, Drama Club etc....

It is quite overwhelming for me as im not that experienced in using Access..so i'll be glad if someone could help to advice me on how i should design the tables and their relationships.

Thank you.
Cheers!

 

[grnzbra]

Try this as a start:
5 tables
1. Event table - info about event including category
2. Participants - info about participants including the info you mentioned
3. Table to join event table and participants (EventID and ParticipantID are included fields for linking) and any info that would apply to that participant at that event.
4. Interest Table - info about various possible interests
5. Table to join Participants and Interrests (ParticipantID and InterrestID are fields included for linking.