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 08/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: Investment Banking
- 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 10.0 /10
Great product for a Small / Medium Bussiness
Reviewed on 24/11/2021
My overall experience is very positive, I always use is when possible. Saves em a lot of time and...
My overall experience is very positive, I always use is when possible. Saves em a lot of time and allows me to perform world-class reports.
Pros
I am very impressed about the reliability in handling regular size databases, and the best part is that you can write your own SQL commands!
Cons
The only thing that I don't like is that it is not very powerful and gets slow with some big databases.
Reasons for Choosing Microsoft Access
Because I was able to have more reliability and work perfectly with different companies rather than using the IBM suite.Switched From
dBASE PlusReasons for Switching to Microsoft Access
The Microsoft suite is widely used over any other suite in the market.- 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: 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: Computer Software
- 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 10.0 /10
Best office suite
Reviewed on 30/06/2022
Pros
Microsoft Access is very user-friendly for my business it makes it easy for me and simple to use
Cons
No anomaly detected, everything is perfect
- 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: Information Technology & Services
- Company size: 2–10 Employees
- Used Daily for 2+ years
-
Review Source
Overall rating
- Value for Money
- Ease of Use
- Customer Support
- Likelihood to recommend 10.0 /10
Desktop DBMS that's hard to beat
Reviewed on 24/10/2023
I've been a professional Access developer since 1993 and have built a career from creating and...
I've been a professional Access developer since 1993 and have built a career from creating and maintaining applications built with it. Once you understand its gotchas and limitations, I think it offers one of the best ROIs for custom software development.
Pros
RAD tools for building forms and reports in a fraction of the time of other systems. Many options for migrating back-end database to other databases.
Cons
I wish there were better tools for version control, query optimization, tuning, and integration with web APIs and JSON.
- Industry: Environmental Services
- Company size: 11–50 Employees
- Used Daily for 2+ years
-
Review Source
Overall rating
- Ease of Use
- Customer Support
- Likelihood to recommend 8.0 /10
Promising tool for SME's
Reviewed on 30/03/2023
It is very helpful for us specially on our trading division. It really helps them to manage their...
It is very helpful for us specially on our trading division. It really helps them to manage their project and other stuffs.
Pros
What we like about this software is the UI that helps the non tech to easily understand what they need and where to find. For us tech person behind, we like the of ease implementation and maintenance.
Cons
So far nothing hate about this product. Everything from Microsoft is good and useful tools.
- 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: 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: Computer Software
- Company size: Self Employed
- Used Daily for 2+ years
-
Review Source
Overall rating
- Value for Money
- Ease of Use
- Customer Support
- Likelihood to recommend 10.0 /10
Microsoft Access review
Reviewed on 14/02/2022
Very excellent and the fact that its charged reasonable is good
Very excellent and the fact that its charged reasonable is good
Pros
Its easy to configure and use environment
The relationship drawing option is very handy in different product development
The option to set description in data fields is very useful
Cons
If they can improve the data security and also overall performance improvement of the ole objects its bit slow
- Industry: Automotive
- Company size: 10,000+ Employees
- Used Weekly for 2+ years
-
Review Source
Overall rating
- Value for Money
- Ease of Use
- Customer Support
- Likelihood to recommend 5.0 /10
Powerful Software - Training Required
Reviewed on 12/01/2023
Overall Access is a feature rich, powerful, versatile solution for database management. To really...
Overall Access is a feature rich, powerful, versatile solution for database management. To really use the product to its full potential, I would highly recommend some sort of formal training.
Pros
Microsoft Access is a very powerful database tool. It can be easily implemented into existing systems. The ability to use the same database across multiple platforms is excellent and extremely useful. The data management tools offered are extremely powerful as well.
Cons
It takes quite some time to get acclimated to the software due to the sheer amount of features that are offered. If users have access to any sort of formal training, it is highly recommended. It is very easy to become overwhelmed and lost when first starting out.
- 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 Organization 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 09/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 01/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.