well I am not much of an FMS fan myself. I think its the worst accounting system ever. Any real company with 2-5m budget (as most schools have) would have trouble surving if they used that kind of software.
But its reporting is limited to say the least, and the user defined reports are not the most easy to do. Exporting reports to Excel is at a sad state as the header lines go all over the place.
Why I could definetely do with an access links is the supplier database. In the new year, we started a brand new FMS database due to funding and bank reasons. But we are missing the hundernds of suppliers. And there is no way of exporting or printing the old suppliers list details.
If I can access FMS tables from Access then I can print the supplier details list.