Helping businesses choose
better software since 1999
better software since 1999
Guides & Research
Capterra’s researchers use a mix of verified reviews, independent research and objective methodologies to bring you selection and ranking information you can trust. While we may earn a referral fee when you visit a provider through our links or speak to an advisor, this has no influence on our research or methodology.
Capterra carefully verified over 2 million reviews to bring you authentic software and services experiences from real users. Our human moderators verify that reviewers are real people and that reviews are authentic. They use leading tech to analyze text quality and to detect plagiarism and generative AI. Learn more.
Capterra lists all providers across its website—not just those that pay us—so that users can make informed purchase decisions. Capterra is free for users. Software and service providers pay us for sponsored profiles to receive web traffic and sales opportunities. Sponsored profiles include a link-out icon that takes users to the provider’s website. Learn more.
"A good database and query solution"
Guy G. - DirectorAugust 1, 2024
STARTING PRICE
Not provided by software provider
EASE OF USE
3.9/5
Based on Capterra user reviews
TOP RATED
Microsoft Access is featured in 1 Capterra Shortlist rankings
Capterra Shortlist charts the highest-rated and most popular products to help you create a better software list.
Database management system that allows users to store and manage data and create database-powered apps.
Provider
Microsoft
Located In
United States
Foundation
1975
Open API
No
Deployment
Cloud, SaaS, Web-Based
Training
Live Online
Support
Phone Support, Email/Help Desk, Chat, FAQs/Forum, Knowledge Base
Database management system that allows users to store and manage data and create database-powered apps.
Content Source: Microsoft Access
Green rating bars show the winning product based on the average rating and number of reviews.
Reviewers commend Microsoft Access for its robust data management capabilities, particularly its efficient handling of data tables, forms, and reports. They value the software's compatibility with Excel, which facilitates seamless data integration and manipulation, as well as its powerful data mining and retrieval features. Users also appreciate the ease of storing and querying large volumes of data, noting that Access provides a reliable and economical method for managing and organizing information.
Users acknowledge that Microsoft Access offers a detailed and professional design, which can be rewarding for those willing to invest time in learning it. They appreciate its integration with other Microsoft products and the availability of online tools to assist with navigation. However, many reviewers find the software's steep learning curve and complicated design challenging, often requiring formal training to fully utilize its extensive features. Some users struggle with the initial complexity, finding it difficult to learn on their own.
Pros
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.
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.
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.
It can also supports visual basic and user with advance knowledge and get maximum benefits out of this amazing software by Microsoft.
Cons
No remote access of files, user based restriction is to be designed, multi user access is limited. No track of devoloment status.
The setup of the server was really tough. When I had to set it up on one of my clients' machines, it took me a couple of hours to figure out what libraries were missing.
This does give it a busy feel that can be intimidating, however, everything I've used with it has worked well.
Additionally there is limited integration with other data formats.
"A good database and query solution"
Overall: 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
"Microsoft Access & SQL"
Overall: In general MS Access is great tool which can be used to manage small company data, reducing the need for lots of spreadsheets.
Pros: If you are a beginner to database management and dash boards MS Access is a good place to start. It then has the additional features to connect to other databases such as SQL. There are also many customization you can make with VBA.
Cons: After using Access for many years the updated versions would often have different file types and previous VBA would become redundant. This seems not to be such a problem in recent years.
"Access is ok for low level needs"
Overall: 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.
"Creates Databases with Ease"
Overall: 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.
"Microsoft Access"
Overall: 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
