Your question is a bit vague about what you actually want to do - develop or execute
there are these opensource options
https://opensource.com/alternatives/access
however no experience of any of them so no idea if they are right for your requirement. I think it is safe to say there is nothing like access for ease of use and general stability. And nothing that will convert it to use in another application.
as far as an access web front end is concerned since that runs in a web browser I don't see why not in principle - (I presume you can link to postgreSQL) but it would need to be developed on a windows machine - and access web is no longer supported so likely to be a dead end in the long run.
Alternatives to developing web front ends to access - there are loads, some are opensource some platform specific - suggest review this link
https://alternativeto.net/
However all will have a very steep learning curve compared with Access