Microsoft Access is a database management system from Microsoft that combines the relational Microsoft Jet Database Engine with a graphical user interface and software-development tools. It is a member of the Microsoft Office suite of applications, included in the Professional and higher editions or sold separately.
Today powerful database server software is available as open source and can be downloaded for free. Microsoft has SQL Server Express Edition, also a free download, which can be used for small projects. More powerful versions of SQL Server are still within reach for most projects budgets and a licensed SQL Server may already be installed on site and be accessible.
So why use MS Access these days?
New call-to-action
The Business Case for Access
The reason for using Access is that it quickly fulfills business needs for many types of small-scale database solutions. It is a highly productive tool; therefore useful results can quickly be produced that help your business.
Many of our clients like using Access. They feel comfortable with the product, project budget, and control of the application.
Unlike most other databases, Access is also a GUI toolkit. It comes with everything you need to build databases that are suitable for a small business, department, workgroup, or series of projects. GUI Toolkit
MS Access includes:
the database
table builder
query builder
form builder
report builder
macro writer
VBA programming language
An MS Access database solution does not require special hardware, server operating system, or custom application software environments. Although sometimes thought of a single user database, it actually works well with multiple concurrent users (but it is best to keep it to < 10). Access can also be used as a front-end to a more powerful database, such as SQL Server or other ODBC databases. The result is that even a complex application can be built within reach of most application project budgets, and simple databases can be put together as an add-on to a control systems project.
Portable and Flexible
One feature that many users like is the ease of portability. No, not portability as in it can be used on a Mac or in Linux, but in the sense it is easy to move or copy, much like an Excel file. Since an Access application can be in one file (but does not to have to be) it is easy to copy the database for other uses, such as a new project or to replicate to other locations. IT personnel may wince at this capability, but users generally like this feature since it allows for great flexibility.
Many users appreciate that once they get to work with Access, they can understand it, and is very flexible. It is relatively easy to make changes to adjust it to their changing business needs.
Microsoft Northwind Traders example databaseTraders Example Database
Longevity
MS Access has been around for over 25 years. Although Microsoft has not been improving the product much over the past 10 years, predictions of its demise have been greatly exaggerated. According to db-engines.com it remains the sixth most popular relational database. I continue to support many installed Access databases at customer sites and they continue to function for their intended purpose.