ابدأ بالتواصل مع الأشخاص وتبادل معارفك المهنية

أنشئ حسابًا أو سجّل الدخول للانضمام إلى مجتمعك المهني.

متابعة

Which is better for Data Analysis and Reporting - Excel or Access?

user-image
تم إضافة السؤال من قبل Nelya Gafitulina , Secretary cum Office Administrator , ADNOC Refining
تاريخ النشر: 2017/01/10
m ayaz
من قبل m ayaz , Research And Development Manager , Pakistan Poverty Alleviatin Fund Islamabad

both the software's has own strengths. it will depends upon the nature of work and type of data complexity. excel is recommended due to its simplest and easier use, Excel makes it easy to store data, perform numerical calculations, format cells, and adjust layouts to generate the output and reports to share with others. Advanced features such as subtotals, power pivot tables and pivot charts, analysis toolkit, and many templates make it easy to accomplish a wide range of tasks however access needs greater expertise to handle with the data.  

SUDHINDRA KRISHNAMURTHY
من قبل SUDHINDRA KRISHNAMURTHY , It Quality Manager – Process Management & Improvement , HP Inc.

Microsoft Excel it is. It provides a variety of features for ease of analysis and helps you to perform data analysis to very detailed structure. It enables to make right business decisions based  and very flexible.

 

On other hand, Access is a power full tool when used together Microsoft Excel

Mohammed Imran Sharief
من قبل Mohammed Imran Sharief , Lead Contract Specialist , Saudi Aramco Total Refining And Petrochemical Company - Satorp

Depending on the current ERP systems, it's better to go with excel as most of the ERP outputs support excel for analysis and classfication .

sohaib laraba
من قبل sohaib laraba , Research Assistant , Numediart

Access is a tool that is used basically to mange databases where excel is used to analyse data. It depends though on the size of your data. If your database is too large you need more powerfull tools.

Owais Akber
من قبل Owais Akber , Senior Accountant , Modec Building Material Trading LLC

access is a storage engine basically, it is not designed for analysis purpose, excel, if your data size is small, is a good tool. But for large data it will stuck and you will not able to perform any task. I have used power bi which is very handy and smooth for analysis, but for it you need a good skills for data modeling and some knowledge of DAX programming.

Muhammad Ali Tariq
من قبل Muhammad Ali Tariq , Computer Operator , Z.A School System

Microsoft Excel because it's interface is simple and look like Microsoft Office and actually the main important thing in Excel is Formulas that makes your work easy and simple and take less time....

المزيد من الأسئلة المماثلة