Results 1 to 3 of 3
  1. #1
    markb is offline Novice
    Windows 10 Access 2013 32bit
    Join Date
    Feb 2018
    Posts
    1

    New to MS Access

    Hi

    I'm hoping that someone can point me in the right direction or give me some advice, please?

    I'm a volunteer coach for a community football (soccer) club and I've been tasked with collating the details of all coaches, first-aiders etc. to be held in one place.
    So my first dilemma is - should I use Excel or Access?
    I use Excel on a daily basis but have never used Access.

    I'll need to collate names, addresses, coaching qualifications etc. so I want to make it as user-friendly, as possible.

    Any help would be greatly appreciated.

    Thanks,
    Mark

  2. #2
    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
    16,716
    Here is a link to articles and videos related to Database Planning and Design.
    https://www.accessforums.net/showthr...133#post352133

    Access(database) and Excel(spreadsheet) are very different animals, built upon different models.
    Access is not just a bigger Excel.
    Good luck.

  3. #3
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    youd want Access. Below are table designs you may want:

    tGames table
    ----------
    HomeTeamID (long)
    VisitTeamID (long)
    GameDate
    HomeTeamScore
    VisitTeamScore
    WinnerID


    tTeams table
    -----------
    TeamID (auto)
    TeamName
    CoachID (id in tRoster table)
    TeamAddr


    tRoster table
    ----------
    TeamID (long)
    PLayerID (long)
    Position


    tPlayers table
    --------------
    PlayerID (auto)
    FirstN
    LastN
    Birth
    addr
    city
    etc...


    tStaff table
    --------
    StaffID (auto)
    TeamID (long)
    FirstN
    LastN
    Birth
    addr
    city
    state
    JobDuty (coach,1stAid,assistant,gopher)

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

Posting Permissions

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