Access Database Azure Web Migration

I built a financial database in Microsoft Access and currently keep the tables on SharePoint so I can open the file from any workstation. It works, but it’s clunky and slow, and I have finally decided to turn it into a proper cloud-based application running on Microsoft Azure.

Here is what I need:

• Re-create the existing data model and logic from the Access file (forms, queries, reports, VBA where applicable) as a modern web app hosted on Azure—SQL Database or other native storage that makes the most sense is fine, as long as everything ends up fully managed in the Azure stack.
• Migrate the current SharePoint-hosted tables and all live data with zero loss or corruption.
• Build a straightforward email-and-password authentication flow and layer user access controls on top, so I can define roles (e.g., read-only analyst, data editor, admin).
• Keep the interface lightweight; dashboards and real-time analytics are not a priority for this phase. I mainly need every form and report I have now to work in a browser with the same calculations and business rules intact.
• Provide deployment scripts or CI/CD steps so I can redeploy to another Azure tenant later, plus brief hand-over documentation.

Acceptance criteria
– Every function available in the current Access front-end is reproducible in the web version.
– Data migration is validated by record counts and sample spot checks.
– Role-based permissions block or allow CRUD actions exactly as specified.
– App runs in Azure without any local dependencies.

If you have solid experience modernising Access solutions and are comfortable with Azure Web Apps, Azure SQL, and typical identity flows, this should be a straightforward project. I’m happy to give you a copy of the .accdb and a screen-share walkthrough before we start.