newbie question on sports stats

[toffa]

Hi all i have been asked to create a stats database relating to teams on a sporting group.

The stats are basic including how many wins loses
previous history including how many wins loses against particulr team and at what ground

and what teams should win the next round.

My problem is i have 5 years of previous years of data on excel and dont really know where to start as a data base.

If anyone has any clues on where to start or even some examples that i can look at to get the ideas would be great

Thanks Chris

 

[PHV]

A good starting point to understand how a database is different from a spreadsheet:

http://r937.com/relational.html

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[toffa]

I understand thatand have setup databases for business ideas and sales but for saving stats i would think as different

The onfo was saved into excel because the user didnt know anything else.


Chris

 

[lespaul]

Why would stats be different? Figure out what raw data you need to save to calculate the stats and then write queries that do the calculcations.


Leslie

Anything worth doing is a lot more difficult than it's worth - Unknown Induhvidual

Essential reading for anyone working with databases: The Fundamentals of Relational Database Design

 

[wdverner]

A starting point would be to list the columns that you have in excel etc. Then draw them up into a set of relational tables, normalise and then open Access and implement your design.