Microsoft Access

We currently utilize Microsoft Access for data capture and analysis purposes. The application allows us to aggregate various reports into one high level report, which represents the true needs of the data. We've created automation within the application, as well as easy to use interfaces to allow non-tech associates the ability to create reports.

Without being too specific:
Account Management
Space Management
Contract Personnel
Budgeting
Asset Management

*General usage. I use it for various purposes. Organizing server logs, creating historical reporting, data collection, etc...I work for [government] contracts, and Access is widely used, not only by the [governant] but internally by our company.

Problems are more hearsay than reality. Often people speak badly about the product, yet turn to me to either build or support.

I am the only one at my organization who uses MS Access. I export information from multiple platforms and import it into Access to generate reports and statistical data.

We use MS Access for databases such as company-wide skill sets and certifications that we then link to our internal social media platform (Jive), in order to publicly display this information company-wide so that if a person is looking for someone with a particular skill set, they are easily able to identify who might have it.

Whether I am creating an entirely new database through sql or in the design view, MS Access is a great option. Creating queries, macros, and forms are all a possibility when using MS Access to find the right information for small companies or institutions. It makes life much easier than some of the other database creation tools and is relatively cost-effective.