My wife is a financial director. Her team uses Access all of the time to aggregate different sources of data together, including some legacy systems.

A couple of the senior people write queries and import routines, and the clerks/etc use them in their workflow. Works great.