In general, being a DBA is considered “more senior” role than a software developer. It makes SW development easier to outsource coding role to outside party.
Probably good way...

MS Access has a Upsizing Wizard that moves your table(s) to MS SQL Server (so you essentially get a client-server application, MS Access still being a front-end)
You can use...