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