0
One should always chose the right tool for the job.
A spreadsheet is designed to re-compute all cells (at least all cells within visibility and those referenced by others) each and every time anything changed which could affect the outcome of these calculations. This makes very complex spreadsheets, or those carrying a vast amount of data, difficult to manage and slow to work with, as the computation time increases.
On the other hand, database applications are designed to handle vast amounts of data safely and reliably, and provide tools to quickly retrieve data. Most database query languages also support tools for statistical or similar predicates, allowing for search expressions with a complexity akin to that used in some spreadsheets.
Wiki User
∙ 11y ago
Add your answer:
Earn +20 pts
What function a spreadsheet have to help organize data?
Spreadsheets have many functions to help organise data. Organising data is one of the purposes of a spreadsheet, particulary if it is a lot of numerical data. If it is things like names, address etc., a database can be better. Spreadsheets can do things like sort data and extract data. They can lay data out in a tabular format using the rows and columns in the spreadsheet. There are some specific database functions that can be used in a spreadsheet that are used for organising data.
Computer program to keep track of a lot of data?
The answer to your question is Spreadsheet.
Are statistics use in a financial spreadsheet?
Yes. Statistics and statistical functions would indeed be used in a financial spreadsheet. A lot of financial data is statistical.
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.
Is Microsoft access a database or a spreadsheet?
No it is not. However, there are a lot of things that both a database and a spreadsheet can do, so Access does have some capabilities to do what a spreadsheet can. Spreadsheets focus on numeric analysis and manpulation, so mostly concentrate on numbers. Databases deal with processing lists of data, some of which would be numeric, but it works with a lot of other kinds of data. Microsoft Access is a database and that is what it is designed to be, so it is not a spreadsheet.
What question can be asked of a spreadsheet after it is creatted?
There are lots of them. The most important is are the formulas all correct? Other important things to ask would be:Has all the data been entered?Has all the data been entered correctly?Is the layout correct?Is all the data correctly formatted?Have all the formulas been tested?Is it clear what all the data means?Is it clear what all the formulas do?Are there proper labels and headings in the spreadsheet?Is it easy to change things in the spreadsheet without having to redo lots of the formulas?Can someone understand the purpose and results of the spreadsheet?Are any charts used correct?There are many other questions that could be asked too. The nature of the spreadsheet will determine a lot of them.
What is the XML database used for?
xml is used on webpages and web services and can also be used to create data bases and to store and carry data.
Why do we need spreadsheet software in businesses?
They improve data organization, ease collaboration and enable calculations with build-in formulas
Which of the following devices is popular because it is small portableand can store a lot of data?
hard drive
Is a computerized spreadsheet flexible for moving data?
If you lay out a spreadsheet well, then it is very easy to move things around. Spreadsheets are designed to allow you to move things easily. If it is badly laid out, then it is more difficult to do. So while a spreadsheet does allow you to move things easily the most important thing is that you lay it out properly to make it easier to change. How you do that will vary depending on the data you need and what your spreadsheet is designed to do. But if you lay things out clearly in columns and rows with good labels on the various items, it is a lot easier to change.
What type of data is access best at handling?
Databases are used to hold many kinds of data. You could not say that Access, or any other database, is best at handling any particular one. Commonly, text data is a regular data type used, such as in details about people. If you are doing a lot of calculations a spreadsheet may sometimes be better than a database for numbers, but a database can do lots of calculations too. Databases can store dates, logical values (Yes/No), pictures and so on. A database such as Access is designed to deal with data, so it is often what you want to do with that data that may influence how you store and process it and what application to use, rather than the data type itself.
How can you get a sunrise and sunset time table that includes seconds?
There's an awesome spreadsheet available the calculates that and a whole lot of other solar data. Search for "NOAA Solar Calculations Year".
