Microsoft Access vs. Microsoft Dynamics 365

Overview
ProductRatingMost Used ByProduct SummaryStarting Price
Microsoft Access
Score 7.5 out of 10
N/A
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
Microsoft Dynamics 365
Score 8.0 out of 10
N/A
Microsoft Dynamics 365 is a CRM providing sales, marketing, and service functionality. It is offered as SaaS and on-premise. Dynamics 365 is part of the larger Dynamics suite of business intelligence and ERP products.
$44
per month
Pricing
Microsoft AccessMicrosoft Dynamics 365
Editions & Modules
Microsoft Access
$139.99
per PC
No answers on this topic
Offerings
Pricing Offerings
Microsoft AccessMicrosoft Dynamics 365
Free Trial
NoYes
Free/Freemium Version
NoNo
Premium Consulting/Integration Services
NoYes
Entry-level Setup FeeNo setup feeNo setup fee
Additional Details
More Pricing Information
Community Pulse
Microsoft AccessMicrosoft Dynamics 365
Considered Both Products
Microsoft Access
Chose Microsoft Access
I am sure there are other database systems, but for us we built mono focused systems to other products would have been web/cloud based HRIS systems.
Microsoft Dynamics 365
Chose Microsoft Dynamics 365
Our business switched from a year long Salesforce deployment to Microsoft Dynamics 365 Online in order to bring the program/project's data and database management in-house, eliminating the need for a Salesforce implementation consultant and resulting in significant cost …
Chose Microsoft Dynamics 365
Prior to deciding to purchase Mircosoft Dynamics CRM, our company looked into SugarCRM and Salesforce.com. We discovered that Salesforce would not prove across the board support of all the products we were currently using, namely SharePoint. In regards to SugarCRM, the annual …
Features
Microsoft AccessMicrosoft Dynamics 365
Relational Databases
Comparison of Relational Databases features of Product A and Product B
Microsoft Access
7.7
3 Ratings
4% below category average
Microsoft Dynamics 365
-
Ratings
ACID compliance7.02 Ratings00 Ratings
Database monitoring8.02 Ratings00 Ratings
Database locking8.03 Ratings00 Ratings
Encryption7.02 Ratings00 Ratings
Disaster recovery7.73 Ratings00 Ratings
Flexible deployment8.02 Ratings00 Ratings
Multiple datatypes8.03 Ratings00 Ratings
Sales Force Automation
Comparison of Sales Force Automation features of Product A and Product B
Microsoft Access
-
Ratings
Microsoft Dynamics 365
7.7
83 Ratings
2% below category average
Customer data management / contact management00 Ratings7.981 Ratings
Workflow management00 Ratings7.879 Ratings
Territory management00 Ratings7.160 Ratings
Opportunity management00 Ratings7.572 Ratings
Integration with email client (e.g., Outlook or Gmail)00 Ratings8.278 Ratings
Contract management00 Ratings7.961 Ratings
Quote & order management00 Ratings7.757 Ratings
Interaction tracking00 Ratings8.171 Ratings
Channel / partner relationship management00 Ratings7.362 Ratings
Customer Service & Support
Comparison of Customer Service & Support features of Product A and Product B
Microsoft Access
-
Ratings
Microsoft Dynamics 365
8.0
68 Ratings
4% above category average
Case management00 Ratings7.863 Ratings
Call center management00 Ratings7.850 Ratings
Help desk management00 Ratings8.457 Ratings
Marketing Automation
Comparison of Marketing Automation features of Product A and Product B
Microsoft Access
-
Ratings
Microsoft Dynamics 365
7.8
78 Ratings
0% above category average
Lead management00 Ratings7.672 Ratings
Email marketing00 Ratings8.171 Ratings
CRM Project Management
Comparison of CRM Project Management features of Product A and Product B
Microsoft Access
-
Ratings
Microsoft Dynamics 365
8.0
76 Ratings
4% above category average
Task management00 Ratings8.171 Ratings
Billing and invoicing management00 Ratings8.054 Ratings
Reporting00 Ratings8.065 Ratings
CRM Reporting & Analytics
Comparison of CRM Reporting & Analytics features of Product A and Product B
Microsoft Access
-
Ratings
Microsoft Dynamics 365
7.6
77 Ratings
1% below category average
Forecasting00 Ratings7.667 Ratings
Pipeline visualization00 Ratings7.773 Ratings
Customizable reports00 Ratings7.476 Ratings
Customization
Comparison of Customization features of Product A and Product B
Microsoft Access
-
Ratings
Microsoft Dynamics 365
7.7
80 Ratings
0% above category average
Custom fields00 Ratings7.678 Ratings
Custom objects00 Ratings7.572 Ratings
Scripting environment00 Ratings7.956 Ratings
API for custom integration00 Ratings7.861 Ratings
Security
Comparison of Security features of Product A and Product B
Microsoft Access
-
Ratings
Microsoft Dynamics 365
8.8
75 Ratings
5% above category average
Single sign-on capability00 Ratings8.869 Ratings
Role-based user permissions00 Ratings8.770 Ratings
Social CRM
Comparison of Social CRM features of Product A and Product B
Microsoft Access
-
Ratings
Microsoft Dynamics 365
7.7
44 Ratings
3% above category average
Social data00 Ratings7.843 Ratings
Social engagement00 Ratings7.643 Ratings
Integrations with 3rd-party Software
Comparison of Integrations with 3rd-party Software features of Product A and Product B
Microsoft Access
-
Ratings
Microsoft Dynamics 365
7.2
65 Ratings
4% below category average
Marketing automation00 Ratings7.665 Ratings
Compensation management00 Ratings6.834 Ratings
Platform
Comparison of Platform features of Product A and Product B
Microsoft Access
-
Ratings
Microsoft Dynamics 365
6.8
56 Ratings
11% below category average
Mobile access00 Ratings6.856 Ratings
Best Alternatives
Microsoft AccessMicrosoft Dynamics 365
Small Businesses
InterSystems IRIS
InterSystems IRIS
Score 7.7 out of 10
Salesmate
Salesmate
Score 10.0 out of 10
Medium-sized Companies
InterSystems IRIS
InterSystems IRIS
Score 7.7 out of 10
Creatio
Creatio
Score 9.1 out of 10
Enterprises
SAP IQ
SAP IQ
Score 10.0 out of 10
Creatio
Creatio
Score 9.1 out of 10
All AlternativesView all alternativesView all alternatives
User Ratings
Microsoft AccessMicrosoft Dynamics 365
Likelihood to Recommend
5.0
(99 ratings)
7.6
(103 ratings)
Likelihood to Renew
10.0
(15 ratings)
8.0
(20 ratings)
Usability
7.0
(5 ratings)
7.5
(33 ratings)
Availability
8.0
(1 ratings)
-
(0 ratings)
Support Rating
6.4
(5 ratings)
8.0
(11 ratings)
Online Training
-
(0 ratings)
7.5
(2 ratings)
Implementation Rating
10.0
(1 ratings)
9.2
(4 ratings)
Contract Terms and Pricing Model
-
(0 ratings)
3.8
(3 ratings)
Ease of integration
8.0
(1 ratings)
-
(0 ratings)
Product Scalability
5.0
(1 ratings)
-
(0 ratings)
Professional Services
-
(0 ratings)
9.0
(1 ratings)
User Testimonials
Microsoft AccessMicrosoft Dynamics 365
Likelihood to Recommend
Microsoft
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.
Read full review
Microsoft
Provides our company access to manage and customize the folds tailored to our needs. We needed to have certain paragraphs on certain paperwork per customer. MD 365 has those options to customize where needed and remove when not. The system is easy to navigate, and training can be done in a matter of days, even without prior knowledge of the system or similar systems.
Read full review
Pros
Microsoft
  • 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!
Read full review
Microsoft
  • Best to use for AP - like in our organization, there are plenty of AP bills, so with Dynamics, we can quickly enter the same into the Excel utility, which means CSV-based upload, and then we can easily upload the same to the software. It's a time saver.
  • Best for Bank reconciliation - MS Dynamics makes Bank reconciliation easy. Banks can easily sync with software and easily get reconciled.
  • Generating invoices to customers and directly sending them to their inbox is easy with this software.
Read full review
Cons
Microsoft
  • 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.
Read full review
Microsoft
  • Small learning curve, obviously. You won't figure this out in a day, a week, or even a month. But given time, you can learn to be an expert. Or you can always get a consultant or hire in somebody. But learning the tool isn't out of the questions by any means.
  • Licensing can be confusing at times and isn't cheap, but it is cheaper than Salesforce. Plus no additional fees for data calls to better integrate your D365 CE data with other systems.
  • The Classic user interface left a bit to be desired, but now with the much-improved Unified Interface, the web client and the mobile client look the same, much more modern, and have more flexibility and power behind them for customizers as well.
Read full review
Likelihood to Renew
Microsoft
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.
Read full review
Microsoft
CRM has allowed us to keep all of our data in one place that is easy for all users within the company to view. I came into the company after they had been using CRM for about 4 years. They have all said that since we have used this it has helped us control work processes better, it has allowed us to be able to track things so much better, and has been something that has helped unite many processes that used to be all over the place. We are currently using CRM 4.0 and are planning on upgrading in the next 18 months to the 2011 version. Support for 4.0 is almost all but dried up. Understandably so. Some of the customization we have done, and a plugins we use, are now contained within the 2011 version so we are looking forward to that upgrade. We use an email marketing company as well, and they primarily support the 2011 version, but their product connects and is integrated within CRM. This is a great benefit as well so that all of our marketing information can be contained in one location.
Read full review
Usability
Microsoft
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.
Read full review
Microsoft
The usability is easily adopted for users familiar with other Microsoft products. Dynamics 365 has several interfaces that cross over browsers and tablets. These multiple interfaces will be phased out and updated to a single unified interface eventually to provide the same usability across all devices. The backend configurations is slowly improving with the introduction of PowerApps compared to pre-D365 Online versions
Read full review
Reliability and Availability
Microsoft
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.
Read full review
Microsoft
No answers on this topic
Support Rating
Microsoft
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.
Read full review
Microsoft
Our partner, Ledgeview Partners has been FANTASTIC to work with. They are always timely in their response and have taken time to understand our business and our specific needs. We've made a lot of advanced customizations and they have been a great help in making those updates.
Read full review
Implementation Rating
Microsoft
there is no key idea, since it is easy to implement Microsoft Access
Read full review
Microsoft
We used a data warehouse to house our data, and our IT team and implementation vendor worked diligently ahead of time to construct idea implementation plans. Out of millions of records- we had less than a dozen errors, which is remarkable. My major insight is simply having a group of completely devoted individuals working towards your goal who fully understand the desired outcome. Focused resources for implementation season are critical to success.
Read full review
Alternatives Considered
Microsoft
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.
Read full review
Microsoft
Microsoft Dynamics was part of a system overhaul for a local school, and we looked at many products. If we had used it for a company with low turnover, then it might have been more feasible. They needed something a new person could learn quickly, someone who might also be learning marketing terms at the same time - especially if there is nobody to train the individual now expected to know the system. Similar issues occurred with all of these programs (we called it being too big for their britches), and one of the bigger things we liked was that it is more compatible with MS Office products in both technical and visual appeal. If you have a steady employees who use a CRM consistently, low turnover, and those who are very familiar with Office products, Dynamics would be the smartest option for you. Unfortunately, this was just not true for the school environment
Read full review
Contract Terms and Pricing Model
Microsoft
No answers on this topic
Microsoft
On our purchase, I'd been interrogated about our usage. Our needs are met by Microsoft Dynamics 365, which is simple to use. With so much data and information available, we must ensure that it is presented correctly to managers. Due to a lack of use, we don't have to spend as much money on Salesforce.
Read full review
Professional Services
Microsoft
No answers on this topic
Microsoft
My company's preferred program right now is Microsoft Dynamics 365. We use it to keep track of customers and important sales metrics in a streamlined manner. Anyone familiar with CRMs will find the tool extremely useful. Considering that we have a good turnover, this product will be used for its basic segments. As a result, there are few chances of error with Microsoft dynamics because it is so easy to use. Many options for recording data on these leads are available. It meets our needs and pays off.
Read full review
Return on Investment
Microsoft
  • 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.
Read full review
Microsoft
  • For those without a centralized, all in one solution for major HR, Finance and other departments, Microsoft Dynamics 365 has vastly improved employee time utilization and profit.
  • Migrating clients from on-premise to the cloud has reaped benefits including better security, no unscheduled downtime and frequent updates to functionality.
  • Those transferring from cheaper solutions have lost money in the aim to be better integrated with other Microsoft products and AI they don't really utilize.
Read full review
ScreenShots