For a long time, we used Microsoft Access [for] many [in-house] applications from engineering requests to IT Assets[,] etc. Over time, we migrated many of [these applications] to MS SQL server or the cloud. However, we continue to use MS Access with ODCB Data as MS Access provide[s] a quick way to build fully functional applications with the least amount of effort.
Pros
Quickly build forms and reports
Easy user interface with familiar tools
Least amount of programming
Cons
Multi-user support
Useful features are often removed from newer versions
Likelihood to Recommend
Simple applications that do not require [a] huge amount of data storage.
VU
Verified User
Executive in Information Technology (Mining & Metals company, 51-200 employees)
I started my responsibilities in this present company with my work on Microsoft Access. We use it as a database tool, to store all the project information, and sorted into different categories. Someone has done the set-up earlier, and I was the one to load all the information into Access over the past years from 2000 to 2015. It is updated every once in a while, and everyone in the company, use it as a reference database.
Pros
Stores vast amount of data
Filtering, sorting is easy
Copying to excel without losing any format is a plus
Cons
It can be made more User-friendly
Some help tutorials will help to elaborate on all features
Likelihood to Recommend
It is a very good database tool, to store a vast amount of data in one place. Easier to input information. Can be easily copied to a spreadsheet. If the information you save is of quite different categories, then one Microsoft Access file may not fit for your purpose. You may need multiple files, or add all required fields, and hide/un-hide relevant fields or columns as needed
VU
Verified User
Analyst in Marketing (Oil & Energy company, 51-200 employees)