I know you're wanting to stay with Access, but if you'd consider an alternative, you might consider Alpha Software's Alpha5 (recently up to v.9, though I didn't upgrade past v.7 so far). It's very, very user friendly, and report writing is very good/easy.
Creation of database applications is FAR faster (and easier) with Alpha5 than virtually any other good database program, and no programming is necessary to produce some pretty sophisticated (and nice looking) database applications. They have a language (xbasic) you can use for even more sophisticated features, but it certainly isn't necessary for most users. Personally, I've used it since the old DOS Alpha4 v.1.1 days, and have stayed reasonably upgraded since. Also if you distribute applications, you can purchase unlimited runtime software and licenses fairly reasonably so your end users don't have to go out and purchase a full version of Alpha5 (plus, you control the program, if you're interested someone not messing with what you've created).
I don't work for the company, don't own stock (I think they're privately held anyway), nor do I have any financial interest in them except that they remain alive because I love their software so much. If you're interested, check out:http://www.alphasoftware.com/AlphaFive/ProductTour/Features_00.asp
Oh yes - Alpha5 can import many other formats, including MS Access files.
Some specifics on reporting can be found at:http://www.alphasoftware.com/AlphaFive/ProductTour/Reporting_01.asp