Back in 1994 when we were writing database application on DOS operating system using Clipper language, users clamor for a better user interface, a windows interface, where they could use the mouse instead of a keyboard to execute a task, Microsoft Access was the nearest substitute, and the rest was history.
Microsoft Access provides all the necessary tools for us to build database application without having to code our buttons, menus and other piping task a developer would normally write. In effect, as a software developer, we are more focus on the business logic and functional requirements of the users, the result was that the users and functional experts, e.g, accountants, doctors sometimes becomes the developer. And for the past 18 years I could not count how many applications we installed and deployed using Microsoft Access.
Now in the advent of wireless technology and the proliferation of the Internet through cellphones/smartphones and tablets/pads users demands that their application should be ubiquitous. In fact every time we sell a Human Resource System, they demanded an on-line leave application, etc., etc., every time we sell a Warehouse System, they demanded an online view of the inventory, etc. etc.. In other words the users now clamor for a new and better user interface. Microsoft Access database application has yet to adapt.
The answer may lies in Microsoft Lightswitch. Microsoft Lightswitch is similar to Microsoft Access in terms of removing the piping task from the developer. The main difference is the data connectivity and query. Microsoft Lightswitch uses Entity Framework, a light weight data connectivity and converts the tables in your database to a class, in effect removing the developers ability to query and warp the data directly using SQL syntax. SQL is the key why non developers were so successful making database application using Microsoft Access.
The replacement of SQL is LINQ. To tell you honestly I am new to LINQ and I find it more easy to create and cleaner to maintain than SQL. It is just basically a paradigm shift and change of ways of thinking.
With this I can conclude that Microsoft Access = Microsoft Lightswitch + LINQ = ubiquitous database application = the future. Furthermore, Microsoft is changing its user interface paradigm, from mouse to hand.