Has anyone used access for a golf league or excel

[Guest]

I run a golf league and am using excel to keep track, I would like to use
more advanced functions to generate the data. I keep score of each hole and
total points . Scoring would require the program to determine points by
score of the hole. A par is 3 points, one over is 2 points, two over is 1
point, one under is 5 points 2 under is eight points.

Is this type of evaluation better handled in Excel or Access, can it be done
in one cell per hole per round?

 

[strive4peace]

Access would be work well. Here is a sample data
structure (I don't know the lingo you would want
to use, so you may want to change some fieldnames):

*Players*
PlayerID, autonumber
Lastname, text
Firstname, text

*Rounds*
RoundID, autonumber
PlayerID, long
RoundDate, date/time

*Holes*
HoleID, autonumber
HoleNum, integer -- 1 thru 18
Par, integer

*RoundHoles*
RHoleID, autonumber
RoundID, long integer
HoleID, long integer
Score, integer

Points would be a calculated field


Warm Regards,
Crystal
Microsoft Access MVP 2006

*
Have an awesome day

remote programming and training
strive4peace2006 at yahoo.com

*