F
Fjordur
Hi,
I'd appreciate wise advice and opinions about the best strategy for user
reporting. I have my Access
DB, full of data. Users may want to analyze it in various ways (decision
making, synthesis). I don't want to design and redesign custom forms,
reports or graphs. I need to provide lists, folding (hierarchical) lists,
tables, charts. Therefore I'm planning to use Excel for data analysis and
reporting, as it's both powerful and widely used.
I tend to exclude Access pivot tables in favor of Excel pivot tables, as
anyway any change in Access table semms to imply opening in XL.
I investigated:
- access queries, built with general purpose in mind
- import into XL straight from Access query
- import into XL via Query
- import via OLAP cubes but these seem less flexible than the above.
Can you expert help me choose a good strategy? What are the pros and cons?
Thanks
I'd appreciate wise advice and opinions about the best strategy for user
reporting. I have my Access
DB, full of data. Users may want to analyze it in various ways (decision
making, synthesis). I don't want to design and redesign custom forms,
reports or graphs. I need to provide lists, folding (hierarchical) lists,
tables, charts. Therefore I'm planning to use Excel for data analysis and
reporting, as it's both powerful and widely used.
I tend to exclude Access pivot tables in favor of Excel pivot tables, as
anyway any change in Access table semms to imply opening in XL.
I investigated:
- access queries, built with general purpose in mind
- import into XL straight from Access query
- import into XL via Query
- import via OLAP cubes but these seem less flexible than the above.
Can you expert help me choose a good strategy? What are the pros and cons?
Thanks