Help creating golf statistic form

[np]

I am trying to create a form that will somewhat mirror a scorecard that I can
use to keep statistics such as score, fairways hit, greens in regulation,
etc. I need the information for multiple tournaments and want to input the
information hole-by-hole. Any suggestions on how to set up a form to
accomplish this?

 

[John W. Vinson]

I am trying to create a form that will somewhat mirror a scorecard that I can
use to keep statistics such as score, fairways hit, greens in regulation,
etc. I need the information for multiple tournaments and want to input the
information hole-by-hole. Any suggestions on how to set up a form to
accomplish this?

The *form* is not what you should start with! Forms are just tools, windows to
let you edit data in Tables. The tables and their relationships come first;
they're the foundation of your structure. The forms come later.

You'll need several tables - probably a table of golf courses (unless the
tournament is all at one course), a table of holes with 18 records for each
course (with information about the hole such as par, distance, etc.), a table
of players, and so on. Get THAT all set up and then start thinking about the
Form!

 

[Pete D.]

I would search Google for this info, although you will get answers here you
will find thousands of samples on the internet that you can tweak. Funny so
much interest in a little white ball. Try "MS Access Golf Database" without
the quotes as your search and be prepared to spend much time picking the
perfect toy to modify.

 

[np]

Thanks - I had already created all of the tables and started to set up a form
for easy input. Ideally, I would like to set it up where you could input as
if you were reading across a scorecard hole-by-hole. So you'd have holes 1 -
18 and for each hole you'd have data such as par, score, fairway hit, etc.
I'm familiar with basic forms but the repetitive nature of the data is what
is throwing me.

Does that sound like something that is feasible to do without too much code?

 

[Pete D.]

Sure, besides it sounds like you're doing it for fun or maybe even to learn
something. First stop building your form for a bit and think out what data
you need to save and what can be calculated. Write it down and build your
table from it. For instance you'll need to handle different courses and
par. This is kind of static data. Next you'll want to figure handicap.
This is standard data but with different standards so you'll need to figure
out a table for the variable depending on course/org so that if you play for
at one club that uses the one calculation and another that uses a different
one you can load those differences in a table so your calculation will be
right for the handy cap by just selecting the org. Golf is great as it has
specific rules so you can think it out. Might even add a table for Eagle
Golf course uses these rules and Duffer course uses these rules so each
course could select one or many rules depending on type tournament. Starting
from the form may be harder in the long run to make it all happen. For
instance, before you open the form you may want to select course, which
includes their handicap rules, if it is just for fun or for a tournament,
might even want to make a note of the weather, time of day. Make notes and
think out the tables. Now you will know what data you need to gather with
your forms. Of course you can just make the form to record what you do on
paper, which is also fun but you might be surprised. If you think out the
tables you might find some common issues that could improve your game and
overall score depending on the course.