Golf db

[Pyeman]

I'm a new user. I want to create DB for our golf league. We play 25 tournaments per year. We have around 80 active participants of which 60 to 70 will play in each tournament. I want to record winners in a number of different categories: 1st, 2nd and 3rd low gross in A,B and C flight; 1st thru 10th in a low net category; a skins (lowest score on an individual hole) category; a skills category that awards long drives, long putts, closet to the pin on random holes; and finally a category for 5 special holes that we call pots-of-gold whereby money accumulates if the hole is not won outright with a low score. Each prize has a dollar value that changes each week.



Ideally the DB would have user friendly forms so end users can easily enter winners in each of the aforementioned categories and print easy to read reports of each tournament winners.

I’ve been reading “Access for Dummies” and devouring online instruction videos. I have a rudimentary understanding of tables, queries, forms and reports. But I’m baffled with data base design and building correct relationships between tables. Most if not all examples I’ve come across deals with data bases for business…invoices, orders, products…etc. I just can’t seem to make the leap from those examples to my very specific needs.


Is Access the correct program? I am thinking of investing in an “Introduction to Access” course offered by our local college. Will I be wasting my money? Should I be looking at another more suitable software program?

[June7]

I have seen discussions on various sports league database apps (darts and bowling come to mind) in several forums. I see four threads on golf listed at bottom of this one. Access (or any relational database) would be an appropriate medium for this sort of data.

Could probably spend a solid week with an introductory book at home and get as much as going to a formal classroom. If I can use references to teach myself calculus and Android app programming as well as VBA, anyone can self-teach database design. Unless you need the credits on record, exercise some self-learning discipline and save your money.

[Minty]

I'm a keen golfer, and I have been thinking of knocking something together to help with competition organisation for ages.
Needless to say it's a bit of a busman's holiday, so inevitably I haven't got round to it.

I would just dive in and see what trips you up. As June7 says Access is as good as anywhere to store and manipulate the data.

There are a couple of good tutorial sites but I would have a look at this list for some pointers.
Work through the examples where they are present.

https://www.accessforums.net/showthr...133#post352133

[Welshgasman]

In fact see if any of these can give you a head start, or at least a heads up?
https://duckduckgo.com/?t=palemoon&q...atabase&ia=web