17 years helping Irish businesses
choose better software
About Microsoft Access
Database management system that allows users to store and manage data and create database-powered apps.
Microsoft Access provides an economical and efficient method for storing your data. Users can manipulate and organize date by creating tables and queries to suit business needs.
The design feature, though flexible, is extremely difficult and time-consuming to learn. Once it is set up, it is easy to enter and search for data, but designing what is needed is very difficult.
Filter reviews (194)
Usage
Sort by
Filter reviews (194)
"Microsoft Access : une solution complète pour gérer vos projets
Comments: "As a small business, we have found Microsoft Access to be a cost-effective solution for managing our data. It allows us to easily store and share our important information, which improves our productivity."
Pros:
"I am impressed with the flexibility of Microsoft Access. It allows me to create custom forms and reports to meet my specific needs. It is a valuable tool for my productivity."
Cons:
"Although Microsoft Access is an excellent data management tool, it can be difficult to use for beginners. The learning curve can be steep, which can be a barrier for some users."
Alternatives Considered:
Great product for a Small / Medium Bussiness
Comments: My overall experience is very positive, I always use is when possible. Saves em a lot of time and allows me to perform world-class reports.
Pros:
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!
Cons:
The only thing that I don't like is that it is not very powerful and gets slow with some big databases.
Access is ok for low level needs
Comments: 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.
Alternatives Considered:
A good database and query solution
Comments: 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
Integral part of our office
Pros:
The way I can customize reports and queries to produce the information that I need in the format that I need.
Cons:
Microsoft had said it was going to discontinue the program, so we changed before that happened and struggle with a different approach for two years before realizing they had changed their mind and kept it. It can be challenging to format the reports, but I eventually figure it out.
Alternatives Considered:
Still the best product in the market
Comments: Access is a learning curve, but you can crib a lot of useful code from forums online.
Pros:
You can design very sophisticated and feature rich applications with little or no development skills if you do have VBA skills then you can do even more with it
Cons:
there is almost too much information out there from developer forums but hard to find anything direct from Microsoft that trains you in Access or VBA development.
Best Database Management System By Microsoft
Comments: 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.
Database
Pros:
Microsoft Access keeps everything organized it provide the key to input names, addresses, phones and any other information you want listed in about a customer.
Cons:
The only thing about Microsoft Access is that you need patience when entering infomation and it time consuming.
A good asset for teachers and students
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.
Creates Databases with Ease
Comments: 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.
MS Access - User Review
Comments: 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.
Brian’s Review
Comments: Overall I recommend this product that I use quite often to everyone and anyone.
Pros:
"It is a viable and strong framework for information assortment and its administration. Simple to utilize and coordinate, you don"t should be a specialist to have the option to overseeing it."
Cons:
"The arrangement of the server was truly extreme. At the point when I needed to set it up on one of my clients' machines, it required me several hours to sort out where libraries were going wrong."
Good Database Tool
Comments: We've found we're able to store and query our data easily with Access. It's smooth and complete for a database tool. It works without issue - so no reason to look for something else.
Pros:
Microsoft Access is Microsoft's professional level product to address databases. Overall, I think it works really well, as many companies have adopted and use it, including my own. I love how it's Microsoft supported, so you can have confidence in its reliability. It relatively easy to use. It does require knowledge of databases and SQL, which may go without saying. My workplace uses Access for data storage, and it does well in its presentation and response from querying.
Cons:
Like a lot of Microsoft tools, they seems to be over blown with "bells and whistles". Microsoft Access definitely has many more options than I'll ever understand or know what to do with. This does give it a busy feel that can be intimidating, however, everything I've used with it has worked well.
Microsoft Access is essential software for any business large or small
Comments: Overall, I cannot imagine not having it in our customer service call center. From using to access product information from callers, to using for call tracking and resolution of issues, it is a very versatile software product.
Pros:
Microsoft Access provides quick sorting and distribution of database information
Cons:
Access can be a bit cumbersome to program. However, the more familiar you are with the product and the more time you spend setting it up, the more easy to use and efficient the end product is.
Best solution for small business
Comments: I found it as the first step to beginning development, it's elementary and straightforward and can automate any procedure or process.
Pros:
Access enables the creation of database-driven applications quickly. It offers pre-built elements like forms and reports that may be readily altered and integrated into the application, as well as templates.
Cons:
Large-scale or enterprise-level data requirements could be difficult for Access to handle, despite the fact that it is appropriate for small to medium-sized databases. Dealing with a large amount of data or complicated queries may cause performance problems.
Practical for home or small business use
Pros:
Great speed compared to Excel. Possibility of relationships between tables, which works very well. Custom reports. The possibility of building forms and transforming the database into a small system. Easy integration via VBA with other Microsoft Office applications.
Cons:
The impossibility of purchasing it separately. Not everyone needs all the tools included in Microsoft Office 365
Microsoft Access review
Comments: Very excellent and the fact that its charged reasonable is good
Pros:
Its easy to configure and use environment The relationship drawing option is very handy in different product development The option to set description in data fields is very useful
Cons:
If they can improve the data security and also overall performance improvement of the ole objects its bit slow
Powerful Software - Training Required
Comments: Overall Access is a feature rich, powerful, versatile solution for database management. To really use the product to its full potential, I would highly recommend some sort of formal training.
Pros:
Microsoft Access is a very powerful database tool. It can be easily implemented into existing systems. The ability to use the same database across multiple platforms is excellent and extremely useful. The data management tools offered are extremely powerful as well.
Cons:
It takes quite some time to get acclimated to the software due to the sheer amount of features that are offered. If users have access to any sort of formal training, it is highly recommended. It is very easy to become overwhelmed and lost when first starting out.
Data analysis and Database programming streamlined with Microsoft Access
Comments: Have been using Microsoft Access as a part of the Microsoft suite, so the software is definitely tailored to such a scenario. Would appreciate if AI was also considered in version upgrades.
Pros:
Microsoft access is a great tool for data access and analysis, its is robust and straightforward. With the right training, anyone can use this and put meaning to a vast range of data. There is availability of several tools and templates, and integration with Microsoft Suite is exemplary.
Cons:
Not suitable for organizations who are responsible for analyzing large databases, as it has a finite limit. Additionally there is limited integration with other data formats.
Easy to use, great reports
Comments: 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.
Access for organizing my work
Pros:
Fast data analysis. Allow to make tables with data cross very easy. Easy visual interface to perform querries.
Cons:
You need a minimal experience on programming. Not for beginners. The software has some bugs when summarize tables.
Best Programing Enviroment
Comments: 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.
Access Database works what its purpose
Pros:
It's more user friendly for database programmer in the beginning.
Cons:
It has more features for advanced users but it takes to reach that level.
Microsoft Access
Comments: 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
MS Access, a good alternative for small databases
Comments: The use that I have given to MS Access was for information management of small projects, which allowed me to enter data through forms and then obtain the results that I wanted as documents that I could then easily export to MS Excel, this was more comfortable than Enter the data directly into MS Excel.
Pros:
MS Access is included in all MS Office packages, making it a viable alternative for small business database management or personal use. Besides being part of MS Office, it interacts better with other programs like MS Excel.
Cons:
For large or medium-sized companies it is not a good alternative, its use becomes very complex and requires many computing resources compared to alternatives designed for that volume of data. In addition, it only works on Windows operating systems, which greatly limits its use.