Best in Business, Microsoft Access!
June 28, 2021

Best in Business, Microsoft Access!

Rounak Verma | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User

Overall Satisfaction with Microsoft Access

Having worked as a Data Analyst at a reputed retail company, Microsoft Access was one of the major tools that were used for database design, creating entity-relationship diagrams, creating mock layouts of the data schema, and writing queries to retrieve data. At the moment, Microsoft Access was being widely used across the organization. The main reason for using Microsoft Access was its usability and its usual Microsoft user interface that made it easier for nontechnical folks to write queries as well.
  • Very easy to create entity-relationship diagrams for various tables and designing mock layouts.
  • Really easy to navigate as it hold[s] the classic Microsoft UI. Another good thing is that it comes with the complete MS Office Suite.
  • It is really fast when joining multiple tables no matter what type of join.
  • Works on pretty much same SQL scripts so no need to learn a new language!
  • Need to backup very frequently, I have lost my work many times.
  • No version for Mac users, [I believe this is a] big limitation.
  • The ability to handle large database and multiple users.
  • UI is easy to use but [I feel it] can be improved a lot.
  • The ability to create ER diagrams easily.
  • Easy to use classic Microsoft user interface makes it easier to use for folks with little technical knowhow.
  • Very low cost and pocket friendly to use.
  • Microsoft Access is very low in cost as compared to its competitors and provides value for money spent.
  • Comes with Office Suite for your whole organization. Easy to install and use.
  • Many people had to shift to Windows in order to use those as there is no Mac version.
Having used Snowflake, I can definitely say that both of these tools are very easy to use and value for money. Although for me, the aspects where Microsoft Access stacks up are its low cost and usability. Snowflake is good with its cloud-based system but for startups where the need for creating and designing a database at as low cost as possible is a crucial deal, Microsoft Access is the best in business. Also, it is included in the Microsoft Office Suite along with other office solutions which provide a one-point solution to many problems.

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?

Yes

Did implementation of Microsoft Access go as expected?

Yes

Would you buy Microsoft Access again?

Yes

Having worked at startups, I can say Microsoft Access is most suited for their needs. Some of the reasons for that can be the ease and ability to create tables, design an entity-relationship diagram, define the relationship between different tables, feeding data into the tables, and retrieving data. All of this can be curated very easily into a process for small to medium-size enterprises. But a serious limitation can be observed where Access does not provide better features for large-scale companies. Another limitation is for companies where Mac is used as work computers.