Furthermore, having the user as Solution Provider removed all of those communication problems arising from dealing with ‘techies’ who didn’t necessarily understand the business problem to be solved.
With a product like Microsoft EXCEL (the current market-leader), simple solutions can be produced very quickly and these can be ‘played with’ in the light of experience.
For the advanced user, there is a background programming language (Visual Basic for Applications) which can be used to make the spreadsheet do pretty-well anything you like.
How So? (I hear you ask)
It is also a simple matter to add new data fields without disruption of the existing data or functionality ─ another significant advantage over EXCEL.
Although data tables can be updated directly, this is usually done via ‘Forms’ which can precisely control what the user is allowed to do, as well as managing presentation of the data.