"I'd have thought that any self-respecting data analyst would have done that before creating the tables. It's called normalisation, been around for about 45 years."
I would have thought that, too; then I had to deal with the systems I inherited. Created by ordinary office workers or business people, who do know a lot about their business but are not logicians and data analysts.
This is the "real" world, right; though a mathematician might say it is "complex".
MS Access makes it much easier to pick up the pieces and refashion them into your ideal normalised state.
[No, I do not work for Microsoft, never have, and am now enjoying my retirement so never will.]