17 years helping Irish businesses
choose better software

Microsoft Access Reviews

About Microsoft Access

Database management system that allows users to store and manage data and create database-powered apps.

Learn more about Microsoft Access

Pros:

Microsoft Access provides an economical and efficient method for storing your data. Users can manipulate and organize date by creating tables and queries to suit business needs.

Cons:

The design feature, though flexible, is extremely difficult and time-consuming to learn. Once it is set up, it is easy to enter and search for data, but designing what is needed is very difficult.

Microsoft Access ratings

Average score

Ease of Use
3.9
Customer Service
3.9
Features
4.4
Value for Money
4.2

Likelihood to recommend

7.8/10

Microsoft Access has an overall rating of 4.4 out 5 stars based on 194 user reviews on Capterra.

Have you used Microsoft Access before?

Share your experiences with other software buyers.

Filter reviews (194)

Joseph Clogene
Joseph Clogene
CEO in Madagascar
Verified LinkedIn User
Internet, 2–10 Employees
Used the Software for: 1+ year
Reviewer Source

"Microsoft Access : une solution complète pour gérer vos projets

5.0 2 years ago

Comments: "As a small business, we have found Microsoft Access to be a cost-effective solution for managing our data. It allows us to easily store and share our important information, which improves our productivity."

Pros:

"I am impressed with the flexibility of Microsoft Access. It allows me to create custom forms and reports to meet my specific needs. It is a valuable tool for my productivity."

Cons:

"Although Microsoft Access is an excellent data management tool, it can be difficult to use for beginners. The learning curve can be steep, which can be a barrier for some users."

Federico
Federico
Management in Uruguay
Verified LinkedIn User
Investment Banking, 2–10 Employees
Used the Software for: 2+ years
Reviewer Source

Alternatives Considered:

Great product for a Small / Medium Bussiness

4.0 3 years ago

Comments: 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.

Kayla
Executive Director in US
Nonprofit Organisation Management, 2–10 Employees
Used the Software for: 1+ year
Reviewer Source

Access is ok for low level needs

1.0 11 months ago

Comments: I did not love our overall experience with Microsoft, I was most happy when we no longer had to use it.

Pros:

It was very intuitive to use and like other microsoft products.

Cons:

The inability to put multiple donations in and have them show when we pulled reports.

Guy
Guy
Director in UK
Verified LinkedIn User
Health, Wellness & Fitness, 2–10 Employees
Used the Software for: 2+ years
Reviewer Source

Alternatives Considered:

A good database and query solution

4.0 2 months ago

Comments: find for small or quick projects, but sometimes lacking for more complex needs

Pros:

Compatibility and familiarity with all other Microsoft product family

Cons:

feels somewhat less powerful and functional than other database and query engines

Tammy
Marketing Director/Dance Instructor in US
Fine Art, 2–10 Employees
Used the Software for: 2+ years
Reviewer Source

Integral part of our office

5.0 3 years ago

Pros:

The way I can customize reports and queries to produce the information that I need in the format that I need.

Cons:

Microsoft had said it was going to discontinue the program, so we changed before that happened and struggle with a different approach for two years before realizing they had changed their mind and kept it. It can be challenging to format the reports, but I eventually figure it out.

Ian
Business Development Manager in UK
Computer Networking, 11–50 Employees
Used the Software for: 2+ years
Reviewer Source

Alternatives Considered:

Still the best product in the market

5.0 3 years ago

Comments: Access is a learning curve, but you can crib a lot of useful code from forums online.

Pros:

You can design very sophisticated and feature rich applications with little or no development skills if you do have VBA skills then you can do even more with it

Cons:

there is almost too much information out there from developer forums but hard to find anything direct from Microsoft that trains you in Access or VBA development.

Abid
Abid
Manager Operations in Pakistan
Verified LinkedIn User
Banking, 5,001–10,000 Employees
Used the Software for: 2+ years
Reviewer Source

Best Database Management System By Microsoft

5.0 3 years ago

Comments: I am using Microsoft Access from last 12 years for preparing foreign exchange returns and i always found it very helpful and full of amazing features. Being the member of Microsoft 365 suite of application the software is designed very professionally and easily integrate with other Microsoft softwares.

Pros:

Microsoft Access can be use for creating forms, reports and queries and easily connect them with macros. It can also supports visual basic and user with advance knowledge and get maximum benefits out of this amazing software by Microsoft. We can also import or export data from Microsoft outlook, Excel, oracle and SQL server. The best thing about Microsoft Access is graphical user interface which allows user to easily understand the features and functionalities of this software.

Cons:

The only con which i experience is to setup Microsoft access is tough and requires extra understanding of its features and functions.

Tonji
Account Manager in US
Furniture, 10,000+ Employees
Used the Software for: 2+ years
Reviewer Source

Database

5.0 11 months ago

Pros:

Microsoft Access keeps everything organized it provide the key to input names, addresses, phones and any other information you want listed in about a customer.

Cons:

The only thing about Microsoft Access is that you need patience when entering infomation and it time consuming.

Rodica
Teacher in Romania
E-Learning, 51–200 Employees
Used the Software for: 2+ years
Reviewer Source

A good asset for teachers and students

5.0 2 months ago

Pros:

An easy Database application, for students and teachers. I have used it in my class very efficient.

Cons:

Some features are difficult to find in the beginning, but using it often it gets better and user friendlier.

Ezra
Owner in UK
Luxury Goods & Jewelry, 2–10 Employees
Used the Software for: 2+ years
Reviewer Source

Creates Databases with Ease

5.0 last month New

Comments: This is by far the hest software for creating databases ive ever used. It helps create databases for medical data entry that companies still use 20 years later.

Pros:

I love how easy it is to create databases for companies with this software. The graphics are awsome and it gives you all the settings and options on a easy to use platform.

Cons:

It sometimes has trouble importing files from other databases not created with Access giving you a mess to clean up.

Nathan
Analyst in Canada
Telecommunications, 10,000+ Employees
Used the Software for: 2+ years
Reviewer Source

MS Access - User Review

4.0 3 years ago

Comments: Overall experience is great, I can still do most of my tasks in terms of running report and data analysis.

Pros:

I used it frequently at work, the most I like about this software is relatively easy to use especially for beginners who wish to start learning how to run report for data management. Fairly speaking, users are required some understandings on table structure and database connections before start using this product. I found it interesting though as I have been using MS Access past 15 years with my current job, and I still find that there are many more to learn of this software.

Cons:

One thing I came across the compatibility issue with MS Access, e.g. when IT created a brand new table with SQL, and I am using Oracle to connect the newly created table, and for some reason MS Access unable to open up the table although I can connect the new table without issue. In short, I can use MS Access to connect the table, but can not open the table in MS Access. Our IT support team can open the same table with SQL though. I have a feeling this may have something to do with Windows 10 settings, but I am not that technically enough to troubleshoot, unfortunately our IT support group couldn't figure out my problem even now. The reason why I said I have feeling to do with Windows 10, it is because prior my company upgrade our OS to Windows 10, I am able to connect tables without any issues, and after OS upgraded and then IT created some new tables during new projects deployment, then I stared having issue with those newly created table.

Brian
Owner in US
Retail, Self Employed
Used the Software for: 2+ years
Reviewer Source

Brian’s Review

5.0 last year

Comments: Overall I recommend this product that I use quite often to everyone and anyone.

Pros:

"It is a viable and strong framework for information assortment and its administration. Simple to utilize and coordinate, you don"t should be a specialist to have the option to overseeing it."

Cons:

"The arrangement of the server was truly extreme. At the point when I needed to set it up on one of my clients' machines, it required me several hours to sort out where libraries were going wrong."

Maizy
Music Director in US
Religious Institutions, 2–10 Employees
Used the Software for: 2+ years
Reviewer Source

Good Database Tool

5.0 3 years ago

Comments: We've found we're able to store and query our data easily with Access. It's smooth and complete for a database tool. It works without issue - so no reason to look for something else.

Pros:

Microsoft Access is Microsoft's professional level product to address databases. Overall, I think it works really well, as many companies have adopted and use it, including my own. I love how it's Microsoft supported, so you can have confidence in its reliability. It relatively easy to use. It does require knowledge of databases and SQL, which may go without saying. My workplace uses Access for data storage, and it does well in its presentation and response from querying.

Cons:

Like a lot of Microsoft tools, they seems to be over blown with "bells and whistles". Microsoft Access definitely has many more options than I'll ever understand or know what to do with. This does give it a busy feel that can be intimidating, however, everything I've used with it has worked well.

John
Operations Supervisor in US
Consumer Services, 10,000+ Employees
Used the Software for: 2+ years
Reviewer Source

Microsoft Access is essential software for any business large or small

5.0 2 years ago

Comments: Overall, I cannot imagine not having it in our customer service call center. From using to access product information from callers, to using for call tracking and resolution of issues, it is a very versatile software product.

Pros:

Microsoft Access provides quick sorting and distribution of database information

Cons:

Access can be a bit cumbersome to program. However, the more familiar you are with the product and the more time you spend setting it up, the more easy to use and efficient the end product is.

Alaa
Site Engineer in Jordan
Construction, 201–500 Employees
Used the Software for: 2+ years
Reviewer Source

Best solution for small business

5.0 last year

Comments: I found it as the first step to beginning development, it's elementary and straightforward and can automate any procedure or process.

Pros:

Access enables the creation of database-driven applications quickly. It offers pre-built elements like forms and reports that may be readily altered and integrated into the application, as well as templates.

Cons:

Large-scale or enterprise-level data requirements could be difficult for Access to handle, despite the fact that it is appropriate for small to medium-sized databases. Dealing with a large amount of data or complicated queries may cause performance problems.

Verified Reviewer
Verified LinkedIn User
Design, Self Employed
Used the Software for: 2+ years
Reviewer Source

Practical for home or small business use

4.0 3 years ago

Pros:

Great speed compared to Excel. Possibility of relationships between tables, which works very well. Custom reports. The possibility of building forms and transforming the database into a small system. Easy integration via VBA with other Microsoft Office applications.

Cons:

The impossibility of purchasing it separately. Not everyone needs all the tools included in Microsoft Office 365

Panashe
Freelancer in Australia
Computer Software, Self Employed
Used the Software for: 2+ years
Reviewer Source

Microsoft Access review

5.0 3 years ago

Comments: 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

Austin
Instrumentation Team Leader in US
Automotive, 10,000+ Employees
Used the Software for: 2+ years
Reviewer Source

Powerful Software - Training Required

5.0 2 years ago

Comments: 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.

Verified Reviewer
Verified LinkedIn User
Government Administration, 501–1,000 Employees
Used the Software for: 6-12 months
Reviewer Source

Data analysis and Database programming streamlined with Microsoft Access

3.0 3 years ago

Comments: Have been using Microsoft Access as a part of the Microsoft suite, so the software is definitely tailored to such a scenario. Would appreciate if AI was also considered in version upgrades.

Pros:

Microsoft access is a great tool for data access and analysis, its is robust and straightforward. With the right training, anyone can use this and put meaning to a vast range of data. There is availability of several tools and templates, and integration with Microsoft Suite is exemplary.

Cons:

Not suitable for organizations who are responsible for analyzing large databases, as it has a finite limit. Additionally there is limited integration with other data formats.

Cathy
Cathy
Office Manager in US
Verified LinkedIn User
Mining & Metals, 5,001–10,000 Employees
Used the Software for: 2+ years
Reviewer Source

Easy to use, great reports

4.0 3 years ago

Comments: We purchase and use Access to track the placement and turnover of containers placed at customer locations. Once the massive amounts of initial information was inputnI found it very easy to use and it is easy to train the transportation department to use. I can create quality reports monthly to provide my mgt team.

Pros:

I am able to take a month's activity, in our case the placement and use of containers, and provide a nice tidy report to my management team. They love it and think I slave hours

Cons:

It tend to slow down exponentially with the amount of data you input. Since this is daily for us it can be pretty slow and the end users in some departments have to do entries after hours.

Brian
Client Manager in Israel
Logistics & Supply Chain, 51–200 Employees
Used the Software for: 2+ years
Reviewer Source

Access for organizing my work

5.0 3 years ago

Pros:

Fast data analysis. Allow to make tables with data cross very easy. Easy visual interface to perform querries.

Cons:

You need a minimal experience on programming. Not for beginners. The software has some bugs when summarize tables.

Mohammad
Technical Support in Jordan
Construction, 51–200 Employees
Used the Software for: 2+ years
Reviewer Source

Best Programing Enviroment

5.0 12 months ago

Comments: Microsoft Access is the first step for anyone interested in programming.

Pros:

Microsoft Access includes most small and medium businesses' needs, we programed small applications with small efforts and smoothly.

Cons:

Microsoft Access is limited with the number of records, so some days will stop working.

Heitor Ricardo
Tariff Specialist in Canada
Logistics & Supply Chain, 501–1,000 Employees
Used the Software for: 2+ years
Reviewer Source

Access Database works what its purpose

5.0 3 years ago

Pros:

It's more user friendly for database programmer in the beginning.

Cons:

It has more features for advanced users but it takes to reach that level.

Mohammed Ameen
Mohammed Ameen
Technical Support Specialist in South Africa
Verified LinkedIn User
Hospital & Health Care, 51–200 Employees
Used the Software for: 1+ year
Reviewer Source

Microsoft Access

4.0 8 months ago

Comments: My overall experience working with MS Access has been rather pleasant. We mostly use it to have ease of use of reports with regards to our assets and equipment

Pros:

As a user in my opinion and commonly cited by alot of users , I like Microsoft Access for its user-friendly interface, ease of creating databases, and its ability to manage and analyze data without requiring advanced programming skills. The integration with other Microsoft Office applications and the flexibility it provides in creating forms, reports, and queries are commonly cited as positive aspects by users.

Cons:

While Microsoft Access has its strengths, there are some limitations and drawbacks to consider: Scalability,Security Concerns Limited SQL Support Integration Challenges Reliability

Alejandro
Alejandro
Engineer in Ecuador
Verified LinkedIn User
Oil & Energy, Self Employed
Used the Software for: 6-12 months
Reviewer Source

MS Access, a good alternative for small databases

4.0 2 years ago

Comments: The use that I have given to MS Access was for information management of small projects, which allowed me to enter data through forms and then obtain the results that I wanted as documents that I could then easily export to MS Excel, this was more comfortable than Enter the data directly into MS Excel.

Pros:

MS Access is included in all MS Office packages, making it a viable alternative for small business database management or personal use. Besides being part of MS Office, it interacts better with other programs like MS Excel.

Cons:

For large or medium-sized companies it is not a good alternative, its use becomes very complex and requires many computing resources compared to alternatives designed for that volume of data. In addition, it only works on Windows operating systems, which greatly limits its use.