So basically the SQLite of its day?
Those business apps made "by that one person" that allowed few other to input data concurrently (back then no google sheets / shared Excel... which are horrible and have no user defined GUI) and then to make reports.
Also data manipulation when it didnt fit Excel (I know access has 2gb limit, but it was a lot).