Zoho Creator is probably the closest thing to a web-based Access product that I've seen, and it's still not quite Access. Access occupied a very strange space in between an actual application framework, a database GUI, and an IDE.
But I think Access is awesome for making and battle-testing prototypes that can eventually become actual CRUD apps. Great intermediate step somewhere in-between e-mailing spreadsheets and building a Rails app, for getting shit done at the office.