Amazon Web Services vs. Microsoft Access

One of the scenarios I can think of is to Deploy a web application that may experience fluctuating traffic. AWS EC2 and Elastic Beanstalk allow for quick deployment and easy scaling accommodating traffic spikes without downtime. Next thing is to analyze large datasets for business insights. AWS services like EMR (Elastic MapReduce) and Redshift enable efficient processing and analysis of big data with minimal setup. Now for one of the scenarios where is less appropriate is if we want to host a simple static website, for basic sites using a dedicated hosting service like GitHub Pages or Netlify may be simpler and most effective than AWS

Incentivized

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

• Starting an instance and accessing it for testing purpose, demo or production deployment its always easy.
• All the things which are available over AWS are pretty well managed and easy to use.
• You might find everything you required for an product and other development over AWS.
• Its suitable for both either an enterprise or an startup
• Various resources and documentation are available in case you struck somewhere.

Incentivized

• Very easy to create entity-relationship diagrams for various tables and designing mock layouts.
• Really easy to navigate as it hold[s] the classic Microsoft UI. Another good thing is that it comes with the complete MS Office Suite.
• It is really fast when joining multiple tables no matter what type of join.
• Works on pretty much same SQL scripts so no need to learn a new language!

Incentivized

• If there is one thing I think AWS needs improvement on, it is the administration dashboard. It can be a nightmare to use especially when trying to access billing. This could be made better, honestly, as there should be a simplified way to access simple admin features.
• While AWS was fairly easy to integrate into our solutions, it is not as easy to use without some IT knowledge. The dashboards are complicated and designed for someone who is computer savvy. If you are just want to keep track of billing, for example, you may need to take a course or spend a few hours with someone being walked through the admin console.
• AWS does tend to be slow at times. If you do not have a fast internet connection, it can take time to access services that are hosted on AWS. This is not always the case but we have had clients complain about this if they are trying to access a service from multiple points (IP addresses). The only real fix we found was to make our files cache to another server and only keep current data accessible to clients.

Incentivized

• 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.

Incentivized

We are almost entirely satisfied with the service. In order to move off it, we'd have to build for ourselves many of the services that AWS provides and the cost would be prohibitive. Although there are cost savings and security benefits to returning to the colo facility, we could never afford to do it, and we'd hate to give up the innovation and constant cycle of new features that AWS gives us.

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.

Amazon Web Services is a great tool when it comes to middle size organizations like us. It provides multiple tools and functionalities in low costs. The best feature we have to pay as we go. No financial burden on company for the unused instances. It also comes with greater level of security such as two level authorization such as multi factor authorization.

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

Availability is very good, with the exception of occasional spectacular outages.

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

AWS does not provide the raw performance that you can get by building your own custom infrastructure. However, it is often the case that the benefits of specialized, high-performance hardware do not necessarily outweigh the significant extra cost and risk. Performance as perceived by the user is very different from raw throughput.

The customer support of Amazon Web Services are quick in their responses. I appreciate its entire team, which works amazingly, and provides professional support. AWS is a great tool, indeed, to provide customers a suitable way to
immediately search for their compatible software's and also to guide them in a
good direction. Moreover, this product is a good suggestion for every type of
company because of its affordability and ease of use.

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

The API's were very well documented and was Janova's main point of entry into the services.

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

Amazon Web Services is well suited when we have a huge amount of data to store, process, manipulate and get meaningful information out of. It is also suitable when we need very fast data retrieval from the database. They provide a superior product at a fair price which allows us to further our goals and push the limits of what we are capable of as a team / company.

Incentivized

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.

Incentivized

• AWS has lowered our employee cost, because you don't have to hire Network/Server Admins to manage infrastructure.
• Increased productivity by incorporating Continuous Integration with AWS and our development life cycle.
• Increased customer confidence by being able to provide HIPAA level security in our development and production environments

Incentivized

• Not having to recreate queries or reports every time you want to use them.
• Once an item is created and saved as part of the database, you save manpower by not having to recreate them.
• ROI from a usability standpoint is great. Solid product with great functionality that requires low maintenance usually.

Incentivized