What is d diff between a database and a spreadsheet?also, is excel a database?

Question

beside,is there any site from where i can download for free any database

Answer 1

Spreadsheets and databases although originally two very separate application programs, have both evolved to have a few functions that make them more alike. For example, spreadsheets can sort “records,” and do searches while databases offer some ready made formulas to calculate interest and other sums. Although an advanced user can usually go through gyrations that persuade either type of program to do many, but not all, of the things that the other one does, there are some things which are easier in one program than the other. In order to take full advantage of electronic data it is necessary to be familiar with the specialties of both types of programs.

The most important difference is how these two programs look at data. A spreadsheet makes it easy to access an individual cell, thus its data, although in table format, can have different types of information in the same column or row. In a database the data is structured, that is a column (field) contains the same type of information for each line. Each line is a record and contains information pertinent to the same overall entity, e.g. a patient. Many of the functions that each does best is based on this difference.

A spreadsheet is a good tool for work that involves mainly mathematical calculations. A database, however, is far superior for managing information. The main difficulty with using a spreadsheet in place of a database is that one has to use a flat file design with all the attendant problems that this creates.

An excellent resource on this topic is:

Patten, B. (1998). Database vs. spreadsheet is no contest. http://www.bizjournals.com/phoenix/stories/1998/10/19/smallb4.html?page=1

Excel: Database vs. Spreadsheet. A discussion of when to use which in easily understood language.
http://tutorials.esmartweb.com/excel/databasevsspreadsheet.htm

Answer 2

A data base will have more "data" like names, info. Maybe a mailing list.
A spreadsheet is usually like an accountants ledger.
Excel is a program. You can make a database using Excel. It's very easy. Just add the names to the first cell, the address to the second cell, phone numbers to the third and maybe email addresses to the next. You have a database. You can use it to do a mail merge in Word for your mailing labels/envelopes.

Answer 3

Excel is a spreadsheet program, a spreadsheet is just a form where data is stored, a database is also a place where data is stored, but usually in certain orders and with certain links, MS Access is usually used to databases.