Sport Database for schools

[grajy015]

Hi

I am an intermediate MS Access user but am having some difficulty finding the "best way" to maximise the use of a database.

The database is a recording database for school students who participate in school sporting events. Kids in one table, events in another. The events are input in already and are separated into agegroups by a drop down list box. Each child is separated automatically into these age groups (no problem in this last area, although it does not rely on the second table to do so).

The system being used now is inefficient and incomplete. I have picked it up and want to tidy up - or restart from scratch.

How it works is that the students participate in an event, their score and placing is recorded on marshalling sheets and that sheet is taken to the database recorder. They enter in score etc, then the next sheet comes along. Their total score for all the events they are in is automatically calculated (again no problem with this last one) and further calculated to find the winning team.

I need the database to automatically put the students into events based on their age groups, create "template" reports for different events for marshalling purposes (eg one for track and one for field) and find the best way to use sub-reports to create program booklets that get sent home before the event so parents etc know what events their children are in. I know it's a big ask, but any advice would be appreciated.

 

[fneily]

You state "Each child is separated automatically into these age groups" and "The events are input in already and are separated into agegroups". Then you say you want "database to automatically put the students into events based on their age groups". Ok. So link them in a query.
You want to "create "template" reports for different events for marshalling purposes (eg one for track and one for field". Reports are basically templates, everytime you rerun one, it brings in the new data. Do you mean you want the reports to look like the paper sheets you're using now? Then design it.
"sub-reports to create program booklets that get sent home before the event so parents etc know what events their children are in". Subreports? Again, just design a report to print off.
You state that you are "an intermediate MS Access" user. Maybe as you create the queries and reports and have SPECIFIC questions, I or someone else could help.