Don't be afraid to learn how Microsoft Access can help you compare and manipulate data!
July 03, 2014

Don't be afraid to learn how Microsoft Access can help you compare and manipulate data!

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

Software Version

Microsoft Access 2003 and 2010

Overall Satisfaction with Microsoft Access

I used Microsoft Access when I was a Litigation Support Analyst. We used the application to run queries to compare data load files for large databases that contained electronic discovery images. We also ran queries that detected issues and mistakes within the load files. Queries also helped to manipulate the data. Access performed tasks that were nearly impossible to do by hand.
  • Microsoft Access allows you to run queries to compare lists to see if they match or if there are differences between the lists. This task can be done very quickly. Microsoft Access has Wizard tools to walk you through the process for "novice" users.
  • If you need to manipulate data across multiple sources, it can be done relatively easily in Microsoft Access.
  • Microsoft Access lets you create and save queries and forms for use by all levels of users. You can create an interface that is user-friendly.
  • I would like to see more "wizards" and how-to features for users that may be intimidated by the product.
  • Microsoft Access helped us find issues with data.
  • We were able to troubleshoot issues quickly.
We tried to use Excel to manipulate data but it didn't have all the capabilities that Microsoft Access provided.
It's a tool like no other. Microsoft Access can do things that can't be done with other tools currently available, in my experience.
Data manipulation and reporting are the greatest strengths of Microsoft Access, in my opinion.