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.

Reply
 
Thread Tools Search this Thread Display Modes
  #1  
Old 17th May 2009, 07: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 08:01 PM.
Reply With Quote
  #2  
Old 17th May 2009, 09:02 PM
Chrome Prince Chrome Prince is offline
Member
 
Join Date: Jan 1970
Posts: 4,362
Default

Some people love Access, though I think you need a degree in programming to get anywhere.

Have you looked at Filemaker or Alpha 5 databases, they are a lot easier to use, and have better built in functionality (easy to use).

The problem of Access is that they built it for advanced users who already know VBA and other coding. They built it for professionals.

Other database platforms have built in queries in simple language without having to code the entire thing from scratch.

All you need to do is plan your database, it doesn't necessarily have to be relational, it can be flat file like excel.
__________________
RaceCensus - powerful system testing software.
Now with over 398,000 Metropolitan, Provincial and Country races!
http://www.propun.com.au/horse_raci...ng_systems.html
*RaceCensus now updated to 29/02/2024
Video overview of RaceCensus here:
http://www.youtube.com/watch?v=W821YP_b0Pg

Last edited by Chrome Prince : 17th May 2009 at 09:04 PM.
Reply With Quote
  #3  
Old 17th May 2009, 09:27 PM
Brendon Brendon is offline
Member
 
Join Date: Apr 2009
Posts: 94
Post

Quote:
Originally Posted by Chrome Prince
Some people love Access, though I think you need a degree in programming to get anywhere.

Have you looked at Filemaker or Alpha 5 databases, they are a lot easier to use, and have better built in functionality (easy to use).

The problem of Access is that they built it for advanced users who already know VBA and other coding. They built it for professionals.

Other database platforms have built in queries in simple language without having to code the entire thing from scratch.

All you need to do is plan your database, it doesn't necessarily have to be relational, it can be flat file like excel.
I peeked at your database and thought: "I can do that!"....well maybe not so good, but it would suit my purposes, just for me. LOL

But I gave myself a good dose of monkey see, monkey don't do.

I am pretty good with VBA. OK I guess. But you are right Access is suited for the workplace where someone is getting paid 22 an hour and he doesn't much care if it takes 40 hours to put it together.

Me, I got Sandown in Wednesday! :lol:
Reply With Quote
  #4  
Old 22nd May 2009, 11:00 AM
lomaca lomaca is offline
Member
 
Join Date: Jan 1970
Posts: 1,096
Default

Quote:
Originally Posted by Brendon
So I finally opened up the dreaded Microsoft Access and thought I could put it all in one place.
If you mean, all in one table, yes you can do it but that defeats the purpose, that's what spead sheets are for.

Quote:
Originally Posted by Brendon
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.
But you can still put it in one database , you will have to use different tables for the horses records, and have a few identifying records in each table to be able to connect the tables. In horse racing usually 3 records are enough, like date venue and race number.


Quote:
Originally Posted by Brendon
After 3 hours I retreated back to Excel. Databases are very stupid things, I've decided.
They are not "stupid" they are a tool, different from a spread sheet, and if you learn to use them you will see the difference.
Very few serious developers actually code in VBA, the native language of Access. All front end apps. use C++ or later , VB, or later. much easier and a lot more flexible, Access is used just as a storehouse for data.

If Excel does what you want, use it. I know business people who run multi million dollar businesses on nothing more than Excel.

Excel 2007 can handle almost unlimited number of records, and Access 2007 has all the built in functions as Excel and the interface even looks like Excel.

Good luck
Reply With Quote
Reply


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 01:23 AM.


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