OOTP Developments Forums - View Single Post

Long_Long_Name · 11-12-2005, 06:38 PM

I plan on creating a database similar to Lahman's database using the NHL's data. The idea came to me when realizing that we could very easily adjust point totals for different eras, and that several similar operations could be done. What's even better is that since the rinks are all more or less identical, there is no such thing as "rink factor" in hockey.

My problem is that I don't know whether to start in Access or Excel. I'm very familiar with Excel and I see that it's very limited and that I couldn't do a very complete database with it. However, I haven't used Access in a very long time and even though I don't quite know it, it doesn't seem very appropriate to make calculations, adjust data and similar things.

Could anyone help me out here?

11-12-2005, 06:38 PM	#1
Long_Long_Name Hall Of Famer Join Date: Jan 2002 Location: Montréal Posts: 7,065	Lahman's Database, hockey version I plan on creating a database similar to Lahman's database using the NHL's data. The idea came to me when realizing that we could very easily adjust point totals for different eras, and that several similar operations could be done. What's even better is that since the rinks are all more or less identical, there is no such thing as "rink factor" in hockey. My problem is that I don't know whether to start in Access or Excel. I'm very familiar with Excel and I see that it's very limited and that I couldn't do a very complete database with it. However, I haven't used Access in a very long time and even though I don't quite know it, it doesn't seem very appropriate to make calculations, adjust data and similar things. Could anyone help me out here? __________________ Beta Baseball. Join it!