Spreadsheets and Database Applications
Not what you're looking for?
When do you select the use of a spreadsheet application versus a database application? Justify the selection.
Purchase this Solution
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.
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, ...
Purchase this Solution
Free BrainMass Quizzes
Expulsion and Suspension
Brief description of expulsion and suspension with the impacts on a student's life. This is important for anyone entering the fields of education or childcare.
DIR/Floortime Model for Education Introduction
This brief quiz will provide a basic overview of the DIR/Floortime Model. Understanding this model is important for teachers, therapists, parents, and caregivers.
Mindfulness Techniques
Incorporating mindfulness techniques throughout all fields is an important area to explore. Many people have experienced trauma and may require assistance to remain calm.
Reading Skills
What are some pre-requisites to teach reading? This quiz offers a brief description for a few literacy skils.
Grit and Perseverance in Children
Building small humans is a daunting task. There is nothing more important than our impact on those around us, especially the smallest ones. This quiz offers a brief overview of different parenting modes and how to provide experiences for children to thrive!