Microsoft Access

4.4 (200)
Write a Review!
Microsoft-powered DBMS

Overall rating

4.4 /5
(200)
Value for Money
4.3/5
Features
4.4/5
Ease of Use
3.9/5
Customer Support Software
3.9/5

91%
recommended this app
Sort by

200 Reviews

Mohammed Ameen
Mohammed Ameen
Overall rating
  • Industry: Hospital & Health Care
  • Company size: 51–200 Employees
  • Used Monthly for 1+ year
  • Review Source

Overall rating

  • Value for Money
  • Ease of Use
  • Customer Support Software
  • Likelihood to recommend 10.0 /10

Microsoft Access

Reviewed on 2024-02-02

My overall experience working with MS Access has been rather pleasant. We mostly use it to have...

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

Rodica
Overall rating
  • Industry: E-Learning
  • Company size: 51–200 Employees
  • Used Weekly for 2+ years
  • Review Source

Overall rating

  • Ease of Use
  • Likelihood to recommend 10.0 /10

A good asset for teachers and students

Reviewed on 2024-08-06

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.

Marco
Overall rating
  • 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 2023-11-26

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

Mokwena Macdee
Overall rating
  • Industry: Information Technology & Services
  • Company size: 2–10 Employees
  • Used Daily for 2+ years
  • Review Source

Overall rating

  • Ease of Use
  • Likelihood to recommend 10.0 /10

My favourite database. Very good for small teams.

Reviewed on 2024-02-15

Since 2001. I studied it in detail. I earned a living for more than 10 years programming databases...

Since 2001. I studied it in detail. I earned a living for more than 10 years programming databases for small businesses. I think it is still good if used as a personal database only.

Pros

Very cheap to procure, program and deploy. Very good if used by a team of less than 4 people.

Cons

Not suitable to be deployed on the internet. All 3 of us use the Microsoft Access database from the same computer.

Joshua
Overall rating
  • Industry: Construction
  • Company size: 51–200 Employees
  • Used Daily for 1-5 months
  • Review Source

Overall rating

  • Value for Money
  • Ease of Use
  • Customer Support Software
  • Likelihood to recommend 9.0 /10

Supercalifragilisticexpialidocious

Reviewed on 2024-10-02

So far, I’ve had great experience with this

So far, I’ve had great experience with this

Pros

If we have an issue with something, you guys look at and fix it right away

Cons

We’re still having issues uploading certain items we need

Verified Reviewer
Overall rating
  • Industry: E-Learning
  • Company size: Self Employed
  • Used Daily for Free Trial
  • Review Source

Overall rating

  • Value for Money
  • Ease of Use
  • Customer Support Software
  • Likelihood to recommend 10.0 /10

free the workforce

Reviewed on 2023-12-01

Pros

the software has been better for me especially when I can use it in building data analysis features and the security in the software is great.
also, the great thing I love is the fact that there is automation and macros in the system which makes work much easier.

Cons

The thing I do not like is the limited web application development where I can not be able to build or develop apps. also the file size limitation of 2 GB

John
Overall rating
  • 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 Software
  • Likelihood to recommend 10.0 /10

Desktop DBMS that's hard to beat

Reviewed on 2023-10-24

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.

Jarrett
Overall rating
  • Industry: Consumer Goods
  • Company size: 10,000+ Employees
  • Used Monthly for 2+ years
  • Review Source

Overall rating

  • Ease of Use
  • Likelihood to recommend 7.0 /10

Simple databasing

Reviewed on 2023-11-20

Pros

Using this software made it simple for entry, making lists, running reports, ect.

Cons

It was a little on the manual side for most things that you needed to initially set up

Lauren
Overall rating
  • Industry: Design
  • Company size: 2–10 Employees
  • Used Daily for 1-5 months
  • Review Source

Overall rating

  • Ease of Use
  • Likelihood to recommend 9.0 /10

Good storage

Reviewed on 2024-03-25

Pros

I find it really useful as a database to link lots of spreadsheets when there is a lot of data. With Microsoft being a popular software of various applications having a familiar layout and to link to Excel spreadsheets is good. The queries that can be made is very useful to make things quicker

Cons

Those that need huge amounts of storage may find this gets a bit slow. But still holds a lot!

Jer Lang
Overall rating
  • Industry: Computer Software
  • Company size: 201–500 Employees
  • Used Weekly for 2+ years
  • Review Source

Overall rating

  • Ease of Use
  • Likelihood to recommend 8.0 /10

A comprehensive database for all

Reviewed on 2024-01-15

Pros

Comes with an interactive GUI unlike other database. Can be considered enterprise level database due to its functionality. It can easily be integrated with Office applications.

Cons

It's primarily for Window applications and can support limited number of concurrent users access

Mohammad
Overall rating
  • Industry: Construction
  • Company size: 51–200 Employees
  • Used Weekly for 2+ years
  • Review Source

Overall rating

  • Value for Money
  • Ease of Use
  • Customer Support Software
  • Likelihood to recommend 9.0 /10

Best Programing Enviroment

Reviewed on 2023-10-24

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

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.

Verified Reviewer
Overall rating
  • 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 Software
  • Likelihood to recommend 8.0 /10

Streamline Data Management and Boost Productivity with Microsoft Access

Reviewed on 2023-05-30

Microsoft Access is a widely used desktop database management system that offers a range of...

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.

Marek
Overall rating
  • Industry: Financial Services Software
  • Company size: 11–50 Employees
  • Used Daily for 2+ years
  • Review Source

Overall rating

  • Value for Money
  • Ease of Use
  • Customer Support Software
  • Likelihood to recommend 9.0 /10

Microsoft Access Review

Reviewed on 2023-04-27

My overall experience with Microsoft Access was positive. I found the app to be an essential tool...

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.

Mark
Overall rating
  • Industry: Environmental Services
  • Company size: 11–50 Employees
  • Used Daily for 2+ years
  • Review Source

Overall rating

  • Ease of Use
  • Customer Support Software
  • Likelihood to recommend 8.0 /10

Promising tool for SME's

Reviewed on 2023-03-30

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.

Nwokocha
Nwokocha
Overall rating
  • Industry: Information Technology & Services
  • Company size: 51–200 Employees
  • Used Daily for 2+ years
  • Review Source

Overall rating

  • Value for Money
  • Ease of Use
  • Customer Support Software
  • Likelihood to recommend 9.0 /10

Team Collaboration and User Experience

Reviewed on 2022-07-09

I realized Microsoft access needs a more robust solution in data storage areas where its parameters...

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.

Nathan
Overall rating
  • Industry: Telecommunications
  • Company size: 10,000+ Employees
  • Used Daily for 2+ years
  • Review Source

Overall rating

  • Ease of Use
  • Likelihood to recommend 7.0 /10

MS Access - User Review

Reviewed on 2021-11-08

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

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.

Cecilie
Overall rating
  • Industry: Retail
  • Company size: Self Employed
  • Used Monthly for 6-12 months
  • Review Source

Overall rating

  • Value for Money
  • Ease of Use
  • Customer Support Software
  • Likelihood to recommend 9.0 /10

Microsoft Access

Reviewed on 2022-07-12

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.

Abid
Abid
Overall rating
  • Industry: Banking
  • Company size: 5,001–10,000 Employees
  • Used Daily for 2+ years
  • Review Source

Overall rating

  • Value for Money
  • Ease of Use
  • Customer Support Software
  • Likelihood to recommend 10.0 /10

Best Database Management System By Microsoft

Reviewed on 2022-02-15

I am using Microsoft Access from last 12 years for preparing foreign exchange returns and i always...

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.

Michael
Overall rating
  • Industry: Retail
  • Company size: 2–10 Employees
  • Used Daily for 2+ years
  • Review Source

Overall rating

  • Value for Money
  • Ease of Use
  • Likelihood to recommend 8.0 /10

Basic But Solid Data Management

Reviewed on 2022-09-08

I use Access and Excel daily to keep 20,000+ inventory items up to date for my e-commerce site. I...

I use Access and Excel daily to keep 20,000+ inventory items up to date for my e-commerce site. I cannot imagine working without Access.

Pros

My favorite thing about Access is that it works well with Excel, and I like to transfer my tables from Access to Excel so I can do data manipulation on them and then return them to Access. Of course there's more risk in operating in this manner but it also enables me to do things that would be difficult or impossible with Access alone.

Cons

There's limits on field sizes when moving back and forth between Excel and Access that are frustrating and seem to me to be unnecessary with our modern, higher powered computers.

Ratulovszky
Overall rating
  • Industry: Computer Software
  • Company size: Self Employed
  • Used Monthly for 6-12 months
  • Review Source

Overall rating

  • Value for Money
  • Ease of Use
  • Customer Support Software
  • Likelihood to recommend 5.0 /10

Very useful, very efficient

Reviewed on 2022-08-30

In general, this software will be of great benefit to all users. Mostly easy to handle, clean and...

In general, this software will be of great benefit to all users. Mostly easy to handle, clean and efficient. I can only recommend!

Pros

Very clean and mostly easy to use, very efficient for users.

Cons

Often, the software is not yet completely clear or has an old design, which raises errors and questions for the user.

Cathy
Cathy
Overall rating
  • Industry: Mining & Metals
  • Company size: 5,001–10,000 Employees
  • Used Weekly for 2+ years
  • Review Source

Overall rating

  • Value for Money
  • Ease of Use
  • Customer Support Software
  • Likelihood to recommend 7.0 /10

Easy to use, great reports

Reviewed on 2021-12-02

We purchase and use Access to track the placement and turnover of containers placed at customer...

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.

Verified Reviewer
Overall rating
  • 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 Software
  • Likelihood to recommend 10.0 /10

Best office suite

Reviewed on 2022-06-30

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

Verified Reviewer
Overall rating
  • 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 2022-02-09

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.

Mohammed
Mohammed
Overall rating
  • 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 Software
  • Likelihood to recommend 10.0 /10

My experience with MS Access

Reviewed on 2022-02-25

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

Mphare
Mphare
Overall rating
  • Industry: Computer Software
  • Company size: Self Employed
  • Used Weekly for 1+ year
  • Review Source

Overall rating

  • Value for Money
  • Ease of Use
  • Customer Support Software
  • Likelihood to recommend 8.0 /10

A great database management software

Reviewed on 2022-08-01

It still remains decent and other features it has are also very handy

It still remains decent and other features it has are also very handy

Pros

It's user interface makes it easy to user and manage databases, easy to make reports

Cons

Although it is one of highly recommended tools It is just not ideal for team use