Early databases available for the PC market were simple two-dimensional solutions and were essentially designed as a record-keeping system. However, when computing power increased, the advent of the relational database became an affordable option. Applying the rules proposed by Edgar Codd, the Database Management System (DBMS) became a reality, with products such as dBase being widely implemented in the desktop market.
Size limitation : When a spreadsheet is first constructed and tested, the size tends to be small. However, as the spreadsheet grows with more and more data, it start slowing down, until it reaches that point where your feet go to sleep while you waiting for the re-calculation to finish.
Many spreadsheet applications nowadays have functionality above and beyond the traditional, offering a variety of charts, look-up tables, databases and more functionality than can be mentioned here.
When your spreadsheet start to hit its limits, what options are open to you? Perhaps the best option is to consider the conversion of your spreadsheet to a database solution. Relational databases became viable not too long after the spreadsheet was well-entrenched as the affordable and quick means of gathering data and performing calculations.
spreadsheet templates for small business
excel inventory templates