Smartgambler
Pro-Punter

Go Back   OZmium Sports Betting and Horse Racing Forums > Public Forums > General Topics
User Name
Password
Register FAQ Search Today's Posts Mark all topics as read

To advertise on these
forums, e-mail us.

 
 
Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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.

Last edited by Brendon : 17th May 2009 at 09:01 PM.
Reply With Quote
 


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is On
Forum Jump



All times are GMT +10. The time now is 07:28 PM.


Powered by: vBulletin Version 3.0.3
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
©2008 OZmium Pty. Ltd. All rights reserved . ACN 091184655