2 Could you use an Excel spreadsheet to replicate the same a

2. Could you use an Excel spreadsheet to replicate the same activity that you completed for the Access database project? What advantages or disadvantages might using Excel have over using Access in this Case Study?

Solution

The learning curve for Excel is extremely short, so it\'s simple to utilize Excel and is productive right away. Unusual are the situations where IT staff make spreadsheets Information Workers preserved to do for themselves. Excel creates it simple to store data, do numerical calculations, format cells, and regulate layouts to produce the output and reports to allocate with others. Superior features for example subtotals, power pivot tables and pivot charts, and many templates make it simple to accomplish a broad range of tasks. It can even integrate by the Analytic repairs from SQL Server. Tweaking the consequences is too very easy to obtain the exact layout, fonts, colors, etc. that you need.

Unfortunately, there\'s a cost for the flexibility of spreadsheets. As it\'s simple to create formulas, position cells, copy and paste data, and link worksheets and spreadsheets jointly, because the work obtains more complex, spreadsheets become harder to change and manage. As spreadsheets are ideal for make one time analysis, they happen to problematic as the data produces and changes over time. As novel rows and columns get added, summary choices and formulas may require being modified or new ones formed, data and formulas aren\'t always updated, and these errors lead to bad consequences and decisions. The faces of spreadsheets are due to the complexity maintaining them precisely over time and scaling the volume.