forget back end on the cloud/One Drive/WIFI - anything like that. It is a recipe for db corruption. If WAN, db part had better be wire connected.
Support for Access/SharePoint is on the way out.
AFAIK, you can buy Access 2016 off the shelf (no 365) but if dumping the SharePoint idea, 365 could still work for you. 2007 is getting a bit old for starting up a new app.
MS Access 2000 (Time of inception)
Hardly. 1.0 came out around 1992.
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.