Microsoft Access vs. Azure SQL Database

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.

Incentivized

Your upcoming app can be built faster on a fully managed SQL database and can be moved into Azure with a few to no application code changes. Flexible and responsive server less computing and Hyperscale storage can cope with your changing requirements and one of the main benefits is the reduction in costs, which is noticeable.

Incentivized

• Generates information about department events, services, orders, etc. quickly and in report form.
• Easy to design forms and reports with drag and drop components. You don't need to know coding.
• The ability to link tables and queries to get all the info needed for forms and reports
• Forms and reports are easy to customize and edit.
• Easily report your data grouped and sorted by any field

Incentivized

• Scalability is #1: if it used to be an almost no-win endeavour to try to modernize your server or migrate to other hardware, with Azure SQL Database it becomes a press of a button.
• All the tools simply work after you are on Azure SQL Database.
• The applications do not need changes in order to start using Azure SQL Database.
• Hybrid Cloud scenarios will work.
• Clustering and failover - already there.
• You can start monitoring the use and extract performance insights in a new way in Azure.

Incentivized

• Generally high learning curve for new users. Especially if they are not comfortable with technology.
• Desktop only program; not available in web-format like other O365 products
• Fewer experienced users, means it's a lot of self-teaching and troubleshooting when you run into an issue

Incentivized

• A little slow on processing complex or large Views. We use a lot of Views to feed our BI system, and the processing time could see some improvement, IMHO.
• Additional monitoring components would be nice too, automating some built in performance measurement tools would be a nice feature.
• Price can always be improved as well. It’s not bad, but room for improvement.

Incentivized

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.

This is best solution as a DBA one could expect from a service provider and as a cloud service, it removes all your hassles.

Incentivized

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.

Incentivized

The interfaces are intuitive once you are familiar with all the functions. The ability to use different tools to interact with the platform, such as directly via a browser or code editors such as VS Code or Visual Studio is a great option and allows for integrating withn the project and other testing and developing tools.

Incentivized

I don't think the program has ever failed me. It is one of those programs where there is always a solution if you know where to look.

Incentivized

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.

Incentivized

We give the support a high rating simply because every time we've had issues or questions, representatives were in contact with us quickly. Without fail, our issues/questions were handled in a timely matter. That kind of response is integral when client data integrity and availability is in question. There is also a wealth of documentation for resolving issues on your own.

Incentivized

there is no key idea, since it is easy to implement Microsoft Access

Microsoft Access is used independently of Microsoft's Office suite (also in use) at our company - the usual applications: Word, Excel, Outlook, etc. and does not really overlap. Microsoft Access was selected as a simple, functional inventory database based on ease of data entry, search functionality and avoiding the need for a separate ERP module.

Incentivized

I selected Azure SQL because it integrates nicely with the technology stacks we currently maintain. The pricing is right, and clients are happy with that. Scaling is easy. Most of our clients don't want to maintain a full-blown database server, and they don't need one. For them, Azure SQL is the right size.

Incentivized

• Microsoft Access is very low in cost as compared to its competitors and provides value for money spent.
• Comes with Office Suite for your whole organization. Easy to install and use.
• Many people had to shift to Windows in order to use those as there is no Mac version.

Incentivized

• Positive: very easy implementation!
• Positive: finally a good (easy) implementation of data masking, something we always neglected on premise.
• Positive: no maintenance!! No "server is down" messages on your phone at 3 'o clock in the morning.
• Negative: Too expensive to use for all other scenario's than a few very important applications.

Incentivized