Future of MS Access
My post is a general post about which way should MS Access take in the future. I have used Access as a professional tool in my company against large and small companies from the early versions of Access. I believe that this is the most common use of Access although Microsoft from the beginning of the product have added this at the Office package as a low-threshold entry to the database worlds. Microsoft has reduced the availability of Access in its Office suites from early beginnings. In view of this, I mean Microsoft should let go of Access as part of Office package and develop a completely new "Access" software for the professionals.
The new “Access” is to be dedicated against the professional marked.
Having said this many will come up and ask why not use Visual Studio or other systems. To this, I reply that VS never built to a specific task as Access, but as a general toolbox that can handle an infinity of tasks.
What we need is a tool that is dedicated to the development of interfaces against professional databases ref MS Sql server and that only.
Microsoft could then develop from scratch a new professional tool without no boundaries to the old Access.
This software could contain of a desktop and a web version that could handle the future.
Thank you for sharing your thoughts with us.
Have you heard about the MS Access input mask feature, I find it very helpful as by using this you can help users to enter data correctly into your database by assigning input masks for the field which contain data that is always formatted in certain ways. Wants to know how to use this? For this just have a look to this post:
As i see it Microsoft has a tendency to develop their application by the head of there developers instead of the users. This meaning the software developers always have a tendency to develop the software form a "nice to have " point of view" instead of the 90% usage of the software.
This often result in too complicated software from a users view.
Google has gone the other way let the user experience the 90 % need and then put the 10 % in the background that resulting in better user experience.
In a new Access Microsoft would have had the chance to change this.
Build a web based database
- Have and online Microsoft account
- Design your table
- Create the web page for edit / search
- Open it for the given users
This without having any database or web background
The 10% functionality that we professional users use is implemented as part of the system in the background.
Interesting idea. Kind of like the new Power BI is a standalone product.