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
SAP Business One
Score 8.3 out of 10
N/A
SAP Business One is an integrated enterprise resource planning (ERP) solution for small and medium-sized businesses, The product encompasses functionality around sales, customer relationships, inventory, operations, financials and human resources.
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 …
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 …
SAP Business One is a good fit for an organization that wants to transform its business operation with a reasonable cost for migration from the legacy system. SAP Business One can match and support the organization needs because it has most of the best business practices …
We did not use many ERP systems yet so I'm unable to go to much in detail. We tested some and the main issue was the pricing. Good alternatives would be Oracle NETSUITE, Microsoft Dynamics if your company is Microsoft based with al the other programs (great integrations). And …
This tool is ideal for companies that are dedicated to the management of wholesale sales, marketing and distribution of retail products, the way it integrates inventory management tools, marketing, sales, as well as the management and projection of client portfolio is ideal for …
SAP provides the most robust solution, with modules available for all department managers and even options for customization according to the company's special needs. We especially used the Crystal reports options to provide reports for each module. Overall, even if it's not …
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.
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.
SAP Business One would be more useful if it contained tools to acommodate the growing need of online sales. A more complete shipping module which handles tracking numbers with the common couriers would be great. A built in warehouse management system would be great designed to be used with barcode scanners
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.
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.
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.
Following a bench mark process - this seems contradicting to flexibility however we have wished we could follow more of an industry benchmark. Our challenge as a small company has been knowing how to properly use the system. We have discovered that we have set up the system wrong based and are using it improperly which has cause a lot work to correct.
Better live reporting options - current we are on prem SQL. Yes SAP is moving to HANA however smaller companies like ourselves are not ready for that. We need to be able to maintain our existing SQL DB. We also have a demand for live BI Reporting. It has been difficult to do this with our current set up.
Error handling - have found it very difficult to troubleshoot. Errors are not always clear and answers are hard to find.
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.
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.
As I said before, it is a first level tool, well developed, and with very strong development support, although the learning curve, its implementation, the cost-benefit ratio, the price and the user experience is not the most suitable for small and medium-sized companies. It is a company with extensive experience, market positioning, technical support and expanded use
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.
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
I would like to give 8 out of 10 rating for SAP Business One because SAP Business One is a good choice for the mostly used business management solutions for the small and medium-sized companies. SAP Business One can help in optimizing the existing business process and enables streamline business processes for the daily activities for all users across the entire organization. The importance realization of SAP Business One implementation is based on the selection of the good reputation partner and its approach for the entire implementation. SAP Business One is a user-friendly and easy to use Enterprise system that the organization can benefit its features and functionalities by utilizing it.
The SAP Business One software is up and running every time you need it as it was planned. In more than 6 years that we have been using the product, it has never been unavailable and if it ever was, it was because of a planned maintenance window scheduled in the company.
SAP Business One performance depends mostly on the speed of your internal servers, should you have the solution on premise as we do. Sometimes the system tends to be a little slower for some users when others are executing really big reports of performing some batch loads, but generally, the performance is acceptable to all the users.
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.
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.
I rate my experience with SAP Business One's support team as excellent (10). They are easy to contact and effortless to work with on any issue or concern. I like the support SAP provides for any of their products. SAP has a great backing and I would recommend them to any of my colleagues.
The training I get was a consultant level training, so it's basically a 6 weeks training covering every aspect and every module of the system. It covered most common use cases and exercise training so you can get along with the software, as well as examples so there culd be a better understanding.
Over the past two years SAP has added a great deal of new SAP Business One on-line training for version 9.0 and 9.1. Most of the training is very strong, but some is difficult to understand and follow. Additionally, SAP still has a few holes in their on-line training around Production, Bill-of-Materials, MRP and Service.
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.
These implementations are not easy. Even a standard implementation can be difficult. With a never-been-done-before implementation, the implementation team and the user team need to be thorough with planning, make a decision on key points, and stick to them before any design happens. Our biggest challenge was not from StellarOne, rather it was from the mid-implementation decisions from our internal team. StellarOne did a great job warning us, implementing our decision, and then helping us adjust our SAP to handle the new direction we took.
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.
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
SAP provides the most robust solution, with modules available for all department managers and even options for customization according to the company's special needs. We especially used the Crystal reports options to provide reports for each module. Overall, even if it's not the least expensive option, it has the best value for money.
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.
For most small businesses, the only way you outgrow SAP Business One is if the nature of your business changes radically. Going from 1 to 50 users is quite easy with SAP B1. Going beyond 50 may require moving to the Hana SAP B1 platform to maintain or improve performance, but the path is there. Add-ons to SAP B1 can also be added as specific needs are encountered that are not closely met by the standard product. These may be required early in the product life because of the nature of your business, or as you expand the use of SAP B1.
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.
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.
Employee efficiency has definitely increased with SAP Business One. This is attributed in a lot of ways to information visibility. Our employees are able to gather the data they need, quickly, and effectively.
Identifying inconsistencies in pricing has also been accomplished through use of reporting off individual tables. Previously, we weren't able to access our data in such a way as to enable us to write custom reports in-house.
We have also benefited greatly from having a single source of all business information. We utilize SAP Business One exclusively in-house. All documentation is attached to specific orders and Business Partners, as well as serialized equipment that has been sold.
