Non technical data analysts add power to their toolbelts.
December 22, 2014

Non technical data analysts add power to their toolbelts.

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

Software Version

2010 V.14 (32-bit)

Overall Satisfaction with Microsoft Access

As a Data Analyst, my department uses Access for ad hoc analysis, business process automation and recurring reporting. It is used by line of business analysts when a technology budget is not approved and a non IT developed/supported application is an option. Typically this would only be used for single user/departmental solutions to reduce single point of failure analytics.
  • Provides user friendly interface (Microsoft standards).
  • Provide wizard/step by step guides.
  • Does not require a high technical level skill set.
  • Does not handle large data sets particularly well.
  • Does not use standard SQL syntax.
  • Requires much customization for complex workflows.
  • Increased employee efficiency.
  • Availability to provide "Just In Time" analytics for decision support.
  • Decreased dependency on technology resources.
No other evaluates - this is used as it is bundled with MS Office Professional and there is no additional licensing cost.
Microsoft Access is a tool in our standardized toolbox and bares little cost.
  • Standalone projects analyzing single data set.
  • Integration with Microsoft Products (Excel, etc.)
  • To automate basic business processes.