Good Data Management Tool
January 30, 2018

Good Data Management Tool

Anonymous | TrustRadius Reviewer
Score 7 out of 10
Vetted Review
Verified User

Overall Satisfaction with Microsoft Access

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
  • It was a time-consuming activity, we had to invest a lot of time. But after once it is done, it is there forever.
  • All our Engineers use this reference data time to time, and it is a good ROI
  • Our investment is mainly time.
Microsoft Access is a good data management tool. and it excels in that area, which is what we needed the most. It was simple to use and easy to learn. Database management can be done with multiple users in Access. And we can have reports for data summaries, or for any specific purpose.
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

Using Microsoft Access

Microsoft Access is easy to use. It is compatible with spreadsheets. It is a very good data management tool. There is scope to save a large amount of data in one place. For using this database, one does not need much training, can be shared among multiple users. This database has to sort and filtering features which seem to be very useful.
ProsCons
Like to use
Relatively simple
Easy to use
Technical support not required
Consistent
Quick to learn
Convenient
Feel confident using
Familiar
None
  • Data Entry
  • Adding Fields or Columns
  • Adding another Sheet
  • Using the database for different categories of Products
  • Hiding and Un-hiding fields was not difficult but consumed time, when changing categories

Comments

More Reviews of Microsoft Access