answersLogoWhite

0


Best Answer

The answer to this depends on the exercise being undertaken A spreadsheet tends to be used where values change. A datebase tends to be used to store unchanging records.

User Avatar

Wiki User

15y ago
This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: Why is a database more appropriate than a spreadsheet?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

What are vertical blocks of data in a spreadsheet?

They can be called fields, but that is more the case in a database than in a spreadsheet.


What do you call horizontal blocks of data in a spreadsheet?

They can be called records, but that is more the case in a database than in a spreadsheet.


What do you call horizontal blocks of data in a spreadsheet called?

They can be called records, but that is more the case in a database than in a spreadsheet.


What is a field in excel?

A field is more a database term than a spreadsheet term. In a spreadsheet a field can refer to a column of data that is of the same type, like all numbers or all dates or birth or all home addresses etc. This would be in a case where your spreadsheet is laid out similar to a database table.


Why would you copy a table from access and paste it as a link in Excel?

It is possible to share data between different applications. It is often better to do some kinds of processing work in one application than another. So if you had data in a database that you wanted to do a lot of calculations on, and also keep up to date with what is in the database, then you could put a link into the spreadsheet. The spreadsheet can then do its calculations and if anything changes in the database, then those changed will be recognised in the spreadsheet. That way you would not have to keep copying data across to Excel from Access.It is possible to share data between different applications. It is often better to do some kinds of processing work in one application than another. So if you had data in a database that you wanted to do a lot of calculations on, and also keep up to date with what is in the database, then you could put a link into the spreadsheet. The spreadsheet can then do its calculations and if anything changes in the database, then those changed will be recognised in the spreadsheet. That way you would not have to keep copying data across to Excel from Access.It is possible to share data between different applications. It is often better to do some kinds of processing work in one application than another. So if you had data in a database that you wanted to do a lot of calculations on, and also keep up to date with what is in the database, then you could put a link into the spreadsheet. The spreadsheet can then do its calculations and if anything changes in the database, then those changed will be recognised in the spreadsheet. That way you would not have to keep copying data across to Excel from Access.It is possible to share data between different applications. It is often better to do some kinds of processing work in one application than another. So if you had data in a database that you wanted to do a lot of calculations on, and also keep up to date with what is in the database, then you could put a link into the spreadsheet. The spreadsheet can then do its calculations and if anything changes in the database, then those changed will be recognised in the spreadsheet. That way you would not have to keep copying data across to Excel from Access.It is possible to share data between different applications. It is often better to do some kinds of processing work in one application than another. So if you had data in a database that you wanted to do a lot of calculations on, and also keep up to date with what is in the database, then you could put a link into the spreadsheet. The spreadsheet can then do its calculations and if anything changes in the database, then those changed will be recognised in the spreadsheet. That way you would not have to keep copying data across to Excel from Access.It is possible to share data between different applications. It is often better to do some kinds of processing work in one application than another. So if you had data in a database that you wanted to do a lot of calculations on, and also keep up to date with what is in the database, then you could put a link into the spreadsheet. The spreadsheet can then do its calculations and if anything changes in the database, then those changed will be recognised in the spreadsheet. That way you would not have to keep copying data across to Excel from Access.It is possible to share data between different applications. It is often better to do some kinds of processing work in one application than another. So if you had data in a database that you wanted to do a lot of calculations on, and also keep up to date with what is in the database, then you could put a link into the spreadsheet. The spreadsheet can then do its calculations and if anything changes in the database, then those changed will be recognised in the spreadsheet. That way you would not have to keep copying data across to Excel from Access.It is possible to share data between different applications. It is often better to do some kinds of processing work in one application than another. So if you had data in a database that you wanted to do a lot of calculations on, and also keep up to date with what is in the database, then you could put a link into the spreadsheet. The spreadsheet can then do its calculations and if anything changes in the database, then those changed will be recognised in the spreadsheet. That way you would not have to keep copying data across to Excel from Access.It is possible to share data between different applications. It is often better to do some kinds of processing work in one application than another. So if you had data in a database that you wanted to do a lot of calculations on, and also keep up to date with what is in the database, then you could put a link into the spreadsheet. The spreadsheet can then do its calculations and if anything changes in the database, then those changed will be recognised in the spreadsheet. That way you would not have to keep copying data across to Excel from Access.It is possible to share data between different applications. It is often better to do some kinds of processing work in one application than another. So if you had data in a database that you wanted to do a lot of calculations on, and also keep up to date with what is in the database, then you could put a link into the spreadsheet. The spreadsheet can then do its calculations and if anything changes in the database, then those changed will be recognised in the spreadsheet. That way you would not have to keep copying data across to Excel from Access.It is possible to share data between different applications. It is often better to do some kinds of processing work in one application than another. So if you had data in a database that you wanted to do a lot of calculations on, and also keep up to date with what is in the database, then you could put a link into the spreadsheet. The spreadsheet can then do its calculations and if anything changes in the database, then those changed will be recognised in the spreadsheet. That way you would not have to keep copying data across to Excel from Access.


What is more smallest a column or a row?

There are less cells in a spreadsheet row than in a spreadsheet column.There are less cells in a spreadsheet row than in a spreadsheet column.There are less cells in a spreadsheet row than in a spreadsheet column.There are less cells in a spreadsheet row than in a spreadsheet column.There are less cells in a spreadsheet row than in a spreadsheet column.There are less cells in a spreadsheet row than in a spreadsheet column.There are less cells in a spreadsheet row than in a spreadsheet column.There are less cells in a spreadsheet row than in a spreadsheet column.There are less cells in a spreadsheet row than in a spreadsheet column.There are less cells in a spreadsheet row than in a spreadsheet column.There are less cells in a spreadsheet row than in a spreadsheet column.


What is a file on a database?

More than one record in a Database


Why Databases might be better than word processor documents and Spreadsheet documents for the job that they do?

Each are designed for different types of jobs, so you cannot really compare them. All have the capabilities to do things that the others can do, but each is specially designed to do a particular job. If you wanted to create a database you could do it in a word processor or a spreadsheet. However, neither will give you the full facilities to do databasing operations that you would have if you actually used a database application. Some things could be done, but would be more difficult to do in the other applications. If you want to set up a complex database, then you would use a database application, just like if you wanted to do a letter you would use a word processor or if you wanted to create a spreadsheet you would use a spreadsheet application.Each are designed for different types of jobs, so you cannot really compare them. All have the capabilities to do things that the others can do, but each is specially designed to do a particular job. If you wanted to create a database you could do it in a word processor or a spreadsheet. However, neither will give you the full facilities to do databasing operations that you would have if you actually used a database application. Some things could be done, but would be more difficult to do in the other applications. If you want to set up a complex database, then you would use a database application, just like if you wanted to do a letter you would use a word processor or if you wanted to create a spreadsheet you would use a spreadsheet application.Each are designed for different types of jobs, so you cannot really compare them. All have the capabilities to do things that the others can do, but each is specially designed to do a particular job. If you wanted to create a database you could do it in a word processor or a spreadsheet. However, neither will give you the full facilities to do databasing operations that you would have if you actually used a database application. Some things could be done, but would be more difficult to do in the other applications. If you want to set up a complex database, then you would use a database application, just like if you wanted to do a letter you would use a word processor or if you wanted to create a spreadsheet you would use a spreadsheet application.Each are designed for different types of jobs, so you cannot really compare them. All have the capabilities to do things that the others can do, but each is specially designed to do a particular job. If you wanted to create a database you could do it in a word processor or a spreadsheet. However, neither will give you the full facilities to do databasing operations that you would have if you actually used a database application. Some things could be done, but would be more difficult to do in the other applications. If you want to set up a complex database, then you would use a database application, just like if you wanted to do a letter you would use a word processor or if you wanted to create a spreadsheet you would use a spreadsheet application.Each are designed for different types of jobs, so you cannot really compare them. All have the capabilities to do things that the others can do, but each is specially designed to do a particular job. If you wanted to create a database you could do it in a word processor or a spreadsheet. However, neither will give you the full facilities to do databasing operations that you would have if you actually used a database application. Some things could be done, but would be more difficult to do in the other applications. If you want to set up a complex database, then you would use a database application, just like if you wanted to do a letter you would use a word processor or if you wanted to create a spreadsheet you would use a spreadsheet application.Each are designed for different types of jobs, so you cannot really compare them. All have the capabilities to do things that the others can do, but each is specially designed to do a particular job. If you wanted to create a database you could do it in a word processor or a spreadsheet. However, neither will give you the full facilities to do databasing operations that you would have if you actually used a database application. Some things could be done, but would be more difficult to do in the other applications. If you want to set up a complex database, then you would use a database application, just like if you wanted to do a letter you would use a word processor or if you wanted to create a spreadsheet you would use a spreadsheet application.Each are designed for different types of jobs, so you cannot really compare them. All have the capabilities to do things that the others can do, but each is specially designed to do a particular job. If you wanted to create a database you could do it in a word processor or a spreadsheet. However, neither will give you the full facilities to do databasing operations that you would have if you actually used a database application. Some things could be done, but would be more difficult to do in the other applications. If you want to set up a complex database, then you would use a database application, just like if you wanted to do a letter you would use a word processor or if you wanted to create a spreadsheet you would use a spreadsheet application.Each are designed for different types of jobs, so you cannot really compare them. All have the capabilities to do things that the others can do, but each is specially designed to do a particular job. If you wanted to create a database you could do it in a word processor or a spreadsheet. However, neither will give you the full facilities to do databasing operations that you would have if you actually used a database application. Some things could be done, but would be more difficult to do in the other applications. If you want to set up a complex database, then you would use a database application, just like if you wanted to do a letter you would use a word processor or if you wanted to create a spreadsheet you would use a spreadsheet application.Each are designed for different types of jobs, so you cannot really compare them. All have the capabilities to do things that the others can do, but each is specially designed to do a particular job. If you wanted to create a database you could do it in a word processor or a spreadsheet. However, neither will give you the full facilities to do databasing operations that you would have if you actually used a database application. Some things could be done, but would be more difficult to do in the other applications. If you want to set up a complex database, then you would use a database application, just like if you wanted to do a letter you would use a word processor or if you wanted to create a spreadsheet you would use a spreadsheet application.Each are designed for different types of jobs, so you cannot really compare them. All have the capabilities to do things that the others can do, but each is specially designed to do a particular job. If you wanted to create a database you could do it in a word processor or a spreadsheet. However, neither will give you the full facilities to do databasing operations that you would have if you actually used a database application. Some things could be done, but would be more difficult to do in the other applications. If you want to set up a complex database, then you would use a database application, just like if you wanted to do a letter you would use a word processor or if you wanted to create a spreadsheet you would use a spreadsheet application.Each are designed for different types of jobs, so you cannot really compare them. All have the capabilities to do things that the others can do, but each is specially designed to do a particular job. If you wanted to create a database you could do it in a word processor or a spreadsheet. However, neither will give you the full facilities to do databasing operations that you would have if you actually used a database application. Some things could be done, but would be more difficult to do in the other applications. If you want to set up a complex database, then you would use a database application, just like if you wanted to do a letter you would use a word processor or if you wanted to create a spreadsheet you would use a spreadsheet application.


What is the difference between databases and spreadsheets?

Databases are designed for storing and managing large amounts of structured data, offering features like data validation, relationships between tables, and querying capabilities. Spreadsheets, on the other hand, are more suited for smaller datasets and are commonly used for analysis, calculations, and creating visual representations of data. Databases are more scalable, secure, and efficient for handling complex data compared to spreadsheets.


When using spreadsheet software like that in the accompanying figure each worksheet can have more than?

When using spreadsheet software like that in the accompanying figure, each worksheet can have more than ____ cells


Which is better a spreadsheet or a database?

A database is the storing of information (such as on your hard drive or disk), while a spreadsheet is used for accounting, or keeping track of expenditures or other items or projects with a numerical value. A spreadsheet can also be stored on your computer or on hard copy (printed on paper). 1.A spreadsheet is an application for tabulating data while a database is where data is stored so that it can be retrieved by users 2.The amount of data that is usually stored in a database is way more than what is contained in a spreadsheet 3.A spreadsheet is edited directly by people while a database is accessed by applications that enter and modify data 4.A spreadsheet is usually used for presentations and paperworks while databases are commonly used in cases where a lot of data needs to stored. Read more: Difference Between Spreadsheet and Database | Difference Between in the related link below.


When using spreadsheet software like that in the accompanying figure each worksheet can have more than cells?

When using spreadsheet software like that in the accompanying figure, each worksheet can have more than ____ cells