Good Example Of Essay On A Course Work

Management

1. Two of the major advantages of using an electronic spreadsheet instead of a paper-based ledger are:

A. Convenience

Electronic spreadsheets are more convenient to use than paper-based ledgers because it allows you to put a calculation format throughout your sheet. You can easily input the raw data and get results right away. When you commit a mistake, there is absolutely no need for you to redo the calculation from the top. In paper-based spreadsheets, however, one mistake can take you several computations back. Additionally, electronic spreadsheets, such as Excel, allow you to store as much data as you want.

B. Accuracy

In electronic spreadsheets, the values that can be generated are more accurate. If you create a spreadsheet, and make sure that your formulation is correct, you can rest assured that the figures will be correct as long as you input the data correctly. Since you only have to format it once, it greatly reduces the risk of human error, resulting to a more accurate accounting record.
2. Spreadsheets are primarily used for data gathering and analysis. Companies use spreadsheets to track their finances, overall production, as well as the performance of their employees.
Example: In manufacturing, spreadsheets are used to consolidate and analyze the data for production quantities - starting from the raw materials to the finished products. This data is processed by computing how much product is being made on a per-hour basis, the total cost it takes to make the product, and the total manpower/ man-hours it takes to process it (Dooley, n.d.).
3. A Relational Database Management System (RDBMS) is a program designed by Edgar F. Codd--the father of modern relational database design, that allows one to create, update, and administer a relational database (Rouse, 2005). Its benefits include:
Convenient storage of data - In RDMS, data need only be stored once. When changing one data, all formulations linked to it is automatically changed. It also allows easy modification of data entries. And it is a more efficient storage of information.
Carrying out of complex queries - RDMS makes use of a language called SQL that allows the programmers to insert, delete, create, and drop table records.
Better data security - Through the use of table splitting, the author of the file can restrict the access of other users to the data. This allows confidentiality and better data security.
4. Excel is used specifically one for its advanced mathematical calculations and statistical comparisons. Access, on the other hand, is used for its ability to organize and display data in a structured and well-constructed manner.
Excel and Access are two very helpful data analysis and management programs designed to make our lives way easier. Each program is designed for a specific purpose but are both being used interchangeably. Here is a table that summarizes the unique functions of Excel and Access:

Key Comparisons between using MS Access or MS Excel for your data requirements (Phillips, 2014).

In online businesses, for example, Excel can be used in maintaining lists, performing quick number crunching and sharing of data; while Access can be used in tracking customer orders, managing business contacts, maintaining inventories and organizing staff tasks (Miller, 2014).

References

Dooley, K. (n.d.). How Do Companies Use Spreadsheets? | eHow. Retrieved from http://www.ehow.com/how-does_5244461_do- companies-use-spreadsheets_.html
Miller, L. (2014, June 1). Difference Between Microsoft Access & Excel | eHow. Retrieved from http://www.ehow.com/facts_ 4842302_difference-between- microsoft-access-excel.html
Phillips, G. (2014, November 7). Key Comparisons between using MS Access or MS Excel for your data requirements [Table]. Retrieved from http://www.makeuseof.com/tag/excel-vs- access-can-spreadsheet-replace-
database/
Rouse, M. (2005, November). What is relational database management system (RDBMS)?. Retrieved from http://searchsqlserver.techtarget.com/definition/relationa l-database-management-system