Microsoft Access Reviews
Overall rating
Filter by
Company size
Time used
193 Reviews
- Industry: Computer Software
- Company size: Self Employed
- Used Weekly for 1-5 months
-
Review Source
Overall rating
- Value for Money
- Ease of Use
- Customer Support
- Likelihood to recommend 10.0 /10
The ease of use of Microsoft Access
Reviewed on 24/02/2022
As student of first year of systems engineering, the program microsoft access has been a perfect...
As student of first year of systems engineering, the program microsoft access has been a perfect tool for learn and practice databases.
Pros
The platform is very friendly with the users who are beginners in the subject of databases. Like student of first year in systems engineering has been a good tool for start with the databases.
The interface is very simple, and the tools have easy access for users.
Cons
I don't see a lot of cons, because is program for beginners, and in my case i think it's good just to start, if we want something more professional there are more database programs.
Alternatives Considered
MySQLReasons for Choosing Microsoft Access
To do more professional work.Switched From
MySQLReasons for Switching to Microsoft Access
Because it has a simple interface.- Industry: Telecommunications
- Company size: 11–50 Employees
- Used Daily for 2+ years
-
Review Source
Overall rating
- Value for Money
- Ease of Use
- Customer Support
- Likelihood to recommend 8.0 /10
Microsoft Access Review
Reviewed on 8/04/2022
It has been extremely helpful in managing our increasing customer base and billing.
It has been extremely helpful in managing our increasing customer base and billing.
Pros
"I love that you can quickly learn the most important things about database interaction."
"I've used it over and over again. My favorite thing about this software is that it's easy to use, especially for beginners who want to start learning how to report for Data Management."
"It's good for translating raw data into insights with its great Data mining features. I can use queries to query any criteria specified based on what I'm using the information for."
"I have been using Microsoft Access for 8 years to set up various databases used to manage our telecom platform and I find it very useful and make full use of the many features."
Cons
It is difficult to manage large databases and it is not possible to improve performance by using MS Access.
Alternatives Considered
MySQLReasons for Switching to Microsoft Access
It is easier to use and very powerful especially for creating queries, forms and reports.- Industry: Real Estate
- Company size: 2–10 Employees
- Used Monthly for 2+ years
-
Review Source
Overall rating
- Ease of Use
- Likelihood to recommend 5.0 /10
Somewhat clunky interface, great data collection and reporting tool.
Reviewed on 30/07/2021
Pros
I have used Access over the years for many purposes, from employee databases to customer management to logistics and inventory tracking. My favorite feature was a combination of having all the data I needed in one place, and being able to customize the end reports to show and manipulate the visibility of just the data needed for myself or a supervisor. Instead of giving them a spreadsheet, I was able to give them a tidy report with just what they asked for, which made the bosses happy.
Cons
Access is, as its core, a data management tool. The very feature that makes it so awesome also makes it cumbersome - it can be really hard to move around a large database and get to the entry points you need. This is surmountable by building an entry form, but not for the faint of heart or the casual user, either.
Alternatives Considered
Microsoft ExcelReasons for Switching to Microsoft Access
Access could handle more than Excel, but Excel is easier to use. We began to migrate lighter data needs over to Excel, and stayed in Access for the larger and more data intensive data collection needs.- Industry: Automotive
- Company size: 501–1,000 Employees
- Used Daily for 2+ years
-
Review Source
Overall rating
- Value for Money
- Ease of Use
- Customer Support
- Likelihood to recommend 7.0 /10
Premier consumer database
Reviewed on 27/06/2024
Absolutely critical to our business and very powerful.
Absolutely critical to our business and very powerful.
Pros
Great functionality in helping us create databases as well as workflows with permissions. Can perform and monitor most business functions.
Cons
Overall user interface is challenging at times and is not a very intuitive learn.
- Industry: Facilities Services
- Company size: 51–200 Employees
- Used Weekly for 2+ years
-
Review Source
Overall rating
- Value for Money
- Ease of Use
- Customer Support
- Likelihood to recommend 5.0 /10
Microsoft Access & SQL
Reviewed on 29/04/2024
In general MS Access is great tool which can be used to manage small company data, reducing the...
In general MS Access is great tool which can be used to manage small company data, reducing the need for lots of spreadsheets.
Pros
If you are a beginner to database management and dash boards MS Access is a good place to start. It then has the additional features to connect to other databases such as SQL. There are also many customization you can make with VBA.
Cons
After using Access for many years the updated versions would often have different file types and previous VBA would become redundant. This seems not to be such a problem in recent years.
- Industry: Information Technology & Services
- Company size: 11–50 Employees
- Used Monthly for 2+ years
-
Review Source
Overall rating
- Value for Money
- Ease of Use
- Customer Support
- Likelihood to recommend 7.0 /10
Experience with Microsoft Access
Reviewed on 27/03/2022
It has been used for the generation of the billing system, as well as for the generation of...
It has been used for the generation of the billing system, as well as for the generation of documentary control reports.
Pros
It has tools that allow you to save time when generating a system that will be used in a single computer, in addition to being able to easily generate reports.
Cons
Large databases become difficult to maintain and manage, and there are no options to improve the performance of the database from within MS Access.
Alternatives Considered
SQLiteReasons for Switching to Microsoft Access
SQLite needs other tools to be able to generate a user interface as well as to generate reports.- Industry: Banking
- Company size: 5,001–10,000 Employees
- Used Weekly for 2+ years
-
Review Source
Overall rating
- Value for Money
- Ease of Use
- Customer Support
- Likelihood to recommend 10.0 /10
Great for simple and mid-level databases
Reviewed on 16/04/2022
Whether you are an experienced programmer or a novice, Access is a great tool.
If you do not know...
Whether you are an experienced programmer or a novice, Access is a great tool.
If you do not know SQL, Access can create queries for you. (not VBA though).
You can easily integrate Access with all other products - Excel, Txt files, SQL Server, Oracle, etc.
If you wish to dwelt deeper into programming - Access is a great place to start, after becoming more experienced, yo can start using SQL Sever, VB, Oracle, and databases and front end applications.
Pros
If you want a relational database, and don't have hundreds of tables, 100,000+ rows each - access is a database to use.
First of all it provides - Back End (tables), Front End (forms), Queries, and built in Reports.
if you have many users, you can split - Master Database that will only have tables, and other databases linked to it will hosts forms and everything else while being linked to the main database.
It utilizes SQL language and VBA so you can perform pretty much every command you need.
You can add any control on Form or Table level to verify what users are doing to prevent errors.
Regarding what I said about hundreds of tables - if you simply want to look through tables now and then, but not on regular basis, you can store data outside in large txt files, load them, an then remove. (For that using temporary copies will be most useful)
Cons
I've been working with Access for about 20 years, many issues I've seen earlier have been fixed.
Now if you wish to split a database, it can do it for you. Maximum limit for currency is not a couple of billions anymore (not a huge amount for Financial Companies)
My least favorite part is compacting. Database often becomes to large and needs to be compacted before it crashes. Compacting still takes to long, and sometimes database crashes while doing that.
I wish some king of automatic compacting can be done without asking the user.
- Industry: Information Technology & Services
- Company size: 51–200 Employees
- Used Daily for 2+ years
-
Review Source
Overall rating
- Value for Money
- Ease of Use
- Customer Support
- Likelihood to recommend 9.0 /10
Team Collaboration and User Experience
Reviewed on 9/07/2022
I realized Microsoft access needs a more robust solution in data storage areas where its parameters...
I realized Microsoft access needs a more robust solution in data storage areas where its parameters are exceeded especially with large data sets. I have been using it for SMB databases and can say it has been a worthy experience. SMBs upscale their businesses evertime and their data becomes larger this is where I take caution because the loading time of MS Access also increases. Which makes me uncomfortable in times of impatience.
The performance is affected over time as the data get bigger even when stored in the cloud. I would love an improvement with loading time against larger data set.
Also integration of MS access into new technologies like blockchain is necessary. I am engineering my way around using MS Access with blockchain activities and the progress has been encouraging.
Pros
Data teams can collaborate on a database and tables in real-time on the web application. This web Colloborationn makes remote data teams highly productive without needing to move out of the web browser.
Cons
Data teams cannot collaborate through the desktop application. Collaborative suers are subjected to the capacity of their web browsers.
The User experience of the web interface is not as smooth and enjoyable as the desktop app which make data management, repositories and queries a little unfriendly with large data set.
- Industry: Education Management
- Company size: 201–500 Employees
- Used Daily for 2+ years
-
Review Source
Overall rating
- Value for Money
- Ease of Use
- Customer Support
- Likelihood to recommend 8.0 /10
Microsoft access for devolpment
Reviewed on 18/09/2022
Pros
Easy managing databases with simple suit, no coding for relationships between tables, just click and dragg.
Field control, data control options are awesome which to provide easier method than to code it, while for advance scenarios vba coding also available and can be done.
Forms, reports, queries are designated separately but linkage available.
Quick output for most no debugging and complilation, objects can be dragged and thier position, functions can be set even with mouse only.
Universal access of program no special setting etc required if file is ttanafered to another PC.
Linkage for mysql server is also facilitated. Database import export can be made with. Excle,. Csv files too.
Cons
No remote access of files, user based restriction is to be designed, multi user access is limited. No track of devoloment status.
No log of maintenance is created.
- Industry: E-Learning
- Company size: 51–200 Employees
- Used Daily for 2+ years
-
Review Source
Overall rating
- Value for Money
- Ease of Use
- Customer Support
- Likelihood to recommend 10.0 /10
My experience with MS Access
Reviewed on 25/02/2022
Pros
I work on Access for 3 years and show that it help me to manage the data perfectly
Cons
User need tutorial before using it and some time changing the version is not a good idea
- Industry: Retail
- Company size: 2–10 Employees
- Used Daily for 2+ years
-
Review Source
Overall rating
- Value for Money
- Ease of Use
- Likelihood to recommend 8.0 /10
Basic But Solid Data Management
Reviewed on 8/09/2022
I use Access and Excel daily to keep 20,000+ inventory items up to date for my e-commerce site. I...
I use Access and Excel daily to keep 20,000+ inventory items up to date for my e-commerce site. I cannot imagine working without Access.
Pros
My favorite thing about Access is that it works well with Excel, and I like to transfer my tables from Access to Excel so I can do data manipulation on them and then return them to Access. Of course there's more risk in operating in this manner but it also enables me to do things that would be difficult or impossible with Access alone.
Cons
There's limits on field sizes when moving back and forth between Excel and Access that are frustrating and seem to me to be unnecessary with our modern, higher powered computers.
- Industry: Electrical/Electronic Manufacturing
- Company size: 51–200 Employees
- Used Daily for 2+ years
-
Review Source
Overall rating
- Value for Money
- Ease of Use
- Likelihood to recommend 8.0 /10
The Quick Data-Driven Application Development Tool
Reviewed on 12/10/2022
Pros
The best part about Microsoft Access is the combination of a data source, graphical interface design and automation into a single environment without the need to compile anything for quick development. The deployment of the application can be as simple as distributing or sharing the file. If there are multi-user needs these can be handled just as easily.
Cons
Occasionally data corruption can be a thing for multi-user situations. Also, when working within the various versions (2003, 2010, 2013, 2016, etc.) and the changes made to functionality there is an added layer of technical difficulty to deal with.
- Industry: Retail
- Company size: Self Employed
- Used Monthly for 6-12 months
-
Review Source
Overall rating
- Value for Money
- Ease of Use
- Customer Support
- Likelihood to recommend 9.0 /10
Microsoft Access
Reviewed on 12/07/2022
In the event that your data set should be safeguarded by broad data set security conventions,...
In the event that your data set should be safeguarded by broad data set security conventions, Access probably won't be the most ideal choice. You can keep away from this issue by utilizing Access toward the front of a SQL server, however few out of every odd business needs that degree of framework regardless makes delicate information to be secured.
Pros
It just requires minutes to introduce this Microsoft Access. Consequently, clients get a data set that is completely useful. It requires no convoluted programming to utilize either, so the normal PC client can exploit the data that can be assembled by this framework.
In the event that your data set should be safeguarded by broad data set security conventions, Access probably won't be the most ideal choice. You can keep away from this issue by utilizing Access toward the front of a SQL server, however few out of every odd business needs that degree of framework regardless makes delicate information to be secured.
Cons
There is a wall that can ultimately be reached with regards to contributing data into this data set. For bigger information clients, Microsoft Access might cause constraints that other data set projects might not have just on the grounds that there is a document size limit.
In the event that your data set should be safeguarded by broad data set security conventions, Access probably won't be the most ideal choice. You can keep away from this issue by utilizing Access toward the front of a SQL server, however few out of every odd business needs that degree of framework regardless makes delicate information to be secured.
- Industry: Information Technology & Services
- Company size: 11–50 Employees
- Used Weekly for 2+ years
-
Review Source
Overall rating
- Value for Money
- Ease of Use
- Likelihood to recommend 10.0 /10
MS Access developer
Reviewed on 14/01/2023
MS Access is great for prototyping new systems, quickly create some screens and data tables and...
MS Access is great for prototyping new systems, quickly create some screens and data tables and then move to more serious Database Management System
Pros
It is part of Microsoft Office product suite and maintains compatibility with other tools - import and export of formatted data. MS Access has built-in easy to learn Visual Basic development environment that allows to build user interface for data entry. MS Access comes with drivers to connect to other databases or text file data sources.
Cons
It is a Personal use software, it is not reliable when shared across network with concurrent access. MS Access is good and effective for small databases - up to several millions of records, up to 100 MB of total disc space used. It lacks User management, Backup and other important for Enterprise software features.
- Industry: Automotive
- Company size: 1,001–5,000 Employees
- Used Daily for Free Trial
-
Review Source
Overall rating
- Value for Money
- Ease of Use
- Customer Support
- Likelihood to recommend 10.0 /10
Much More Than a Database
Reviewed on 24/11/2022
Pros
Yes, I can say more than a database. It is an effective program compared to its competitors in the current market. It is a very effective program especially in terms of time and cost savings. It has active support from small businesses to large businesses.System and resource requirements are almost nonexistent. Easy to install in any environment and operating system. Active customer support process, visually drag and drop technology can be done.Key Features include,* platform independent installation* Relational data tables* Advanced interface design,* Current and effective reporting techniques* User database security* Minimum cost and resource requirement* Simple and Easy user interfaceHe is at a level to lead all his rivals in the same class by far. Management and editing without any coding knowledge.
Cons
Increasing the storage capacity a little more will perhaps have the biggest impact on the market. I have no doubt that it will be unbeatable. But even at this level it responds to all our tests.
- Industry: Information Technology & Services
- Company size: 2–10 Employees
- Used Weekly for 2+ years
-
Review Source
Overall rating
- Value for Money
- Ease of Use
- Customer Support
- Likelihood to recommend 8.0 /10
Excellent product for low-level database management
Reviewed on 7/09/2022
Overall, Microsoft Access provides fast deployment, easy write times, security, and great data...
Overall, Microsoft Access provides fast deployment, easy write times, security, and great data managment tools to make our business run efficently.
Pros
Deployment, write speed, secure access, data managment
Cons
Pricing can be expensive for small businesses
Alternatives Considered
MongoDBReasons for Switching to Microsoft Access
Better synchronization with SQL Server- Industry: Apparel & Fashion
- Company size: 11–50 Employees
- Used Daily for 2+ years
-
Review Source
Overall rating
- Value for Money
- Ease of Use
- Customer Support
- Likelihood to recommend 6.0 /10
Works for specific programs and has been around a while
Reviewed on 14/04/2022
Pros
We're able to use this program for our very intricate consignment program. We have also now been able to expand and use this for inventory purposes as well as pull reports.
Cons
It's slow due to having to be on the server. I wish it functioned more as a CRM and could hold more customer info without slowing it down. I also wish it could integrate with more programs and apps.
- Industry: Higher Education
- Company size: 1,001–5,000 Employees
- Used Daily for 2+ years
-
Review Source
Overall rating
- Ease of Use
- Likelihood to recommend 9.0 /10
Microsoft Access Review
Reviewed on 31/01/2022
Pros
Microsoft Access proved to be an easy to use and convenient software in storing large amounts of data. The ability to mine through data through the use of simple queries came in handy. Additionally, through the use of primary keys, duplications were next to impossible which was super helpful.
Cons
It tends to freeze, especially when running queries.
- Industry: Legal Services
- Company size: Self Employed
- Used Weekly for 1+ year
-
Review Source
Overall rating
- Ease of Use
- Likelihood to recommend 5.0 /10
Good only for local and standalone applications
Reviewed on 26/11/2023
For personal use it is effective but trying to use it by sharing access to network resources...
For personal use it is effective but trying to use it by sharing access to network resources presents a lot of problems (from security to performance, to the number of simultaneous accesses etc. etc.)
Pros
It is easy to have the program installed on your PC and create tables in which to insert data and forms with which to populate them
Cons
It's not ideal for a centralized solution to share tables for colleagues. It was born as a single-user application to be installed on your PC and any workaround to transform it into a centralized database is a forcing that inevitably leads to problems or compromises, especially in terms of security
- Industry: Nonprofit Organisation Management
- Company size: 2–10 Employees
- Used Daily for 2+ years
-
Review Source
Overall rating
- Value for Money
- Ease of Use
- Likelihood to recommend 5.0 /10
Basic Database Management for Low Budget Organizations
Reviewed on 9/02/2022
Pros
Price. Access is a decent database platform for organizations with uncomplicated membership and low budget.
Cons
Trying to see more data is hard - Access doesn’t give pretty charts or good data analysis options. Also it’s hard to track changes to records.
- Industry: Architecture & Planning
- Company size: Self Employed
- Used Weekly for 1-5 months
-
Review Source
Overall rating
- Ease of Use
- Likelihood to recommend 8.0 /10
Perfect for Data management file for small to medium type of organization
Reviewed on 12/04/2023
As a newbie learner apps a like tools developer , this apps is for you. Its convenient to use. It...
As a newbie learner apps a like tools developer , this apps is for you. Its convenient to use. It needs no enough knowledge in VBA language to develop a simple data system but its compulsory to know programming to have an appealing one. For an office to have a nice office documentation, this is recommended.
Pros
I like MS office access because its easy to use specially if someone is using a developed system developed by some users for easy functionality. Its good for office documents and reporting. It can handle large data files. For small developers using this software, easy to use and convenient. Not needing more vba knowledge to creates a simple system, Easy to create tables, query, forms and reports. Buttons are ready made. You just need to follow proper clicking of commands to get the right function. More convenient that MS Excel.
Cons
If not properly setup in a network can affects its full functionality due to overloading of users. It may stop on working and need to restart the software again. It crashes sometimes if not properly handled.
- Industry: Arts & Crafts
- Company size: 51–200 Employees
- Used Daily for 2+ years
-
Review Source
Overall rating
- Ease of Use
- Customer Support
- Likelihood to recommend 5.0 /10
Everyday use
Reviewed on 12/11/2021
It's good if you need to handle a lot of data and make an analyse of it
It's good if you need to handle a lot of data and make an analyse of it
Pros
The features when you learn how to use it
Cons
The complexity to implement it, needs a lot of practice
- Industry: Consumer Services
- Company size: 11–50 Employees
- Used Weekly for 2+ years
-
Review Source
Overall rating
- Value for Money
- Ease of Use
- Customer Support
- Likelihood to recommend 10.0 /10
Powerful database software
Reviewed on 17/07/2022
The program has helped me keep records for a long and has been working pretty well, with fewer...
The program has helped me keep records for a long and has been working pretty well, with fewer instances of crashes and failure, besides its difficulty, the tool functions well and can handle large files with ease.
Pros
Microsoft Access has been the go-to for productivity for years. It's a powerful program suite that helps me create and edit documents, databases, and more.
Cons
It is very difficult to learn on my own, I had to be taught in school to get around it and it looks old fashioned hence need to improve its user interface
- Industry: Information Technology & Services
- Company size: 1,001–5,000 Employees
- Used Daily for 2+ years
-
Review Source
Overall rating
- Value for Money
- Ease of Use
- Customer Support
- Likelihood to recommend 8.0 /10
Microsoft Access
Reviewed on 30/06/2022
Pros
data collection and reporting data transformation
Cons
database performace for store informacion
- Industry: Education Management
- Company size: 51–200 Employees
- Used Weekly for 2+ years
-
Review Source
Overall rating
- Ease of Use
- Likelihood to recommend 10.0 /10
Microsoft Access is a wonderful, Free-to-use database software.
Reviewed on 1/11/2023
Pros
Access gives the user a wide range of features that enhance user experience and functions well in storing data.
Cons
Access isn't connected to other applications for easy transfer of data.