Design Sport Timing System Advice

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi all, can someone give me some advice.

I am planning to build a MS-Access Database for a 24 Hour Running around a
400 metre track event.

I need to:
1. Enter runner's numbers and times.
2. Have a 24 Hour clock in MS-Access that connects to entries, so enter
runner and time entered is also kept.
3. Show individual and team results for each lap/overall laps
4. A display for live updates
5. Reports of each runner and overall results to pdf etc.
6. Calculate 400 metre laps total KMetres for each runner.
7. Have form with clock for entering runners number on each lap.

Can this be done, is MS-Access the software to use?

Any books I could use for this?

Where do I start?????!!!!!!
 
so, to start you need to define entities and attributes
entities
runners
teams
events
results
...

attributes for runners
name Roger
address
phone
email
....

attributes for teams
name Willy Coyotes
runners
...

attributes for events
name Boston Marathon
event date
start time
number of laps
distance of one lap
....

attributes for results
runner
lap number
start time
end time (also the start time of the next lap)

rules
runners belong to teams
runners participate in events

am I missing any entities, attributes, rules

once you've got this, you can create tables
tblRunner
runnerId
runnerName
.....

tblTeam
teamId
teamName
....

tblTeamMember
teamId
runnerId

tblEvent
eventId
eventName
startTime
numberOfLaps
distanceOneLap

tblResult
resultId (autokey)
eventId
runnerId
lapNumber
startTime
endTime
...


do this help
 
Yes, thanks that does help that's is a good start - so once I have created
this layout how do I say when I enter the runner number - how do I get the
runner's number to calulate the time, distance and output that information to
a display to see progress of race.

thanks, mark.
 
create a query based on tblResult that selects all fields ORDER by
event, runner, lap number

create a continuous form based on the query, to show, for a runner, lap
by lap times

add unbound listboxes in the header of the continuous form to choose
the eventId and runnerId of interest

add a command button in the header to 'search' for the runner, which
sets the continuous form's rowsource

now you can enter times
 
Back
Top