What users are saying about
Top Rated
74 Ratings

Microsoft Access

<a href='https://www.trustradius.com/static/about-trustradius-scoring#question3' target='_blank' rel='nofollow'>Customer Verified: Read more.</a>
516 Ratings
Top Rated
74 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow'>trScore algorithm: Learn more.</a>
Score 8.4 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>
516 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow'>trScore algorithm: Learn more.</a>
Score 7.4 out of 101

Add comparison

Likelihood to Recommend

Amazon RDS

Amazon Relational Database Service is great when you need a Database solution that can work for you very fast. It is also a great solution when you need a system that can scale to handle very large amounts of data. You can get set up with a complex, large database eco-system in minutes/hours, and have the best security and backups scheduled. The alternative to doing this would typically be hiring one or more very experienced database professionals for not just the implementation, but also on staff to handle the periodic maintenance necessary.
Gabriel Samaroo profile photo

Microsoft Access

Microsoft Access is very suitable whenever the objective of the project is a database where:1. The timeframe of the project must be short and the start of the project must be immediate.2. Specialised personnel from IT department is not available, due to their own prioritization scheme.3. The designer tasked with the design, implementation and deployment of the database, is a technically-oriented person in general, but having no previous knowledge of Access in particular.4. The size of the envisaged database is relatively small, both in the number of records to be stored in it, as well in the number of concurrent users. Microsoft Access is not suitable when:1. The requirements are for an 'Enterprise' type of database, expected to acummulate over time a very large number of records (large manufacturing company, storing many parts numbers over the years).2. The database is expected to be access by a very large number of users concurrently (e.g., a bank, accessed by numerous customers simultaneously).3. The time taken by the execution for each transaction must be as small as possible.4. The database must be of 'industrial strength', meaning very reliable, with no crushes and no corrupted records.
Fred Abraham, P.Eng profile photo

Pros

  • End-to-end management of your database -- including configuration, handling security, and maintenance.
  • Offers compatibility with many (and the most popular) database technologies -- including but not limited to MySQL, Postgres, Microsoft SQL Server, Oracle DB.
  • Makes backups and replications very easy, which is one of the toughest things to do effectively.
Gabriel Samaroo profile photo
  • An Access database can be designed and put to use rather fast, in order to answer an immediate need, even if the design must be done by someone with no previous exposure to Access. It can be modified/improved later on, without much impact on the users.
  • A relatively simple Access database does not require knowledge of any programming language. It can be implemented by using 'macros', which are of a 'point-and-click' type.
  • If a more complex application is required, Access is fully compatible with Visual Basic for Applications language, which is a object-oriented, even-driven programming language, designed by Microsoft specifically for utilization by all modules belonging to the Office suite.
  • Since the commonality of VBA across Office, Access databases can be made to interface with other Office applications, and in particular with Excel.
  • Access is easy to master, cheap, and allows easily the construction of aesthetically pleasing interfaces with the user, while remaining quite powerful. Due to these reasons, it yields itself to be sometimes used for the design of non-database applications, but specialized calculators.
Fred Abraham, P.Eng profile photo

Cons

  • Unable to run custom software on RDS servers
  • Customer support is lackluster
  • Price
No photo available
  • Microsoft Access does have its limits in terms of performance. Our use for it does not mean we've reached this point yet, but we are a relatively small organization. For a larger company, I'm not sure how well Access would suit the needs of high data usage, or multiple users in the tens or hundreds.
  • The front end interface could be viewed as fairly simplistic (it's not the newest software out there in this category as far as I know). I don't necessarily mind this fact, but I could see it being viewed as a negative in certain situations.
Ryan Husbands, MBA, CPA profile photo

Likelihood to Renew

No score
No answers yet
No answers on this topic
Microsoft Access9.4
Based on 16 answers
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.
Alyssa Moy, MBA, PMP profile photo

Usability

No score
No answers yet
No answers on this topic
Microsoft Access7.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

Reliability and Availability

No score
No answers yet
No answers on this topic
Microsoft Access8.0
Based on 1 answer
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.
No photo available

Support

No score
No answers yet
No answers on this topic
Microsoft Access7.5
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

RDS provides all the features of databases you could host yourself, without all of the maintenance and headaches required, while providing more flexibility and lower TCO.
Tim Weisbrod profile photo
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

  • We do not require dedicated database admins, which saves both money and man power. It's easy for developers to manage infrastructure thanks to RDS.
Arjun Komath profile photo
  • Microsoft Access has had tremendous ROI because of the amount of data it can translate at minimal cost.
  • Access has helped streamline operation reporting since it has much more flexibility with large datasets when compared to Excel.
  • Using Microsoft Access has made the operation/accounting reporting more meaningful and helped cut down on time to prepare reports.
Lukas Sundahl, MBA profile photo

Pricing Details

Amazon RDS

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