TrustRadius: an HG Insights company

Microsoft Access Reviews and Ratings

Rating: 7.5 out of 10
Score
7.5 out of 10

Community insights

TrustRadius Insights for Microsoft Access are summaries of user sentiment data from TrustRadius reviews and, when necessary, third party data sources.

Pros

Efficient Database Management: Users have praised the software for its ease of database system management, reporting, and analysis capabilities. Some reviewers found the reporting functionalities and data manipulation tools easy to use, requiring minimal training.

Enhanced User Experience: The graphical interface was highlighted as a key factor that improved user experience and made database management more efficient. Reviewers particularly liked the drag-and-drop components for designing forms and reports, eliminating the need for coding knowledge.

Customizability and Flexibility: Customizability was a key strength mentioned by users who emphasized the ease of creating entity-relationship diagrams and customizing forms and reports. Some users appreciated the software's flexibility in accommodating various business logic requirements and automation needs.

Reviews

103 Reviews

Access for Nonprofit Review

Rating: 7 out of 10
Incentivized

Use Cases and Deployment Scope

We use Microsoft Access to track employee information, organize employee data, and prepare employee communications. It provides a central system for tracking certain data when other tools are not as appropriate. It is a helpful tool for archiving and storing information and providing a reference point when employee questions arise.

Pros

  • Organization of data
  • Record keeping
  • Allows customization

Cons

  • Lack of updates
  • Periodic glitches in functionality
  • Producing printed materials

Likelihood to Recommend

Microsoft Access is well suited for most database related tasks in our nonprofit organization. It allows us to organize data and access the data for specific purposes, such as employee communication and tracking previous employees. It is not as well suited for tasks related to production of printed materials where flexibility is helpful.

Vetted Review
Microsoft Access
5 years of experience

Microsoft Access reliable cost-effective inventory management database

Rating: 8 out of 10
Incentivized

Use Cases and Deployment Scope

We use Microsoft Access as an inventory database for large-purchase orders of materials that we in turn convert (custom, based on customer needs/designs). Once a shipping container has been received and the material(s) tagged, they are entered into Microsoft Access with dimensions, lot/batch numbers and quantity. At this point, the primary users are our Sales team, Order Costing & Material handlers.

Pros

  • Once set up correctly, searching using personalized drop-downs
  • Remote accessibility
  • Ample room for comments/special requirements

Cons

  • Interface could be more user-friendly
  • Appearance could be updated
  • Ability to "step" back search parameters instead of needing to essentially "clear all"

Likelihood to Recommend

As a Material Purchasing/Planning/inventory tracking application, Microsoft Access serves its purpose well. It's presentation is clean, data entry is simple and the ability to customize search fields is welcome.

It does, however, come with some caveats; namely, when setting search filters and the need arises to back up a step or two, with Microsoft Access you have to reset, or "clear all", adding extra steps/time to a query.

Vetted Review
Microsoft Access
8 years of experience

Microsoft Access is great for mid-level data organization

Rating: 8 out of 10
Incentivized

Use Cases and Deployment Scope

Microsoft Access is a great tool to help our company organize data in a way that functions for us. It is a flexible program that allows us to create a database that is tailored to our specific needs.

Pros

  • Organize data
  • Flexibility to customize our data base

Cons

  • Can't expand to big due to lack of ability to grow

Likelihood to Recommend

Microsoft Access is great for small or mid sized businesses. It is an inexpensive way to organize and track your data. It doesn't function well on a large scale so I wouldn't recommend it for extensive amounts of data.

Vetted Review
Microsoft Access
7 years of experience

Microsoft Access is great for template integration. Not a reliable database.

Rating: 3 out of 10

Use Cases and Deployment Scope

I use Microsoft Access for database management, templates, printing name badges and recording tallies.

Pros

  • Keeping one type of data, mainly text
  • sorting alphabetically reliably from A to Z
  • Keeping data in one strict format such as phone numbers in (999) 999-999 configuration

Cons

  • In my experience, tallies in records tab don't update accurately to reflect changes in database. You need to save the Microsoft Access file first, then the app will update the changes in tally.
  • For me, file doesn't save reliably
  • In my experience, sharing the Microsoft Access file in a team can corrupt the file

Likelihood to Recommend

<div>Best suited for printing name badges and name tents from a database.</div><div>Decent for emergency need for database management.</div><div>Less appropriate for long-term use and record keeping.</div><div>Not great for team use, since file gets corrupted when shared in Dropbox and email.</div><div>Not compatible with sharing between devices with different version updates of the app.</div>

Vetted Review
Microsoft Access
5 years of experience

Great for small database work

Rating: 5 out of 10
Incentivized

Use Cases and Deployment Scope

Our organization uses Microsoft Access to create and manage databases based on our unique data sets. Access gives us the flexibility for different staff members to generate reports for their programming needs. We also have the option to view the database in different views. This is important since the level of technological competence differs for staff, so having the option to view data in different ways is more meaningful and helpful to staff.

Pros

  • Individual entry data points
  • Option for multiple individuals to access the database
  • Ability to view data in different views

Cons

  • Speed of functionality decreases as size of database increases
  • Complex programming sometimes take a long time to run
  • Both good and bad, all data is in a single file

Likelihood to Recommend

Access works great for small databases where we want to be able to manipulate and look at the data in different ways. It doesn't work too well as the size of the database increases. In fact, it begins to slow down significantly once the size of the database gets too large.

Vetted Review
Microsoft Access
19 years of experience

Nice when is included

Rating: 8 out of 10
Incentivized

Use Cases and Deployment Scope

We needed a lightweight solution that could be easily integrated with our SQL server and could be installed on the user's computers

Pros

  • Easy to Use
  • Lightweight
  • Included with our office 365 licenses

Cons

  • Speed
  • Table size
  • Full text search

Likelihood to Recommend

It fits very well when few transactions are required to be processed but for our solution we had multiple installations on user computers that were synced in batches with our sql server.It is not suitable when the transactionality is high or the access of several users is required simultaneously, nor does it support large tables without significantly affecting performance

A great Database management solution which covers all aspects of data storage and management.

Rating: 8 out of 10
Incentivized

Use Cases and Deployment Scope

We used Microsoft Access as our main tool for our database management. It helps us to attend to the day-to-day tasks that a company needs to perform in order to function. Being a software company ourselves, We not only use it to store our company data but also some client information as well and do not have any negative outlook towards it yet.

Pros

  • Dattabase Management
  • Reporting
  • Analysis

Cons

  • Data Search
  • Intuitive analytics
  • Reporting structure

Likelihood to Recommend

It is well suited for organizations that are looking for an affordable way to manage their database. Analytics and reporting are quite adequate as well. Fulfills the basic functionalities required for basic level organizations. But if you want something more refined and advanced there are other tools out there that will suit your purposes more.

Vetted Review
Microsoft Access
2 years of experience

A superb database management system

Rating: 10 out of 10

Use Cases and Deployment Scope

Microsoft Access is one the best software in the database management system. In an organisation when one wants to make a report, Microsoft Access helps to do it perfectly. It is a software where graphic interface, Excel sheets are perfectly maintained. I am fully satisfied with the software. The software is very easy to use.

Pros

  • Database system can be easily done.
  • Graphical interface makes it awesome.
  • Collaboration of documents.

Cons

  • For huge amount of documents it is beaconing slower.
  • Security level is low.
  • It is available for windows user.

Likelihood to Recommend

For me it is a magnificent software and database management system. In this software data can be easily imported as there is no need to import data manually. It also provides free templates which make our work easier. The software is cost effective for an organisation. The interface is also attractive to do work here.

[Microsoft] Access - not for the faint of heart - but certainly for the amateur data miner

Rating: 10 out of 10
Incentivized

Use Cases and Deployment Scope

As a corporate trainer, it was my job to learn how a company would implement Microsoft Access and then train its employees how to build, use, and access the data relevant to their job. It was used for specific departments to collate information, collaborate with other employees and serve as the next step when excel could not provide a reporting function.

Pros

  • Reporting
  • Data gathering
  • Data manipulation
  • Easy to implement and train

Cons

  • Formula creation
  • Form creation
  • Complex reporting

Likelihood to Recommend

Microsoft Access can be easily implemented with training. It doesn't require expert level skill for basic reporting functions - but can be scaled to a complex database with sophisticated users. Its appropriate to consider if excel needs to be used to create reports, or if there are data entry needs - with corresponding reports.

Vetted Review
Microsoft Access
15 years of experience

Microsoft Access a great MS SQL alternative

Rating: 8 out of 10
Incentivized

Use Cases and Deployment Scope

[Microsoft] Access has all of the functionalities needed to build concise applications for small offices or needs. The ability to utilize other database platforms like SQL Server is a plus. The ability to create full functioning applications in less than an hour is a big plus. There isn't much you can't do with [Microsoft] Access if you understand that it isn't meant to be an enterprise tool.

Pros

  • Works on pretty much same SQL scripts
  • Forms and reports are easy to customize and edit.

Cons

  • High learning curve
  • Limited support
  • No new enhancements

Likelihood to Recommend

<div><div><p>[Microsoft] Access allows you to create places to store data in an easily retrievable fashion, allowing multiple users and form views for display and data entry, reporting, and data analysis. Easily mitigable to SQL Server, as you continue to grow. I've turned many an [Microsoft] Access database into a front-end for SQL Server. The Application looks and behaves like the other Office products, making it's introduction to new users fairly simple and straight forward. Review collected by and hosted on G2.com.</p></div></div><div>

</div>

Vetted Review
Microsoft Access
3 years of experience