Formula 1 Database

[dantheman10]

I am a big Formula 1 fan and I am thinking about creating a F1 database. However, I can't decide which is the best way to store the data. I don't know if one race should be a one field or if one driver for one season should be one field. Obviously I want to store it in the best way possible so that I can easily pull out relevant data in queries. My knowledge of Access is relatively limited so any help you could give me would be appreciated.

 

[grnzbra]

You need a drivers table and a races table and a raceway table and, perhaps, a cars table. You would then use linking tables to link multiple drivers to multiple races and multiple cars. Well, perhaps you don't need a separate raceway table except for a lookup table. If you try to put them all in one table you'll drive yourself crazy trying to query it.

 

[Joe8915]

Look at this it give you an idea

http://office.microsoft.com/en-us/templates/CT011366681033.aspx