Access for Everyone!
January 08, 2019

Access for Everyone!

Lukas Sundahl, MBA | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User

Overall Satisfaction with Microsoft Access

Microsoft Access is being used to run a wide variety of reports for both operations and accounting. There are numerous queries that have been set to help managers get data up to production and plant efficiency. It helps managers quickly analyze performance on the numerous jobs that are going on at one time.
  • Since Microsoft Access is a Microsoft product it is easy to use and relay data to and from Excel.
  • With the tools inside Microsoft Access, you can quickly establish the relationships between tables. It is easy to view the relationships between tables.
  • It is a robust tool that can handle large amounts of data without having to spend additional money on other reporting tools.
  • I would like to have within Microsoft Access a way to build dashboards without having to pull data into another program such as Excel.
  • I would like to see Microsoft Access with more filtering/shading tools to differentiate data.
  • It would be nice if it was a little easier to build report formats. Sometimes it is challenging getting boxes to line up and make the report better aesthetically.
  • Microsoft Access has had tremendous ROI because of the amount of data it can translate at minimal cost.
  • Access has helped streamline operation reporting since it has much more flexibility with large datasets when compared to Excel.
  • Using Microsoft Access has made the operation/accounting reporting more meaningful and helped cut down on time to prepare reports.
Overall, I feel that Microsoft Access stacks up well against the competitors. With Microsoft Access coming from Microsoft it has many qualities that people are already familiar with from using other tools, especially Excel. Microsoft Access comes with Office 365 and therefore eliminates a need to purchase another database tool. In addition, many people in the organization have a lot of experience with Microsoft Access making it the best choice.
It is well suited to build queries to pull meaningful data from various tables. It is very useful that you can visually build the relationships between tables. Access allows you to quickly copy existing queries and then modify them to get different views from the same data.