As databases go...Access is pretty limited in comparison to say My SQL or SQL Server but in my current gig as a contractor supporting a US Gov't agency with no budget for tool but having MS 365 licenses for all. I'm making do. (I am sooo missing stored procedures and C#.)
IMO the proper way...