Results 1 to 4 of 4
  1. #1
    Tiger76 is offline Novice
    Windows 10 Access 2016
    Join Date
    Jan 2020
    Posts
    1

    Suggestions on using Access to manage a golf league

    I am a new Access user. I'm working hard to teach myself basic techniques. I want to use Access to manage a golf league. Some of the tasks that I need to do is to keep track of who plays in which tournaments and keep track of their scores. Since I have a pretty constant list of members, I'd like to have a check box page where I can just check next to who will play this week and then print custom scorecards. There is a lot more that I'm working on, but was hoping somebody could point me in the right direction to get started or at worst what not to do. Thanks for any suggestions.

  2. #2
    moke123's Avatar
    moke123 is offline Me.Dirty=True
    Windows 7 32bit Access 2010 32bit
    Join Date
    Oct 2012
    Posts
    420
    Look around for some data models.
    Heres one to start ...http://www.databaseanswers.org/data_...ents/index.htm

  3. #3
    Micron is offline Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    6,754
    Lots of golf-type schemas here, if you know how to interpret them. The biggest and most important thing you need to understand is normalization. If you don't yet, study it before jumping in to an actual db. Then there's all the supporting stuff about naming things, understanding auto numbers, impact of using multi-value fields (most experience developers don't), etc.; stuff that I have no idea if you know all about or not. If you understand Excel real well, it's more of a handicap than an asset when it comes to designing a database.

    So if the schemas at the link are like a foreign language to you, I'd guess you don't understand normalization.

    Moke123 - Wow, 22 minute delay before your post showed up.
    - "doesn't work" doesn't help. Implement changes in copies of your database.
    "Everyone has a photographic memory; some just don't have film." Steven Wright

  4. #4
    orange's Avatar
    orange is offline Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    14,596
    Tiger,
    You may get some ideas from the links in the Similar Threads section at the bottom of the page.
    Good luck with your project.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Manage User Access
    By sparker75 in forum Macros
    Replies: 4
    Last Post: 08-14-2018, 04:23 PM
  2. Golf Score database
    By JR Taylor in forum Database Design
    Replies: 11
    Last Post: 05-04-2017, 04:17 AM
  3. Replies: 3
    Last Post: 03-18-2015, 09:38 AM
  4. How to manage the manage the input of data?
    By Gambit17 in forum Import/Export Data
    Replies: 4
    Last Post: 07-30-2013, 10:32 AM
  5. Golf scorecard form
    By jrupp82 in forum Forms
    Replies: 1
    Last Post: 03-10-2011, 11:47 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Tech Forums: Microsoft Office Forums