But how do you change the actual name of the team. I have tried with RDBM but when I run the game, scroll to the menu it is still the original team's name. Plus what about the scoreboard short name?
Use FIFA Editor Tool v1.1.0, go to Legacy> data> Loc and download the loc file of your language and also the meta files (eg I am Italian, I download ita_it and ita_it.meta).
Then use the Master DB and open the file (first open the ita_it.meta file and then the ita_it file in sequence).
On the left click on "Language strings 1" and in the search space, in the central column "stringid", find these strings:
TeamName_Abbr15_nnnnn
TeamName_Abbr10_nnnnn
TeamName_Abbr3_nnnnn
TeamName_nnnnn
replace nnnn with the ID of the team you want to change name. Change the names in the right column to "sourcetext".
If some of them are not found, it means that they are in "Language strings 2", look for them there.
Then save and always using the FIFA Editor Tool v1.1.0 import the modified ita_it.meta and ita_it files and create the mod.
I recommend that you put it in position 1 of the FIFA Mod Manager v1.1.0