-
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
-
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.
-
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)
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules