Yes, that is the usual way how it is used today. It is used as a frontend to quickly generate queries against a backend SQL server and make some fancy pivot tables.

Very rarely is the data stored in the Access file itself.