EDIT: I've added more details at the bottom, to answer the various questions that people have asked.
I currently have an MS Access database which I use to keep track of my organisation's devices (laptops etc). I have it stored locally on my own laptop, as I've been the only one who's updating it.
However, now I'd like to open it up to other colleagues; as they're not familiar with how it works, I'd like to have a sort of 'front end' to make it easier. Essentially this would involve a couple of forms that they can complete (for instance, when a new device is purchased, someone should be able to go to the form and add the device details, and that should add the device to the database) and reports which can be viewed (e.g. they may want to see all the devices which are currently available to be issued to people).
Obviously this will first of all need the database to go online; secondly, I'll need somewhere to host the forms and reports. We currently use SharePoint, so I was hoping to have the forms and reports on there. I've been looking online, and I can't figure out the best way to do this - there seem to be a lot of options out there, and don't know what the current best practice is. I've seen Dataverse mentioned, but I don't know whether I have access to that - I can't see it anywhere. I've also seen articles which mention Power Apps and Visual Basic and various other things. I just don't really know where to start with putting it all together.
Can anyone advise me on the current best approach for this?
EDIT - ADDITIONAL DETAILS:
Our offices are spread across the world, and some people work from home, but we have a central server which is sitting behind a VPN. Everyone is able to sign in to this server, but it's a bit of a process, so I'd probably rather avoid people having to connect directly to it.
We do use SharePoint, and I think the ideal thing would be to have a couple of SharePoint pages: one where there are a couple of forms - add a new device, reallocate a device to a different user etc; the second which shows the list of devices and can be sorted by things like device status (e.g. find the ones that are ready to be reissued), current owner etc (we quite often have the situation where someone sends a message to say that their laptop is playing up, and we need to look through the spreadsheet to find the details, check the warranty etc).
I've thought about using Forms with Power Automate, but I can't see a way for PA to write to an Access DB; also I'm not sure how I would then get reports.
I don't have a Power Apps subscription, so would rather avoid that.
The others who'll be using it are generally reasonably techy, but it needs to be straightforward and quick, because people tend not to have a lot of time (it's not really anyone's main job to manage the devices, so they tend to be doing it in a rush when they have 5 minutes to spare.
Our current solution is an Excel spreadsheet, but it's quite limited in terms of storing things like details of previous users, repairs and modifications etc.
