Why are databases good? As opposed to say...spreadsheets?

Question

For my ICT coursework, i am creating a villa/cottage database and i used Microsoft access, however now need to give reasons for my choice of software.
As we did not have another database to choose from i will have to compare the database to spreadsheets, i must refer back to the actual task i am doing (i will be doing more queries than graphs etc).

Answer 1

It's about depth of development, semantics and a few other things.



A spreadsheet is a database. A list written on the back of a cigarette packet is a database.

Answer 2

As a general rule of thumb, databases should be used for data storage and spreadsheets should be used to analyze data.



If you currently use a spreadsheet to store data, ask yourself the following questions:



* Do changes made in one spreadsheet force you to make changes in others?

* Is the sheer amount of data unmanageable or becoming unmanageable?

* Do you have several spreadsheets that contain related information (such as separate sheets with sales for branches in Los Angeles, Chicago, and Houston)?

* Can you see all relevant data on one screen, or do you have to keep scrolling to find information?

* Are several people accessing the data at the same time?

* Do you have a difficult time viewing specific data sets that you want?



If you answered yes to at least two of the questions, you should think about moving your information to a database application.



In a Nutshell Use a database if...



* the information is a large amount that would become unmanageable in spreadsheet form and is related to a particular subject.

* you want to maintain records for ongoing use.

* the information is subject to many changes (change of address, pricing changes, etc.).

* you want to generate reports based on the information.



Use a spreadsheet if...



* you want to crunch numbers and perform automatic calculations.

* you want to track a simple list of data.

* you want to easily create charts and graphs of your data.

* you want to create "What-if" scenarios.



In most cases, using the combination of a database to store your business records and a spreadsheet to analyze selected information works best.

Answer 3

you will desire to in effortless terms be on the database in case you have been arrested. in the adventure that your got here upon no longer responsible and are released you tips would desire to be deleted, it may well be impractical to have definitely everyone on the documents base, and the quest against criminal DNA profiles might take longer in case you have universal regulation abiding in the documents base. I’m no longer a posed to the DNA database, and that i think of it’s an invaluable gadget for learn yet you nonetheless want the appropriate option policing. in case you have been got here upon responsible you will desire to be on the database for existence. If definitely everyone grow to be on the database from delivery you wouldn’t would desire to waste money on id taking part in cards via fact the state might already comprehend who your are, additionally those those that say the state would be staring at you 24/7 and comprehend the place you're and what your doing, have they in no way heard of a passport this is scanned whenever you bypass out of the country. If the government is going to hold such tips, you will desire to evaluate no longer in effortless terms British nationals, yet what approximately immigrants. If the immigration place of work couldn’t optimistically perceive a individual, they might desire to be placed and the documents collectively as in the united kingdom, and whilst the leave or return homestead they might desire to be bumped off. What a rant... it would not infringe on your rights as long via fact the customary public can see what happening and the way issues artwork. in comparison to MP's expenditures! lol