I have a Microsoft Access based tool that lacks the reporting capability I need. The tool is able to extract extract each table from its relational database as a separate CSV file. These files aren't too easily read by humans, since you need to cross reference the IDs from each file.
I need to create something that will allow my team to generate periodic reports - usually with the same format and information, and I will not be there to help them in future. There seems to be two options: (1) Create an Excel spreadsheet that uses many complex nested formulas to combine the CSV files, or (2) use MS Access, a tool I'm unfamiliar with, to generate Excel reports.
What would you recommend?
In particular, is it possible to create something with MS Access that will allow anyone to then generate Excel reports, even if they only have the free MS Access Runtimes rather than an expensive full copy of MS Access?