Help needed setting up a F1 scorecard

[NickJ]

Hello People

I’m new to Access and I’m trying to create a database of the upcoming Formula 1 season. I’m trying to create a database that I can show all the details I want at a click of a button, my first problem is this…

How would the work?

What tables do I need? This is the information I would like to show and store in the database but I’m not sure how to put it all together and sort out all the relationships, can someone please help.

Drivers
First Name
Second Name
Team they driver for
Champion ships
Total points so far
Points needed to win
Last race position
Racing History (points won, number of pole positions, number of wins, number of DNF (Did Not Finish))

Teams
Name
Tires
Engine
First Driver
Second Driver
Total points so far
Points needed to win
Last race positions


Tracks
Name
Location
Winners
Track History (Last year’s Lap Record(driver Name),average weather, ))


Thanks

NickJ

 

[alastair69]

Have a look at this thread should help you out.

I did a simple to use search on "Racing Database" and this one came up.

Link http://www.access-programmers.co.uk/forums/showthread.php?t=81781&page=2&highlight=racing+database

Alastair