M. Porter, Senior Executive, Master of Art, San Jose
Answered Aug 29, 2019
An electronic spread sheet is simply a program that represents the electronic version of paper worksheet. It is created to help people with need to store accounting and analytic information in a tabular form. Spreadsheet stores data in cells.
The most common spreadsheet program is Microsoft Excel However, databases involve more technical processing. Databases store data values in tables and each table has a name. The most commonly used database program includes: Microsoft Access, MYSQL, SQL and Oracle. Database programs can also store large amount of raw data compared to spreadsheet.
Managing a lot of information right now has changed considerably over the past years. The use of computers has made it more possible for people to share and also manage information. The database management system can be used when people need to share some data with a select number of users.
This means that the data will not be available to other people. The electronic spreadsheet is a bit more public. , and it is not as private as the database management system. Both can be customized to suit the needs of the users.