Share
Explore BrainMass

Spreadsheets and Database Applications

When do you select the use of a spreadsheet application versus a database application? Justify the selection.

Solution Preview

There are many different reasons why people use database applications over spreadsheet applications and vice versa.
The first thing to note is what a database application is and what is does, and what a spreadsheet application is and what it's purpose is.

A spreadsheet is a list of information for a particular thing. A spreadsheet's main purpose is for organization.

First off, a database application organizes information for a particular subject for a person to retrieve from the database and use. For example, you have all of your contacts for your organization in a spreadsheet and you want to find out the names of all the employees who have been at the company for more than 10 years. You would be able to set up a query in the database to retrieve that information. However, the one thing to note is that the number of years that a person has been employed with the company would need to be a category on the spreadsheet (that is if you are getting the information directly from the spreadsheet). Some database software programs let you "run" reports to gather the necessary information.

According to the website, http://webcache.googleusercontent.com/search?q=cache:upizf53FSEYJ:www.qcisolutions.com/dbinfo1.htm+When+do+you+select+the+use+of+a+spreadsheet+application+versus+a+database+application%3F&cd=1&hl=en&ct=clnk&gl=us&source=www.google.com, "A database organizes information on a particular subject for retrieval. Databases utilize one or more tables of information entered by the user to retrieve data for a variety of purposes. Data can be retrieved through methods such as asking questions of the data (querying), sorting or filtering, and pulling information into a formatted report, like an invoice, that can be printed. Although the tables look similar to spreadsheets, ...

Solution Summary

The pros and cons of using database applications and spreadsheet applications. I look at the best uses for each the workplace, and what each type of software is meant to do.

$2.19