App comparison

Add up to 4 apps below to see how they compare. You can also use the "Compare" buttons while browsing.

Microsoft Access Pricing, Features, Reviews and Alternatives

Microsoft Access product overview

What is Microsoft Access?

Microsoft Access is a database management system that can create functional database apps for any business purpose. By integrating Visual Basic for Applications (VBA), Access can create unique business apps, automate important business processes, and consolidate information for forms and reports. Using the Access' connector library, users can seamlessly integrate third-party business apps to generate aggregated visuals and insights for any report or app.

Key benefits of using Microsoft Access

  • Create apps easier with built-in templates that can also be created using existing apps.

  • Create user-friendly forms to help automate business processes.

  • The DB can store valuable data in SQL Server as well as Azure SQL for better security, reliability, scalability, and manageability.

  • Utilizes standard SQL syntax for better compatibility and a more mission-critical back-end.

  • Easy to learn, especially for the existing Excel users, and provides different ways of accomplishing the same task.
  • Typical customers

    Freelancers
    Small businesses
    Mid size businesses
    Large enterprises

    Platforms supported

    Web
    Android
    iPhone/iPad

    Support options

    Phone Support
    Email/Help Desk
    Chat
    FAQs/Forum
    Knowledge Base

    Training options

    Live Online

    Microsoft Access features

    Functionality

    4.4

    /5

    69

    Total features

    17

    1 categories

    Most valued features by users

    API
    Access Controls/Permissions
    Activity Dashboard
    Reporting & Statistics
    Monitoring
    Real Time Monitoring
    Data Visualization
    Workflow Management

    Microsoft Access users reviews

    Overall Rating

    4.4

    /5

    69

    Positive reviews

    Rating breakdown
    • Value for money
    • Ease of use
    • Features
    • Customer support
    • Likelihood to recommend7.97/10
    Rating distribution

    5

    4

    3

    2

    1

    36

    27

    6

    0

    0

    Pros
    Microsoft Access is a database management solution that is among the best. It has a very good user interface and is very easy to use.

    ET

    Etornam T.

    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.
    AvatarImg

    Federico A.

    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.

    LW

    Llanoi W.

    Cons
    Microsoft Access sometimes have illogical errors and to solve them I have to reopen it.
    AvatarImg

    Yasser T.

    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.
    AvatarImg

    Griffin B.

    Really it works well only as a small desktop style database or a quick and dirty front end on SQL Server.

    AR

    Anonymous Reviewer

    Overall Rating
    • Value for money
    • Ease of use
    • Features
    • Customer support
    • Likelihood to recommend10/10

    Share this review:

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

    Reviewed 8 months ago

    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.

    Showing original review in Spanish. See translation

    Overall Rating
    • Value for money
    • Ease of use
    • Features
    • Customer support
    • Likelihood to recommend7/10

    Share this review:

    Perfect for Running Reports and Data Analysis

    Reviewed 2 months ago

    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.

    Overall Rating
    • Value for money
    • Ease of use
    • Features
    • Customer support
    • Likelihood to recommend5/10

    Share this review:

    Somewhat clunky interface, great data collection and reporting tool.

    Reviewed a year ago
    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.

    Overall Rating
    • Value for money
    • Ease of use
    • Features
    • Customer support
    • Likelihood to recommend8/10

    Share this review:

    Microsoft Access Review

    Reviewed 3 months ago

    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.

    Overall Rating
    • Value for money
    • Ease of use
    • Features
    • Customer support
    • Likelihood to recommend8/10

    Share this review:

    Very useful data management tool

    Reviewed 2 months ago
    Pros

    The most important thing about Microsoft Access is that it is inexpensive. Creating table from scratch might be technical but Microsoft simplify things with templates and each category has a demo video to help users get started. Another plus is that the platform has been around for decades and introductory courses taught from the high school level.

    Cons

    Setting up tables from scratch might require some technical knowledge.

    Microsoft Access FAQs and common questions

    Q. Who are the typical users of Microsoft Access?

    Microsoft Access has the following typical customers:
    Freelancers, Large Enterprises, Mid Size Business, Small Business


    Q. What languages does Microsoft Access support?

    Microsoft Access supports the following languages:
    Arabic, Bulgarian, Chinese (Simplified), Czech, Danish, Dutch, English, French, Greek, Hebrew, Japanese, Korean, Latvian, Portuguese, Portuguese, Portuguese, Romanian, Russian, Slovenian, Spanish, Thai, Turkish, Ukrainian, Latin


    Q. Does Microsoft Access offer an API?

    No, Microsoft Access does not have an API available.


    Q. What level of support does Microsoft Access offer?

    Microsoft Access offers the following support options:
    Phone Support, Email/Help Desk, Chat, FAQs/Forum, Knowledge Base

    Common Microsoft Access comparisons

    Related categories