What users are saying about
50 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring#question3' target='_blank' rel='nofollow'>Customer Verified: Read more.</a>
553 Ratings
50 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow'>trScore algorithm: Learn more.</a>
Score 8.8 out of 101

Microsoft Access

<a href='https://www.trustradius.com/static/about-trustradius-scoring#question3' target='_blank' rel='nofollow'>Customer Verified: Read more.</a>
553 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow'>trScore algorithm: Learn more.</a>
Score 7.6 out of 101

Likelihood to Recommend

Amazon Aurora

Many places where Aurora is well suited:
  • If you are trying to build a serverless backend.
  • Amazon hosted relational database service (RDS). So we do not have to manage the database maintenance.
  • Backup and archival can be done to AWS S3, which is very convenient.
  • It provides high performance and scalability.
  • It's very secure. You could use AWS Key management service (KMS) to encrypt and store data on AWS Aurora.
No photo available

Microsoft Access

It is best used when you want a database to track historical data with a lot of inputs and relationships. A great example is tracking information on construction projects: you can input all the information that you have about a particular historical project, about pursuits that you are tracking, etc. (the same could be said for any sales area actually), then easily pull specific types of historical information for current proposals and pursuits. That is what I use it for.
Che Odom profile photo

Pros

Amazon Aurora

  • Aurora is a relational database as a service on AWS which is MySQL and Postgres compatible. So if you are looking for a serverless option which going through need to host and manage a database then Aurora as a service is great.
  • It is a simple and cost-effective open source database which is much cheaper than a normal database cost. Hence very efficient for microservices database where you do not need one very large centralized database but many small databases that are available and low latency.
  • Aurora provides high performance and low latency. Last year they also announced multi-master in the same region and read replicas in multiple regions. This is very convenient if you are trying to design and build a highly reliable application.
No photo available

Microsoft Access

  • Organization - Its layout is particularly conducive to organizing data and is very user-friendly. Working with data is simple so long as you have a working knowledge of either building your own forms/reports or SQL.
  • Integration - Since Access is an Office product, it integrates nicely with Excel. This allows for not only the freedom of designing the data and reports you generate but also that it is quick to pick up as most people have some experience with Excel.
  • Support - Since there is already a large compendium of help and useful tricks/tips for Office products, there is always an answer to whatever question you may have or outcome that you are trying to achieve.
Joseph R. Sweeney profile photo

Cons

Amazon Aurora

  • Without direct access to the instances it isn't possible to do a few things you'd be able to do if you were running your own database server, but this is rarely an issue
Andrew Raines profile photo

Microsoft Access

  • It can be made more User-friendly
  • Some help tutorials will help to elaborate on all features
No photo available

Likelihood to Renew

Amazon Aurora

No score
No answers yet
No answers on this topic

Microsoft Access

Microsoft Access 9.4
Based on 16 answers
Aside from supporting several systems that are still in use after years, and further development of these existing databases, Access continues to be a 'go-to' solution to rapidly prototype a data model. Such prototypes are useful, even when other larger solutions may later be selected for deployment, but often prove robust enough for actual usage as well.
Tim Ritter profile photo

Usability

Amazon Aurora

No score
No answers yet
No answers on this topic

Microsoft Access

Microsoft Access 7.0
Based on 3 answers
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.
No photo available

Support

Amazon Aurora

No score
No answers yet
No answers on this topic

Microsoft Access

Microsoft Access 7.4
Based on 2 answers
I intend to elaborate very soon via another update, after checking some of my notes.
Fred Abraham, P.Eng profile photo

Alternatives Considered

Amazon Aurora

In the end, we went with Amazon Aurora due to the decent performance and cost. Cost was determined in two ways for us: 1) no additional license is required (such as using SQL Server or Oracle) and 2) the ability to cut down on needed resources to maintain the system from the maintenance perspective due to the built-in maintenance capabilities. Amazon Aurora is also based on MySQL (soon to include PostgreSQL ) which allowed my team to quickly and easily move our existing MySQL servers to a faster system.
No photo available

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 purpose.
No photo available

Return on Investment

Amazon Aurora

  • The main positive for my team is the time that has been freed up from the tasks of managing updates and fixing replication issues.
  • A negative for myself as a database administrator is removal of features that were available in Mysql. Examples include 1) the use of the storage engines other than InnoDB (such as the Federated Storage Engine), 2) certain administrative privileges such as ability to export to csv file and easy ability to kill processes. I seem to also forget they removed the built-in kill ability and you must use their own provided kill functionality.
No photo available

Microsoft Access

  • This product has allowed us to assist average business users with data they know is needed or actionable in a business sense to rapidly make use of said data without waiting for a larger IT project to deliver something. I have seen this be very profitable.
  • Easier customization and development cycles have meant that a solution can rapidly adapt to changing business needs.
Tim Ritter profile photo

Pricing Details

Amazon Aurora

General

Free Trial
Free/Freemium Version
Premium Consulting/Integration Services
Entry-level set up fee?
No
Additional Pricing Details

Microsoft Access

General

Free Trial
Free/Freemium Version
Premium Consulting/Integration Services
Entry-level set up fee?
No
Additional Pricing Details

Add comparison