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.
$139.99
per PC
MySQL
Score 8.3 out of 10
N/A
MySQL is a popular open-source relational and embedded database, now owned by Oracle.
N/A
.NET
Score 8.5 out of 10
N/A
Microsoft's .Net is an open source, freeware application infrastructure.
Microsoft Access can be used on the Windows platform, which most organizations use, especially our own, which is one of the reasons why we selected Microsoft Access. Access was also part of the standard Windows image that our company uses when imaging desktops and laptops so …
Verified User
Analyst
Chose Microsoft Access
Microsoft Access is better for novice users. It is very user-friendly and helps beginners learn data base rather than MySQL. MySQL is for more advanced users which have more experience. Access is also good for smaller organizations. It saves money rather than spending more on …
Microsoft Access databases are more suitable for us because we are a smaller team. It's easy for us to export the reporting. It's also easy for people to create their own databases as well! Microsoft Access is honestly a one-stop-shop for us, and we figured we were not at a …
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 …
[Selected Microsoft Access for] employee learning simplicity, attractive graphical environment and features of Microsoft 365 with responsive Microsoft support.
Microsoft Access is a bit dated compared to other database tools. It is slower, not able to handle quantities of data that are as large as the other tools, and a bit more finicky. However, it is sometimes the preferred tool for some clients. It also has a lower barrier to entry …
Verified User
Employee
Chose Microsoft Access
MS Access is the little brother to all these products. In no way is it as feature-rich as the competition I have selected. It is, however, great when used properly. It does not have the same level of security, availability, access, or recoverability as anything listed above. …
Access should be relatively cost effective because it is included in the MS office 365. But it is not suitable for larger organization due to lack of work sharing environment.
We selected Microsoft Access for its lower price and because it is easy to use for any user. Previously in the company, because we were small, Excel was used and I can migrate my data from Excel to Access in a fast and simple way. Besides that, it has organized information that …
Verified User
Analyst
Chose Microsoft Access
Microsoft Access is a good data management tool. and it excels in that area, which is what we needed the most. It was simple to use and easy to learn. Database management can be done with multiple users in Access. And we can have reports for data summaries, or for any specific …
I find access easier to use than base or thunderbird but if you are familiar with Microsoft Office products, the learning curve is lessened by that. There is no comparision to SQL or MySql, but these are meant for larger more robust database applications. Access was actually in …
We use Oracle Database for another business unit and in the recent past I’ve used Microsoft Access. While every relational database has its positives and negatives, MySQL has proven to be the fastest and most reliable. Its automated backups have saved us time in redoing mass …
It would be hard to make a case for the use of Microsoft Access for any but the most simple of internal business applications at this stage, not because it is a bad product but it falls well short of the power and scalability of MySQL and almost any other databse solution out …
MySQL has a GUI which makes it easy for developers to work upon. It has all features like replication, backup and crash recovery. Also since it is freely available it becomes commercially feasible for people to use this DB. Also MySQL can be easily used as a back end for the …
Our original implementation of MySQL was to replace an Access database that had unfortunately been able to grow beyond its abilities and scope. MySQL seemed to offer all the benefits of Access (easy to set up, use and administer) with none of the downsides (reliability, …
Familiarity: With MySQL, I know what to expect, and that goes a long way. Also, since it adheres fairly close to SQL '92, It's relatively easy to construct queries, views, etc. without a steep learning curve. Also, RAM usage is important (this is true of any RDBMS …
SQLLite was not a choice on Trust Radius, and it is the only tool that I have used similar to MySQL and the use was several years ago, so I do not remember the exact reason but there was some function that I needed that SQLite could not perform, and I had to download MySQL to …
Cuts down seperate charges for additional databases as in Microsoft SQL Server. It is an open source software compared to other database management systems.
Compared to Oracle MySQL is lacking some of the advanced features Oracle provides but through a detailed business and technical requirements capture process it became clear we would not need these very advanced features. Oracle is stronger on the backup and restore side of …
MySQL stands in better place when it comes to cost. It is also an inexpensive database. We selected this database due to the cost as first reason. Secondly we do not have complex database manipulation requirements separately. Occasionally we need to generate reports which we do …
The .NET platform has a much longer and broader history than Laravel, so we chose to go with it as the support will be far superior. Additionally, Laravel is tied to PHP, while you can use multiple different languages in .NET. The additional flexibility that .NET provides in …
As a Material Purchasing/Planning/inventory tracking application, Microsoft Access serves its purpose well. It's presentation is clean, data entry is simple and the ability to customize search fields is welcome. It does, however, come with some caveats; namely, when setting search filters and the need arises to back up a step or two, with Microsoft Access you have to reset, or "clear all", adding extra steps/time to a query.
MySQL is best suited for applications on platform like high-traffic content-driven websites, small-scale web apps, data warehouses which regards light analytical workloads. However its less suited for areas like enterprise data warehouse, OLAP cubes, large-scale reporting, applications requiring flexible or semi-structured data like event logging systems, product configurations, dynamic forms.
.NET is well suited for any general purpose solution to a business problem, though if we are talking strictly the framework version - you have to be more or less tied to Microsoft Windows to run it. If this isn't a problem, then it will be able to address and solve any programming project you have.
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.
Learning curve: is big. Newbies will face problems in understanding the platform initially. However, with plenty of online resources, one can easily find solutions to problems and learn on the go.
Backup and restore: MySQL is not very seamless. Although the data is never ruptured or missed, the process involved is not very much user-friendly. Maybe, a new command-line interface for only the backup-restore functionality shall be set up again to make this very important step much easier to perform and maintain.
.NET is heavily Microsoft Windows oriented, and while .NET core tried to resolve that with MacOS and Linux support, .NET Core is still waiting for wider adoption.
While free for small projects, additional features for big projects can be a little expensive.
Can be resource-heavy upon deployment. We continuously have our more senior staff optimize the code of our junior developers for performance. Other languages are a little bit more forgiving in comparison.
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.
For teaching Databases and SQL, I would definitely continue to use MySQL. It provides a good, solid foundation to learn about databases. Also to learn about the SQL language and how it works with the creation, insertion, deletion, updating, and manipulation of data, tables, and databases. This SQL language is a foundation and can be used to learn many other database related concepts.
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.
I give MySQL a 9/10 overall because I really like it but I feel like there are a lot of tech people who would hate it if I gave it a 10/10. I've never had any problems with it or reached any of its limitations but I know a few people who have so I can't give it a 10/10 based on those complaints.
The full .NET Framework is an amazing thing and is very robust. We have used it to create console apps, Windows apps, and online apps. When coupled with Visual Studio, development, testing, building, and deploying our applications has become 100 times easier as compared to doing those things manually before. The automation of this process has helped us push out changes to our applications faster to adapt to the ever-changing business requirements.
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.
We have never contacted MySQL enterprise support team for any issues related to MySQL. This is because we have been using primarily the MySQL Server community edition and have been using the MySQL support forums for any questions and practical guidance that we needed before and during the technical implementations. Overall, the support community has been very helpful and allowed us to make the most out of the community edition.
You don't often need to reach out to Microsoft for .NET support. If you do, there are forums and websites that have active Microsoft support folks where you can provide feedback or get help. Microsoft support in general is quite good as well, but not cheap. The best support is from the community like StackOverflow.
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 knowledge of data manipulation.
MongoDB has a dynamic schema for how data is stored in 'documents' whereas MySQL is more structured with tables, columns, and rows. MongoDB was built for high availability whereas MySQL can be a challenge when it comes to replication of the data and making everything redundant in the event of a DR or outage.
The .NET platform has a much longer and broader history than Laravel, so we chose to go with it as the support will be far superior. Additionally, Laravel is tied to PHP, while you can use multiple different languages in .NET. The additional flexibility that .NET provides in the range of types of applications you can build with it sealed the deal.
There are few factors we needed for our custom development. Below are each of them. We were able to get a satisfactory outcome for each of these factors which made .NET platform a very good choice in developing enterprise applications.
Reusability of codes- Microsoft has given many re-usable codes and components in the framework to help developers do their job effortlessly. With the help of default features, developers can create end-to-end solutions and make the business operations more efficient. As codes and components are reusable, .NET reduces development time and if applications take less time to develop, they cost cheaper and you get faster return on investment.
Easy to maintain- Development cost is one time, but maintenance cost is incurring. .NET apps are easily maintainable, thanks to the configuration settings that can be modified without any need to rewrite the code.
Deployment is hassle free- Deploying software is always challenging and the most common problem developers face in this process is the existence of multiple DLLs. It’s hard to make sure that all DLLs will co-exist in the same machine. .NET framework solves this problem by allowing different versions of the same DLL to exist side-by-side on the same machine.
Security- .NET is one of the most secure web and application development frameworks available in the market. As it’s made by Microsoft, you can be absolutely sure about the security measurements. Hackers can never steal valuable data from your website or apps.
Cross platform friendly- What if you had developed an app for desktop and laptop computers and now after seeing the growth of mobile apps in the market, you want it in mobile version as well? You can easily develop an app that runs on the desktop and PDA without any issue. As you can re-use the codes and utilize the same development environment, your job becomes a lot simpler.
