Access Key points on analyzing data from multiple sources

Murray Brown
Murray Brown used Ask the Experts™
on
Hi
I have a client that say that they receive data from multiple sources. I want to advise them on why they should use Access as their analytical engine
What key points other than ease of use can I mention?
Thanks
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Hardware Tester and Debugger
Commented:
Hi there! :)

Below are some main points which you can explain in order.

1) Microsoft Access offers a query wizard which is used for basic data analysis.
491660.image3.jpg
2) This new table you are trying to generate from the query can be in the form of normalizing or de-normalizing data to show different table representations. Furthermore, the database relationships can be easily edited to show consistent information between tables by marking the primary keys.
microsoft-access-table-relationships.png
3) For statistical analysis, there is an add-in called Total Access Statistics which offers a wide range of statistical functions to analyze your data. Using this add-in, data can be in Access tables, linked from other sources such as SQL Server, or from a query. You may refer to the following link as reference.

Reference: https://www.fmsinc.com/MicrosoftAccess/StatisticalAnalysis.html
describe-output-sm.png
John TsioumprisSoftware & Systems Engineer
Commented:
Access is probably the best "Swiss Knife" when it comes to connecting to a gazillion of data sources...as long there is driver...just just Link to it and pull data...it couldn't be easier...and then you query them as you like and for the End ....with a few clicks ready made professional reports....what more to ask....
Most Valuable Expert 2015
Distinguished Expert 2018
Commented:
they receive data from multiple sources

But what types of sources? And what type of analytics?
Power BI or even Excel may be a better choice for some scenarios.
Murray BrownASP.net/VBA/VSTO Developer

Author

Commented:
Thank you for the advice. I think an Access and Excel solution is best
NoahHardware Tester and Debugger

Commented:
You're welcome! Glad I was of help :)

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial