Microsoft Access is a database management system from Microsoft that combines the relational Microsoft Jet Database Engine with a graphical user interface and software-development tools.
Microsoft Access is a superb software in database management system. I have been using it for many years without any hesitations. The software is making it different from other software with its awesome features. The software is cost effective for the organisation. It also …
Verified User
Executive
Chose Microsoft Access
Excel is a fantastic - robust application that can do so much so easily. Its easy to train and understand. However - excel does not provide a reporting function and that is typically where we will suggest a move to [Microsoft] Access. [Microsoft] Access requires a little more …
With [Microsoft] Access I am able to quickly create simple database driven solutions with built in UI and reporting in one tool. Advanced coding is not necessary and the tool guides you through building out. Opponents for a robust, end-to/end product.
Having used Snowflake, I can definitely say that both of these tools are very easy to use and value for money. Although for me, the aspects where Microsoft Access stacks up are its low cost and usability. Snowflake is good with its cloud-based system but for startups where the …
I haven't really used another database product other than Microsoft Access since the mid-90s. I don't even remember which program I did use, but needless to say, it did not have as much functionality nor was it as user friendly as databases today. So I really can't say how …
Crystal is easier for report writing, but isn't a database solution. Salesforce is lovely, but much more expensive than an old copy of Microsoft Office. For a small budget, [Microsoft] Access was really the only viable option. I only wish it was easier to write complex reports.
[Selected Microsoft Access for] employee learning simplicity, attractive graphical environment and features of Microsoft 365 with responsive Microsoft support.
Visual FoxPro is a discontinued software, and no longer has support. Also, very few people still use it, or ever know how to use it. Excel is very popular, but [Microsoft] Access can do things like data joins much easier and faster
Although SQL is a full-blown platform for heavy database management, Microsoft Access serves the purpose perfectly for small and mid-scale enterprises. It is also perfect for people just getting started with database management. The graphical user interface is a major plus …
Microsoft Access is better for large files and backlogs than Excel because it can handle the workload. Excel is great as well, but filtering and searching is limited, and it can crash rather easily. You don't see those problems with Access.
We've actually started to use both of these programs. There are pros and cons to both. Microsoft Access is best for linking two sets of data that already have a common shared field (i.e. both sets of data include a student ID number, social security number, etc) Airtable is best …
SharePoint is good for simple data structures, use of workflow, integration with AD, etc. But SharePoint does not support fully relational data or complex reporting, whereas Access absolutely does.
Being a similar "Windows application" it's easier to start to use as part of Office. Also, the GUI capabilities are much more advanced than other high-performance databases.
There have always been a variety of different database products in the last 33 years but for ease of use and code that is similar to other Microsoft products, Access is a good fit. A lot of people will try to use an Excel spreadsheet to do some of the things that could be …
We tried Salesforce, which was expensive and not as customizable as Access. QuickBase also was pricey compared to already having an MS license with the existing package, and QuickBase was not very intuitive. The other option was an open source version which was less intuitive …
You save money: Microsoft Access is hundreds of dollars cheaper than other larger systems; offering similar functionalities and usage.
It is a program that has all the work tools that the organization requires to function properly and fulfill the planned tasks.
In the company it …
Verified User
Analyst
Chose Microsoft Access
Unlike enterprise-level databases, MS Access doesn't require setting up a complex server environment with user security schemes. It's an excellent tool for small scale databases where purchasing and setting up a product like MS SQL Server could be an overkill. Unlike …
Tableau is not even a 'switch-out' tool, it's for visualization so it's not a fair comparison. Against other databasing tools, MySQL is still my favorite may be simply due to being a creature of comfort because that's where I first learned to manage DB. However, Microsoft …
MS SQL is a more powerful tool but I love the reporting feature in MS Access. MS Excel is useful for complex calculations but to me, MS Access helps me organize that data. InfoPath is similar to MS Access in that you can create forms for data entry, but it does not include …
Microsoft Access can be easily implemented with training. It doesn't require expert level skill for basic reporting functions - but can be scaled to a complex database with sophisticated users. Its appropriate to consider if excel needs to be used to create reports, or if there are data entry needs - with corresponding reports.
Microsoft Access has not really changed at all for several years. It might be nice to see some upgrades and changes.
The help info is often not helpful. Need more tutorials for Microsoft Access to show how to do specific things.
Be careful naming objects such as tables, forms, etc. Names that are too long can get cut off in dialog boxes to choose a table, form, report, etc. So, I wish they would have resizable dialog boxes to allow you to see objects with long names.
I wish it could show me objects that are not in use in the database for current queries, tables, reports, forms, and macros. That way unused objects can be deleted without worrying about losing a report or query because you deleted the underlying object.
I and the rest of my team will renew our Microsoft Access in the future because we use and maintain many different applications and databases created using Microsoft Access so we will need to maintain them in the future. Additionally, it is a standard at our place of work so it is at $0 cost to us to use. Another reason for renewing Microsoft Access is that we just don' t have the resources needed to extend into a network of users so we need to remain a single-desktop application at this time.
Microsoft Access is easy to use. It is compatible with spreadsheets. It is a very good data management tool. There is scope to save a large amount of data in one place. For using this database, one does not need much training, can be shared among multiple users. This database has to sort and filtering features which seem to be very useful.
While I have never contacted Microsoft directly for product support, for some reason there's a real prejudice against MS Access among most IT support professionals. They are usually discouraging when it comes to using MS Access. Most of this is due to their lack of understanding of MS Access and how it can improve one's productivity. If Microsoft invested more resources towards enhancing and promoting the use of MS Access then maybe things would be different.
Crystal is easier for report writing, but isn't a database solution. Salesforce is lovely, but much more expensive than an old copy of Microsoft Office. For a small budget, [Microsoft] Access was really the only viable option. I only wish it was easier to write complex reports.