Event Database

[Rob]

Hello

I do have some very slight knowledge of Access and have recently purchased
MS Office Pro 2010 which includes Access.

I want to set up a database to record and report on specific Events as they
occur. Involved in each event there will be Seniors (managing) and Juniors
(participating).

Events can happen on a daily basis and there are a total of approx. 500
Seniors and 1060 Juniors

In order to manage an event, all Seniors need to be annually trained and
within date, ie, they must have been trained within the last 12 months.
This needs to be managed from within the database so I need to record the
date trained and when due for the next training session.

Whenever an event takes place, I need to record details of it, who managed
it and who was involved in it. This could be any number of Seniors or
Juniors.

If I am correct , I am thinking that I would need at least four tables,
Events, Seniors, Juniors and Training.

I could then set up a form that will pull all of the details together but I
also want to be able to report on what events individual Seniors and Juniors
were involved in etc.

As this is my first go at building a DB, could you please advise if I am at
least on the right track and any advice on how to link the tables would be
very much appreciated.

Rob

 

[XPS350]

Hello

I do have some very slight knowledge of Access and have recently purchased
MS Office Pro 2010 which includes Access.

I want to set up a database to record and report on specific Events as they
occur.  Involved in each event there will be Seniors (managing) and Juniors
(participating).

Events can happen on a daily basis and there are a total of approx. 500
Seniors and 1060 Juniors

In order to manage an event, all Seniors need to be annually trained and
within date, ie, they must have been trained within the last 12 months.
This needs to be managed from within the database so I need to record the
date trained and when due for the next training session.

Whenever an event takes place, I need to record details of it, who managed
it and who was involved in it.  This could be any number of Seniors or
Juniors.

If I am correct , I am thinking that I would need at least four tables,
Events, Seniors, Juniors and Training.

I could then set up a form that will pull all of the details together butI
also want to be able to report on what events individual Seniors and Juniors
were involved in etc.

As this is my first go at building a DB, could you please advise if I am at
least on the right track and any advice on how to link the tables would be
very much appreciated.

Rob

Juniors and Seniors could also be in one table (i.e. Person). One of
the fields shows the status of the Person (Junior or Senior). It will
make your design moer easy and when a junior becomes senior, yoy only
have to change the status.

As there is a many-to-many relationship between persons and events
(more than one person can be involved in an event, a person can be
involved in more than one event), you also need a table Persons-in-
Event.