0
When should you consider creating database instead of spreadsheet?
Wiki User
∙ 9y agoWant this question answered?
Be notified when an answer is posted
Add your answer:
Earn +20 pts
Advantage of a chart over a spreadsheet?
Actually, within Excel you must have the spreadsheet prior to creating a chart. But, the advantage to creating the chart is that it gives the viewer more of a visual story of what is occurring, instead of just a list of data or numbers.
Why is it easier to use an electronic spreadsheet instead of pen and paper?
The spreadsheet automatically does all the math for you.
Why use Ms access to create databases and why not use Microsoft Excel?
Access is a database. Excel is a spreadsheet. Both are useful to displaying data systematically, but a database is enormously more flexible. Access is a relational database, which is even more flexible than an ordinary database and permits the data to be manipulated in many ways. +++ It's not "instead of" but "both" - using whichever is the better for the given work. ' It does depend on your purposes. Excel is by far the better if you need only a single table, or if you need to embed a lot of mathematical formulae in the spread-sheet - though MS has ruined what had been its nearly-good graph routines. A database table looks like a spread-sheet page, but it lacks the rapid copying functions that are valuable features in Excel.
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.
What are the Other database types instead of oracle?
MsSqlServer
What is a spreadsheet is often called?
It can be called a worksheet. There is a range of actual spreadsheet programs, so people often refer to them directly, like Excel or Quattro or Works or Open Office or Lotus 123, instead of using the term spreadsheet.
What is database softwaer?
The correct spelling is database software instead of database softwear. Database software is a utility or software program. It is used to make databases and manage and edit the information that is kept in them.
What happens if a label is too long for a cell in a spreadsheet?
If labels are longer than the column width allowed, the spreadsheet does not "lose" the extra characters; instead they are not displayed if the cell to their right has an entry.
What is multi dimensional spreadsheet?
A multi-dimensional spreadsheet is one that utilizes models built on objects called variables instead of data in the cells of a report. This was created in the late 1980's.
What is a multi dimensional spreadsheet?
A multi-dimensional spreadsheet is one that utilizes models built on objects called variables instead of data in the cells of a report. This was created in the late 1980's.
When users modify data in a database using the database approach they must make changes to all files instead of just one file?
False
Where could one find a database of Broadway shows?
IBDB is the Internet Broadway Database. This site is precisely the same as IMDB (Internet Movie Database), except IBDB is for Broadway Shows instead of movies.
