App comparison

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

Microsoft Access Logo

Microsoft Access

4.4
(184)

Write a review

Microsoft-powered DBMS

see alternatives

(4)

Microsoft Access Pricing, Features, Reviews and Alternatives

Microsoft Access FAQs

Q. Who are the typical users of Microsoft Access?

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

These products have better value for money


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

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

    Not sure about Microsoft Access? Compare it with a popular alternative

    Starting from

    ic-pricetag

    No pricing info

    Free plan
    Free trial
    Pricing range

    Starting from

    50

    Per month

    Flat Rate

    Free plan
    Free trial
    Pricing range
    Ease of use
    Value for money
    Customer support
    Ease of use
    Value for money
    Customer support
    Why am I seeing this?

    Microsoft Access features

    Functionality

    4.4

    /5

    184

    Total features

    12

    1 categories

    Most valued features by users

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

    Functionality contenders

    Microsoft Access users reviews

    Overall Rating

    4.4

    /5

    184

    Positive reviews

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

    5

    4

    3

    2

    1

    97

    66

    19

    1

    1

    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.
    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.
    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
    The weakness in cloud capability and the lack of integration with other external software.
    Microsoft Access sometimes have illogical errors and to solve them I have to reopen it.
    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.

    Overall rating contenders

    AvatarImg
    AvatarImg

    Manuel Eduardo M.

    Computer Software, self-employed

    Used weekly for less than 6 months

    Review source

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

    Share this review:

    The ease of use of Microsoft Access

    Reviewed 2 years ago

    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.

    AR
    AvatarImg

    Verified reviewer

    Banking, 5,001-10,000 employees

    Used weekly for 2+ years

    Review source

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

    Share this review:

    Great for simple and mid-level databases

    Reviewed 2 years ago

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

    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.

    CC
    AvatarImg

    Carlos C.

    Automotive, 201-500 employees

    Used daily for 2+ years

    Review source

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

    Share this review:

    Not he most simple data base developing tool

    Reviewed 9 months ago
    Pros

    The possibility to develop a data base with the microsfot office base aspect.

    Cons

    Too much complicate to develop and old tools in compare with new softwares more simple and friendly user.

    AR
    AvatarImg

    Verified reviewer

    Education Management, 201-500 employees

    Used daily for 2+ years

    Review source

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

    Share this review:

    Microsoft access for devolpment

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

    AvatarImg
    AvatarImg

    Shane J.

    Government Administration, 201-500 employees

    Used daily for 2+ years

    Review source

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

    Share this review:

    Nice tool for simple database management

    Reviewed 2 years ago

    I've used Access to manage databases and access data. The Query Design Wizard is a nice feature but it's tedious to perform other data science task like data tranformations

    Pros

    It displayed data in an intuitive way. It's a familiar, accessible tool for managing databases if you're used to working with Microsoft Office products and with traditional spreadsheets.

    Cons

    The customer support and amount of online help resources aren't as helpful as those for other software used to manage database like SQL Server-based products. I also experienced regular freezes or glitches that were annoying and a bit time consuming.

    Common Microsoft Access comparisons

    Microsoft Access logo
    MySQL logo
    Microsoft AccessvsMySQL
    Microsoft Access logo
    Microsoft SQL Server logo
    Microsoft AccessvsMicrosoft SQL Server
    Microsoft Access logo
    Snowflake logo
    Microsoft AccessvsSnowflake
    Microsoft Access logo
    Caspio logo
    Microsoft AccessvsCaspio
    Microsoft Access logo
    DBeaver logo
    Microsoft AccessvsDBeaver
    Microsoft Access logo
    Airtable logo
    Microsoft AccessvsAirtable
    Microsoft Access logo
    SQLite logo
    Microsoft AccessvsSQLite

    Related categories