Microsoft Access Database: Next Generation of Spreadsheets
Bringing your Microsoft Access database application into the current online digital age started with the need for this integral tool for small and medium sized businesses way back in the 1990’s.
WordPerfect, Lotus 1–2–3, and dBase are the three software products that dominated the software market for a long period in the history of personal computing. WordPerfect is used for word processing; Lotus 1–2–3 is a spreadsheet program from Lotus Software; and dBase is a database management system for microcomputers.
During the early days of personal computing, spreadsheets and databases coexisted because there was a clear designation of responsibility between the two models. During those times, the use of spreadsheets were mainly for financial modelling. While databases were intended for everything organization-related.
Spreadsheets and word processors offered the benefits of simplicity and direct manipulability. Databases were never as manageable as word processors and spreadsheets. The main drawback in using databases was in the technical implementation complexity of the software.
As a result, average users began using spreadsheets as provisional databases.
After many consultations with dozens of Excel clients, it became clear that almost all of them were using the product not for the purpose of financial modelling but as a conventional tool for making tables instead.
At this point in time, the office productivity perspective had also shifted from a multiplayer market to one subjugated by Microsoft, which put down Lotus 1–2–3 and dBase with its own Excel and Access database products. The growing grey area between spreadsheets and databases gave Continue reading “Microsoft Access Database: Next Generation of Spreadsheets”