View Single Post
  #1  
Old 17th May 2009, 08:57 PM
Brendon Brendon is offline
Member
 
Join Date: Apr 2009
Posts: 94
Default Making Your Own Databases

I have that much info on Excel, its official: its not funny.

And I must say, I'm a bit of a deft hand at formulas and such. Pretty jolly clever at extracting info out of web page cut and pastes. After 10 years I'm pretty good in my own little world of excel. If I don't know it, I know where to find out. If anyone here wants a hand and I can help I would be only too happy.

With Excel, mainly I start off with Everyrace stats and build from there. I add in the results, Steward's Reports, and a few of my own filters to boot.


So I finally opened up the dreaded Microsoft Access and thought I could put it all in one place.



I hate Access! As of today. Could not make heads or tails of it. Everything is business orientated. Great if you want to store the details of each business customer. But what if your business customer has been in more than one race and sometimes they think he is a front runner and sometimes not? Can't have duplicate business partners can we?

My head was spinning trying to figure it all out. Do I have one table per horse with 30 odd columns of info for each race, or do I enter a different table for each race? Or each horse? I am now the proud possessor of 3 databases of complete cra pulance that I have no idea how to extract anything decent. I just stare at them and the tables stare back at me.

After 3 hours I retreated back to Excel. Databases are very stupid things, I've decided.
Reply With Quote