Sporting Event Database

[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?????!!!!!!

 

[Steve Schapel]

Mark,

I don't thonk I can answer your more general questions, except to say
that you would go about building this database application, by following
the general principles that apply to building database applications in
general. Perhaps a book such as "Building Access Applications" by John
Viescas, would be of great assistance here.

I would say that it can certainly be done, and I would also expect that
Access is very suitable for the purpose. You will, of course, need to
work out how the data is going to be captured and entered into the
database. And there may be technical questions to answer if the
recording is to be done track-side, and the computer running the
appication is located elsewhere. Sounds like a very interesting project.