Microsoft Access: The Real World
January 15, 2019
Microsoft Access: The Real World
Score 10 out of 10
Vetted Review
Verified User
Overall Satisfaction with Microsoft Access
Microsoft Access is being used as a personal database in a couple of departments in our organization. It is being used to import data from other data sources in our organization. We are able to use data in an excel spreadsheet as well as text files. It has addressed the problem of being able to report on data without having to use a real business intelligence solution.
Pros
- Cross tab reports. Allows a different look at the data.
- Joins. Allows left, right as well as inner and outer joins.
- Simple reports. Having the capability to run simple reports.
Cons
- Graphical look. Having a more graphical user-friendly interface.
- Ad-hoc reporting. It is a stretch but is would be nice.
- Cross platform connections
- Positive Impact. It gives some of the users their own personal database.
- Another Positive Impact. The user learns some of the database development without having to be certified in a particular software.
- Negative Impact. Not a real business object solution to me.
It stacks up well to Crystal Reporting because it does give you a more generic feel of having a real business object solution. We selected Microsoft Access because it is intuitive enough for our end users and it does give them their own personal workspace to achieve their goal of data analytics.
Comments
Please log in to join the conversation