Yes that would suit my requirements.The attached are screenshots of how your data would look like in Access
On the TournamentYear screenshot you can look at previous years or add a New Year.
The Players Firstname & Surname are in separate Columns due to the Import of Data.
The Combobox for selecting a Player is looking up a List of Current Players
Once all of the Players have been selected for all of the Tournaments then the Controls for Firstname & Surname can be deleted.
Would this suit your requirements?
I've been working on this the last few days based on all of your advice and I'm now at the point where I've replicated all the functionality of my spreadsheet but in Access and it's a lot better than the spreadsheet ever was, so thank you all for your help