Microsoft Access for Newbies
April 30, 2021
Microsoft Access for Newbies
Score 8 out of 10
Vetted Review
Verified User
Overall Satisfaction with Microsoft Access
Microsoft Access is available to all employees through our Enterprise subscription to Office 365. Access is extremely powerful and a life saver when it comes to working with data, but it can be a bit intimidating at first to get to know.
I was able to self-teach myself the basics of the program and was able to find another power-user of the program at my university to help answer specific questions I had come up about linking to data sources on campus.
Pros
- Matching/combining data from two or more sources. (I.e. data from a central student information system and information received from a department-made submission form
- Finding errors between two datasets
- Saving time when used properly instead of Microsoft Excel
Cons
- Generally high learning curve for new users. Especially if they are not comfortable with technology.
- Desktop only program; not available in web-format like other O365 products
- Fewer experienced users, means it's a lot of self-teaching and troubleshooting when you run into an issue
- Visual table linking
- I was not involved with the purchase decision, so I'm unable to answer this.
We've actually started to use both of these programs. There are pros and cons to both.
Microsoft Access is best for linking two sets of data that already have a common shared field (i.e. both sets of data include a student ID number, social security number, etc)
Airtable is best for collecting new data because it lives online and has a much lower learning curve. I've successfully trained more people to use Airtable than Access.
Microsoft Access is best for linking two sets of data that already have a common shared field (i.e. both sets of data include a student ID number, social security number, etc)
Airtable is best for collecting new data because it lives online and has a much lower learning curve. I've successfully trained more people to use Airtable than Access.
Do you think Microsoft Access delivers good value for the price?
Yes
Are you happy with Microsoft Access's feature set?
Yes
Did Microsoft Access live up to sales and marketing promises?
I wasn't involved with the selection/purchase process
Did implementation of Microsoft Access go as expected?
I wasn't involved with the implementation phase
Would you buy Microsoft Access again?
Yes
Comments
Please log in to join the conversation