Please enable JavaScript.
Coggle requires JavaScript to display documents.
spreadsheets and databases advantages and disadvantges (spreadsheets…
spreadsheets and databases advantages and disadvantges
spreadsheets
spreadsheets are designed to store text and numerical data
graphs can be created to show the results on processing your data
the format for data can be set for example currency
modelling can be carried out
Absolute and relative cell referencing can be used
databases
databases are used to store and process
they allow the entry storage and edit of data
a database is stored in a table or tables these are files made up of records
a query can be used to find specific records
validation can be set for different fields
Disadvatge of databases
There can be a problem using two tables
Security procedure needed
You need to have knowledge of datbases
Disadvanrge of spreadsheets
A error in formula can impact the results
Inexperienced users find difficult to use
Take a long time to create