I manage the IT Operations for a UK based Recruitment Agency. We have about 40 employees. Our main business system/CRM runs on a MS Access front-end connecting to on-prem MS SQL Server. The front-end uses a mixture of linked tables and stored procedures to interact with the data. We use mixture of Access Reports and Reporting Services for reporting. We are doing some bits and pieces with Power BI but this is likely to increase moving forward. We have a few external services that we are connecting to via APIs to integration interfaces, not directly to the MDB file. We already have access to the Visual Studio system.
We need to migrate our front-end to a more web based/'modern' platform. We need something that is designed to work in the multi interconnected world that we now exist in, with lots of services being supplied by different providers, generally via some sort of open API. Something that has been designed from the ground up to be web based.
I appreciate this is a very broad question but what would the experts on this forum recommend as a good platform/language/framework to replace Access? We are never going to have hundreds or thousands of users but perhaps one hundred. We are currently on prem SQL Server but could move to Azure at some point...who knows.
As a sub question, if I was looking to contract someone to work for us to define that language what would their title be?
Thanks for any help you can give,