Which applications are more amenable to using a spreadsheet vs. a relational dat

Business & Finance
Tutor: None Selected Time limit: 1 Day

Which applications are more amenable to using a spreadsheet vs. a relational database?  Why?

Apr 13th, 2015

Both spreadsheets and databases are used for managing data.  The computer-age brought about these new applications that could perform complex calculations and print out the data.  Currently, Microsoft, Excel, and Lotus 1-2-3 are the most commonly used spreadsheet applications.  Databases organize information on a specific subject utilizing tables of information entered for various purposes.  Data can be gathered by querying, sorting, filtering, etc.  Databases also use records to structure the tables.  Databases can sometimes be trickier to learn for basic applications.

Many companies make use of both databases and spreadsheets.  For example, a company might need to print invoices and track customers' contact information (spreadsheet), but they also need to quickly determine what an increase/decrease in prices of sales would do to the company (database).

Basically, use a database for:

-  information in a large amount that is unmanageable in spreadsheet form

-  maintaining records for ongoing use

-  the subject information changes often (addresses, price, etc.)

-  generating reports

Use a spreadsheet for:

-  crunching numbers and performing automatic calculations  

-  tracking simple lists of data

-  easily creating charts and graphs

-  creating "what-if" scenarios


Apr 13th, 2015

Studypool's Notebank makes it easy to buy and sell old notes, study guides, reviews, etc.
Click to visit
The Notebank
...
Apr 13th, 2015
...
Apr 13th, 2015
May 28th, 2017
check_circle
Mark as Final Answer
check_circle
Unmark as Final Answer
check_circle
Final Answer

Secure Information

Content will be erased after question is completed.

check_circle
Final Answer