Access - Great for Databases that don't come with a built-in report writer
Overall Satisfaction with Microsoft Access
I use Access to track project timelines, record business expenses, and to manage our client database. For my clients, I use Access to build reports that are not currently built-in to the various Learning Management Systems (LMS) that I support - having the ability to locate records, find missing or inaccurate data, and run reports that combine various tables of information from the LMS' makes Access an invaluable resource for me.
Pros
- Easy to navigate interface for building forms.
- Easy to navigate switchboards for clients using the data on the front end.
- Direct links to Excel, both importing and exporting data with ease.
Cons
- The report writer could be more graphic, more Word-like.
- The switchboard features could include design options to make the front end of the database look more professional and current.
- Tutorials and how-to's could be improved and made more current (YouTube-like).
- Makes it easy for me to keep track of deliverables.
- Makes it easy for me to report Profit and Loss Statements.
- Makes it easy for me to keep a customer relations database at my fingertips so that I can document calls, interactions, and projects under one database.
I hadn't considered other options - I used to use FileMaker (a long time ago) and since I'm no longer a Mac user, Access was a natural fit. I don't use, nor can I recommend a competitor product.


Comments
Please log in to join the conversation