Access (they say) is a great programme.
I have spent a lot of leisure time with the thing and can write a new one for some simple purpose. Trouble is that I forget so quickly and even relearning I find a difficult process.
That said, so you understand my very limited ability, Access is a "Relational Database"
You can often simplify a problem by using separate related tables for anything that is proving awkward, and then rely on queries to sort out the reports you need.
So I feebly suggest you might make separate tables for each team manager and one for all the 120 team members each of which can be labled to indicate which team they are in.
Probably what you may have already done but airing the idea may help.