Microsoft Access Database: Next Generation of Spreadsheets

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.

Microsoft Access Database Next Generation of Spreadsheets

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”

Microsoft Access Database Functions

Microsoft Access Database Functions

This is something I have touched on briefly in the past with an article called Microsoft Access Functions which introduced you to the popular functions and the tool to generally browse for other not so popular function calls.

So as a revisit to this topic, there’s no point describing each and everyone that’s at your disposal – that would be silly as we all have different uses for our Access databases but instead you can find a full list (by category) by going to Microsoft’s Office Access Functions (by category) page instead.

microsoft access database functions office

Microsoft Access Database Functions

It clearly states that this page contains links to articles that provide details about common functions used in expressions in Microsoft Access.

They are arranged first by Continue reading “Microsoft Access Database Functions”