Access as a front end for mssqlserver ran great in a small shop. Seems like there was a wizard that imported the the access tables easily into sqlserver.
I've not seen anything as easy to use as the Access visual query builder and drag-n-drop report builder thing.