AppSheet vs. Microsoft Access vs. SAP HANA Cloud

If you need to manage special assets with unique characteristics and keep data in spreadsheets, Appsheet is ideal for replacing these sheets with a system. Once you start using it, you find yourself trying to move everything into Appsheet. It is perfect for generating internal software that would otherwise never be developed due to programming costs.

Incentivized

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.

Incentivized

I think if you have a large organization, it's probably the product and the marketplace to go to. We're a large management consulting firm operating in four to seven countries. And generally speaking, I think that's the size and the scope where it scales best. I can't speak to smaller companies, but I can't see smaller companies leveraging the benefits as much as a larger organization can.

Incentivized

• Calculations - I have several apps that do some pretty complicated calculations, and decision making to build things like Shopping Lists for a Kanban assembly team, where the app will help a stocker determine whats low in a kanban assembly line stock box.
• Document generation and record keeping - I have an app that users digitally sign and receive PDF contracts, and the system automatically records all records from the transaction. Everything is held in files on YOUR OWN DRIVE (Google Drive) so when you're done with the project or AppSheet you DONT loose your data.
• Client/Customer Management - I follow the old school "Swimming with Sharks" model for client retention and customer engagement, and have built several small customer tracking tools for local businesses. This tool is limited ONLY by your imagine and desire to learn.

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

• Real-time reporting and analytics on data: because of its in-memory architecture, it is perfect for businesses that need to make quick decisions based on current information.
• Managing workload with complex data: it can handle a vast range of data types, including relational, documental, geospatial, graph, vector, and time series data.
• Developing and deploying intelligent data applications: it provides various tools for such applications and can be used for machine learning and artificial intelligence to automate tasks, gain insights from data, and make predictions.

• Once the tables / UX Views get way too many in number, it can become a little daunting to manage. This part of the UX may need something really smarter.
• Ability to Undo.
• Could provide more UI Look and Feel options. BTW, the new Graphs look great, but have some bugs, while the new INPUT() feature is a great addition too.

• 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

• Requires higher processing power, otherwise it won't fly. How ever computing costs are lower. Incase you are migrating to cloud please do not select the highest config available in that series . Upgrading it later against a reserved instance can cost you dearly with a series change
• Lack of clarity on licensing is one major challenge
• Unless S/4 with additional features are enabled mere migration HANA DB is not a rewarding journey. Power is in S/4

Incentivized

We are still less than 10 users and probably may continue to be so. But, this being a franchisor set up, could be of use to other users like 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.

We would rate our likelihood of renewing at 9/10. SAP HANA Cloud has proven to be a highly reliable and scalable data platform that consistently delivers strong performance. Its seamless integration with our overall SAP landscape, combined with improved analytics and real-time data capabilities, makes it a core part of our long-term technology strategy.

Incentivized

It's just great. The usability is the best thing about Appsheet. You must choose which things will really be used later. You have to be careful of not generating something too big and then it feels like something that need to be learned. This is something that resolve problems, but you had to be able to think before doing. It will not solve problems itself. You need to find the problem, think a solution, and then use appsheet to make this solution a reality

Incentivized

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

It is very useful solution which provides you speedier data processing, real-time analytics. It helps you manage diverse data types. It also offers you excellent disaster management. It has user friendly interface which helps you navigate system and transactions easily and perform task smoothly.

Incentivized

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

so far, we didn't get any outage

Incentivized

so far good

Incentivized

AppSsheet has a support group and they show videos to help app builders. Though I have truck drivers' hours and can't join the webinars. Support groups with better assists me on a Saturday evening or a Sunday that I have time off. It's hard to watch videos driving down the highway.

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

However, I am not the right person to answer this as we have another department to handle support and contact the service provider for any support required. Although i will say that they are the quick respondent and knows how to handle querry of the customers and provide quick and better support.

Incentivized

I did everything on my own

Incentivized

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

Professional GIS people are some of the most risk-averse there are, and it's difficult to get them to move to HANA in one step. Start with small projects building to 80% use of HANA spatial over time.

Incentivized

The ease that AppSheet provides to the developer is limitless. Before starting with AppSheet I used other software, but they didn't give me the tools at my fingertips.
When I learned about AppSheet and everything it could do, I understood that it was what I was looking for, the ease with which everything is related within the app with a few clicks is impressive.

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.

Incentivized

I have deep knowledge of other disk based DBMSs. They are venerable technology, but the attempts to extend them to current architectures belie the fact they are built on 40 year old technology. There are some good columnar in-memory databases but they lack the completeness of capability present in the HANA platform.

Incentivized

I don't have visibility in licensing

Incentivized

Limitation of training deliverable by organization

Incentivized

We are still in process for the first applciaiton

Incentivized

• A good impact in general at the beginning since the free version allows great development so the investment in the implementation is of knowledge and time.
• As a consultant I have expanded my services through this platform including new low code application building services.

• 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

• ROI has always been high in terms of the functionality that it offers and the security features it comes with.
• Managing large volumes of data in real-time is not an easy task, but it does it pretty well with faster data processing.

Incentivized