# Page 2 | Microsoft Access Reviews 2026. Verified Reviews, Pros & Cons | Capterra

> Page 2 - Is Microsoft Access the right Database solution for you? Explore 206 verified user reviews from people in industries like yours to make a confident choice.

Source: https://www.capterra.com/p/233275/Microsoft-Access/reviews

---

Microsoft Access

4.4 (206)

[View alternatives](https://www.capterra.com/p/233275/Microsoft-Access/alternatives/)

Provider data verified by our Software Research team, and reviews moderated by our Reviews Verification team. [Learn more](https://www.capterra.com/our-story/)

* * *

Last updated March 13th, 2026

# Page 2 - Reviews of Microsoft Access

## Showing most helpful reviews

Showing 26-50 of 206 Reviews

Sort by:

Most Helpful

Rating

Company Size

Reviewer's Role

Length of Use

Frequency of Use

US

Uwe S.  
Administrator  
Civic & Social Organization  
Used the software for: 2+ years

### "Access für kleine Datenbanken."

March 27, 2025

4.0

Für kleine Datenbankanwendungen ist es eine recht gute Lösung.

Pros

Access ist eine verhältnismäßig einfach zu bedienende Datenbankanwendung.

Cons

Die Performance bei großen Datenbanken ist eher langsam.

Switched from

[dBASE 2019](https://www.capterra.com/p/246175/dBASE-2019/)

Access war einfacher in der Bedienung und am Ende auch moderner.

Review Source

VR

Verified Reviewer  
QA Analyst  
Computer & Network Security  
Used the software for: 2+ years

### "Microsoft access database usage"

April 24, 2025

4.0

Its easy and convenient to use, make primary keys, preoare data and upload them to a database

Pros

The options to easily create a database abd write queries and retrieve data

Cons

Unable to connect with non microsoft tools

Review Source

CA

Chiara A.  
Hr, Payroll e Personal Administration  
Food & Beverages  
Used the software for: 2+ years

### "Un buon sistema per creare query"

October 15, 2024

4.0

Lo usiamo per interrogare delle query organizzate da un nostro esperto da cui possiamo facilmente vedere quali sono le assenze per singolo reparto e i costi per centro di costo

Pros

Mi consente di interrogare delle query che vengono costruite sulla base del gestionale e quindi di riuscire a leggere i dati sotto forma di statistica invece che sotto forma di database. Fa parte del pacchetto office quindi è poco costoso il suo utilizzo.

Cons

Non è un classico transazionale o un sistema di business intelligence classico.

Review Source

AK

Alexander K.  
Administrator  
Information Technology and Services  
Used the software for: 2+ years

### "Gutes Tool für Datenbanken"

March 6, 2025

4.0

Im Großen und Ganzen lassen sich damit sehr schnell einfache Datenbanken erstellen

Pros

Am Besten sind die umfangreichen Möglichkeiten

Cons

Stellenweise ist es kompliziert, hier vor allem die Beziehungen

Review Source

EM

Ezra M.  
Owner  
Luxury Goods & Jewelry  
Used the software for: 2+ years

### "Creates Databases with Ease"

August 28, 2024

5.0

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.

Review Source

RM

Rodica M.  
Teacher  
E-Learning  
Used the software for: 2+ years

### "A good asset for teachers and students"

August 6, 2024

5.0

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.

Review Source

MH

Mark H.  
Operational Excellence  
Automotive  
Used the software for: 2+ years

### "Premier consumer database"

June 27, 2024

4.0

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.

Review Source

AS

Antonio S.  
Contador  
Accounting  
Used the software for: I used a free trial

### "Avaliando o Microsoft Access"

August 10, 2023

5.0

Tem sido uma excelente experiência utilizar o Access.

Pros

O que mais gostei foi a facilidade de criação e gerenciamento de bancos de dados. A interface intuitiva e os recursos avançados oferecidos pelo programa facilitam muito a organização e o acesso aos dados.

Cons

O que menos gostei é a sua interface de usuário, que pode ser um pouco confusa e desorganizada. Às vezes, é difícil encontrar as funcionalidades e opções que preciso, o que torna o fluxo de trabalho um pouco mais lento.

Review Source

VR

Verified Reviewer  
impiegata  
Environmental Services  
Used the software for: 2+ years

### "come farei se non ci fosse"

August 14, 2023

5.0

Ottimo programma per la gestione dei DB con la possibilità di esportare gruppi di dati per utilizzi esterni.

Pros

Nonostante i tanti programmi che abbiamo a disposizione da decenni utilizzo Access per gestire un database dove raccolgo le informazioni che mi servono giornalmente per svolgere il mio lavoro. Se non lo avessi tutto sarebbe più lento e difficoltoso. Inoltre in base a come cambiano le normative e le esigenze posso adattarlo e infine esportare i dati che mi servono per utilizzarli in word (stampa unione)

Cons

A volte per piccole cose bisogna ricorrere al Visual basic e quindi a conoscenze approfondite di programmazione. Sarebbe bello elaborare documenti direttamente dentro access invece che esportare i dati in excel e successivamente collegarli con il file word. L'alternativa è troppo laboriosa se si devono creare testi di diverse pagine che poi vanno comunque implementati.

Review Source

José Eduardo A.  
Consultor Tecnológico  
Information Technology and Services  
Used the software for: 2+ years

### "Microsoft Access - El Mejor procesador de datos de la mediana y grande empresa."

November 11, 2021

5.0

De menos a más ha sido las expectativas que ha llenado este software de gestión, desde la 2.0 hasta la versión 2019 (ultima que he testeado, me ha permitido mejorar cronológicamente con la gestión de datos, ahorrar inversiones costosas en pequeñas y medianas empresas de soluciones de datos, y tener la facilidad y una personalización de reportes y formularios con una simpleza que asombra.

Pros

Su posición entre un gestor de base de datos y más que una de hoja de calculo avanzada; ahí en ese rango es en donde opera M. Access. Denominado como un gestor de base de datos, opera con una determinada amigabilidad con relación al usuario común o al no programador, pero con la suficiente para poder definir el manejo de tus datos correctamente y puedas crear tus propios repositorio de datos, tus consultas de mayor ventas o productos, los reportes para tomas de decisiones gerenciales e incluso los formularios de ingreso, que nos permitirá seguir alimentando los datos en la base.

Cons

No es lo que menos me ha gustado, pero probablemente sea una limitante, condicionado al entorno en que opera; Access está destinado a ser un gestor maravilloso y funcional al largo plazo en una mediana empresa y es muy amigable de operar. Al existir una inmensa cantidad de datos de procesar y almacenamientos de objetos tipo multimedia, su desempeño se ve afectado con el tiempo debido a que para esos trabajos ya debería encontrar otra solución más robusta y que cuente con servidores de datos propios, y es ahí donde se excede los parámetros de Access.

Alternatives considered

[Microsoft SQL Server](https://www.capterra.com/p/1417/SQL-Server/)[MySQL](https://www.capterra.com/p/11482/MySQL/)

Reason for choosing Microsoft Access

Porque está orientado a la mediana empresa y cubre y supera todas las expectativas que tengo con la gestión, procesamiento y presentación de datos.

Switched from

[Microsoft Excel](https://www.capterra.com/p/176574/Excel/)

Porque aparte de no ser una buena práctica, era difícil usar una hoja de cálculo como almacenamiento de cientos de datos que aumentaban cotidianamente, adicionalmente el uso de los recursos de los equipos siempre vivían colapsados y como consecuencia de eso, existieron caídas de los equipos y pérdidas de información, todo esto, se fue eliminando al migrar de Excel a Access como gestor de datos.

Review Source

mD

maykon D.  
diretor  
Civil Engineering  
Used the software for: Less than 6 months

### "Arkon-Microsoft Access"

March 1, 2023

5.0

No geral o Microsoft Access é uma feramenta positiva para usuários que precisam de uma ferramenta intuitiva para gerenciar dados em pequenas e médias empresas. O Access oferece diversos recursos de gerenciamento de dados, incluindo a possibilidade de criar bancos de dados personalizados, gerenciar tabelas, consultas e formulários, além de relatórios personalizados.

Pros

Gostei bastante dos conectores de dados que permite que o usuário possa conectar seus bancos de dados do Access a outras fontes de dados, como servidores SQL, Oracle e MySQL. Isso permite que o usuário trabalhe com dados em várias fontes, sem precisar importar manualmente os dados para o Access. Os conectores de dados do Access são fáceis de usar e permite que o usuário estabeleça conexões seguras e confiáveis ​​com fontes de dados externas.

Cons

Embora tenha muitos recursos úteis para gerenciamento de bancos de dados, também há alguns pontos negativos que devem ser considerados. Um dos principais pontos negativos é a escalabilidade limitada do Access, especialmente quando comparado a outros sistemas de gerenciamento de bancos de dados. O Access não é adequado para gerenciar grandes volumes de dados e pode ficar lento ao trabalhar com conjuntos de dados complexos.

Review Source

DO

David O.  
Preparador de impuestos  
Financial Services  
Used the software for: 2+ years

### "Microsoft Access tiene un mundo de opciones para la creacion y administracion de una base de datos."

January 19, 2024

5.0

Microsoft Access es un software que incluye muchas y muy buenas herramientas para la creacion, registro, administracion y presentacion de resultados de una base de datos, eso hace que una empresa tenga un mejor control de todos los movimientos que manejen en su trabajo diario,

Pros

Microsoft Access es una herramienta muy util en la realizacion de formatos de registros para una base de datos, llevar el control de usuarios, administrar los registros, y presentar resultados es muy eficaz con Access.

Cons

Me gustaria que incluyeran mas ejemplos de formatos creados por otros usuarios como una muestra de lo que se puede hacer, asi el usuario incial tendria una idea mas clara de como empezar un formato de registro

Switched from

[dBASE Plus](https://www.capterra.com/p/80138/dBASE-Plus/)

Por la integridad de Microsoft Access en el suite de Microsoft Office, asi tengo todas las aplicaciones integradas en el mismo Microsft Windows.

Review Source

Mohammed Ameen A.  
Technical Support Specialist  
Hospital & Health Care  
Used the software for: 1-2 years

### "Microsoft Access"

February 2, 2024

4.0

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

Review Source

Nwokocha P.  
Adoption and Change Management Executive  
Information Technology and Services  
Used the software for: 2+ years

### "Team Collaboration and User Experience"

July 9, 2022

4.0

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.

Reason for choosing Microsoft Access

The templates on Microsoft access are second to none. They are top-notch templates. The Desktop user interface is beginner-friendly, and I don't have to sweat much when teaching it to newbies.

Review Source

MT

Marek T.  
CEO  
Financial Services  
Used the software for: 2+ years

### "Microsoft Access Review"

April 27, 2023

5.0

My overall experience with Microsoft Access was positive. I found the app to be an essential tool for my company. I appreciated its ability to handle large amounts of data and create custom databases, as well as its powerful querying and reporting tools.

Pros

What I liked most about Microsoft Access was its ability to handle large amounts of data and create custom databases. The app's intuitive interface and range of templates made it easy to create and manage data, while its powerful querying and reporting tools allowed for in-depth analysis. Additionally, I appreciated the app's integration with other Microsoft Office products, such as Excel and PowerPoint.

Cons

One thing that I liked least about Microsoft Access was its limited compatibility with non-Windows platforms. While the app was widely used on Windows machines, it could be challenging to access and edit databases on other operating systems. Additionally, the app's steep learning curve and complexity could be overwhelming for users with limited experience in database management.

Review Source

ID

Igor D.  
Sr. Software Developer  
Information Technology and Services  
Used the software for: 2+ years

### "MS Access developer"

January 14, 2023

5.0

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.

Review Source

VR

Verified Reviewer  
business operative assistent  
Information Technology and Services  
Used the software for: 2+ years

### "Streamline Data Management and Boost Productivity with Microsoft Access"

May 30, 2023

4.0

Microsoft Access is a widely used desktop database management system that offers a range of features for creating, managing, and analyzing data

Pros

User-friendly interface, Versatility:, Access offers a wide range of functionalities, allow to create and manage small to medium-sized databases

Cons

Security concerns: Although Access provides security features, it may not offer the same level of security as dedicated enterprise database management systems. Access databases may be more susceptible to security vulnerabilities if not properly secured and maintained.

Review Source

NY

Nathan Y.  
Analyst  
Telecommunications  
Used the software for: 2+ years

### "MS Access - User Review"

November 8, 2021

4.0

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.

Review Source

FD

Felice D.  
Finance Manager  
Food & Beverages  
Used the software for: 2+ years

### "Creazione di database "

March 20, 2023

4.0

Pros

E' un software che permette integrazione di dati e la possibilità di avere dei dashboard in tempi ragionevoli.Lo usiamo per i kg prodotti, kg venduti, per le ore di assenza, per la pianificazione della produzione e per gli indici di rotazione dei crediti e dei prodotti.Ottima l'integrazione col nostro gestionale Sigla.Essendo nel pacchetto Office, ovviamente, il punto di forza è il costo contenuto.

Cons

Il sistema non è stabile come gli altri strumenti di reportistica come Qlik View.Rende difficile la storicizzazione delle ricette o la cristallizzazione di alcuni dati.

Review Source

VR

Verified Reviewer  
Brand Ambassador  
Mental Health Care  
Used the software for: 6-12 months

### "Perfect for Running Reports and Data Analysis"

May 19, 2022

4.0

I can create quality reports monthly, and I can analyze a lot of data using it. It's helped me with all my clients' projects. Microsoft users should definitely consider this product.

Pros

It will save you time when creating a system that will only get used on one computer, enabling you to create reports in an easily accessible format. Reports and various forms are available, linked to a programming code using programming languages, and complex arithmetic operations executed using code stored in the application. Also, adding tables and linking them together is very easy.

Cons

Large amounts of data tend to cause the software to operate slower and it can't be purchased separately.

Review Source

CM

Cecilie M.  
freelancer  
Retail  
Used the software for: 6-12 months

### "Microsoft Access"

July 12, 2022

5.0

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.

Review Source

Lourdes G.  
Asistente al Cliente  
Supermarkets  
Used the software for: 1-2 years

### "Un clásico en Base de Datos. "

February 23, 2023

4.0

El diseño de Acces es sumamente detallado y profesional, como no podia ser por parte de MIcrosoft. Si bien tiene un acurva de aprendizaje un poco alta su complegidad es merecida en base a los resultados.

Pros

Es extremadamente exacta a la hora de realizar procesos y muy fiel a la hora de almacenar datos.

Cons

Es un poco confuso el manejo de usuarios y el otorgamiento de permisos. También se cae un poco al manjear base de datos muy grandes. Su precio es muy caro.

Review Source

Ngo N.  
Data base analyst  
Wholesale  
Used the software for: 2+ years

### "Excellent pour le stockage des données "

October 15, 2023

5.0

Très satisfaisant

Pros

Son côté graphique lui confère une particularité unique qui lui rend facile à utiliser même pour les débutants. Le fait qu'il intègre Microsoft office permet d'utiliser en parallèle Excel et Word

Cons

Sa capacité limitée lié au volume de données qu'il peut gérer et sa lent lors de la gestion des grandes données

Alternatives considered

[Sublime Text](https://www.capterra.com/p/179535/Sublime-Text/)

Reason for choosing Microsoft Access

Pour la gestion des clients de l'entreprise

Review Source

Griffin B.  
Senior Strategic Planning Analyst  
Hospitality  
Used the software for: 2+ years

### "Simple but not so Easy"

December 19, 2021

4.0

Overall, I have used Access to allow multiple business users to store data to track executive comps given out in a casino environment. It has been useful to deploy to many end-users who do not have the knowhow to use more sophisticated data storage software, such as MS SQL Server. And it also has allowed us to harness automated macro scripts to generate timely reporting.

Pros

I like Access for its ability to store data in a localized way. Access obviously comes with many editions of Microsoft Office, so it's readily "accessible" and generally understandable. I like that it has a Visual Basic for Applications (VBA) component as well, so you can build macros and automate reports easily. I also like that it has a query-building interface for users who are unfamiliar with SQL language.

Cons

However, I do not like how complicated Access is to design. I consider myself a database expert (Information Systems degree) and I still don't exactly know how to make forms fully work together in Access. Granted, I never had any specific Access training, but it feels like it should be more intuitive to an expert--and it's not. The most annoying feature is that each object needs to be closed before you edit anything. Why they couldn't have engineered it to just update the object/table regardless is a mystery to me.

Review Source

JB

Jonnadula B.  
Freelancer  
Computer Software  
Used the software for: 6-12 months

### "Microsoft Access Review of Group Collaboration and User Experience "

July 27, 2022

5.0

I understood Microsoft access needs a more vigorous arrangement in information capacity regions where its boundaries are surpassed particularly with enormous informational indexes. I have been involving it for SMB data sets and can say it has been a commendable encounter. SMBs upscale their organizations at any point time and their information expands this is where I require some investment of MS Access likewise increments. Which makes me self-conscious in the midst of anxiety. The presentation is impacted over the long run as the information get greater in any event, when put away in the cloud. I would cherish an improvement with stacking time against bigger informational index. Additionally mix of MS access into new innovations like blockchain is important. I'm designing my strategy for getting around utilizing MS Access with blockchain exercises and the advancement has been empowering.

Pros

Data groups can team up on a data set and tables progressively on the web application. This web Collaboration makes distant information groups profoundly useful without expecting to move out of the internet browser.

Cons

Data groups can't team up through the work area application. Cooperative suers are exposed to the limit of their internet browsers. The User experience of the web connection point isn't so smooth and pleasant as the work area application which make information the board, storehouses and inquiries somewhat hostile with huge informational index.

Review Source

Similar Products

Featured

## Related categories

[Database](https://www.capterra.com/database-management-software/)

## Send me user reviews about this product

### Fill out the form and we'll send a list of the top-rated software based on real user reviews directly to your inbox.