Overall Satisfaction with Microsoft Access
Access is used for reporting and analysis. It is used by individual departments. Access helps track special projects and allows in depth analysis and reporting production. Flexibility to view data in multiple formats. The ability to use modules and macros to auto processes and export of data is very helpful and reduces labor.
- Report creation and exporting into multiple formats. You can export into Excel, Word and PDF files. This allows you to present the data in manner to best fit the users needs
- The ability to automate processes allows reductions of labor and missing that important publication or data run. If people require data at a set time you can set up Access to import and export at scheduled times. There is no need to have someone available to hit the start buttons.
- You have the ability to work with web applications if people have issues with using Access on a local terminal. You can also use split databases to protect the back end data as well add ease of use for the end user.
- I would like to see more flexibility in the creation of cross tab or pivot data.
- If you are not familiar with writing code to create modules you lose a lot of the power of the program. Macros are nice but a module with code allows much more flexibility.
- The program can help reduce labor in data gathering and report production.
Access was the best suited program for what was needed. It provided the flexibility and functionality the made the jobs easier. I use Access personally for home inventory and other data such as warranty tracking. Access to me is much easier to use than other programs I have looked at. It is easy to use and very adaptable.
What is the source data? How do you need to present the data? Will there be multiple users? Will the data presentation change on a regular basis? Do the users have any knowledge of Access? If the user has limited knowledge that will determine the design of the user interface. If you need security and are not a network admin the security can be a challenge.