Asana vs. Microsoft Access vs. Smartsheet

The usability of Asana is broad since it's available in a variety of platforms that are widely used nowadays. I think that it would be great for people who are constantly on the move and switching devices, since it has allowed me to work from my phone, too. I also think that Asana has proven itself to handle a large quantity of work

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

Smartsheet shines for collaboration. When you have multiple people involved with planning events Smartsheet makes it easy to share and collaborate. For instance, multiple people can be in Smartsheet working at the same time. Also setting permissions for exactly those who need to know is quite easy with Smartsheet. For data analytics and general spreadsheet purposes Excel is better but for project management and event planning Smartsheet is superior

Incentivized

• Through it, we were able to communicate and cooperate with the rest of the team to complete the work in the required manner and at the appropriate time.
• Available for free on Android and iPhone.
• Asana has a simple and easy user interface

• 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

• Its hard to overstate the value of familiarity. Being able to use a tool that has some familiarity takes away the time needed to train and orient employees on a new tool and allows an organization to hit the ground running.
• Smartsheet covers most of the basics of a project management tool, the usual tasks, milestones and project viewing options.
• For data viewing, you get multiple data viewing options including a calendar view (good for marketing teams and those who work around scheduling), Kanban, Gaant etc

Incentivized

• Asana is not really a project management tool, it is good for simple projects only
• UI has some glitches (doesn't save preferences, etc.)
• Integration with other tools (Office 365, MS Project)
• No reminders if the working period you entered is on holidays

Incentivized

• 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

• Smartsheet set up is similar to Excel, yet when you upload an Excel file, things like conditional formatting are lost. Smartsheet has its own conditional formatting, and you have to reinstate the rules. It would be great if those would apply automatically once a file is uploaded
• Some Smartsheet management and access rules can take some tweaking to work properly. This may be a case of offering more info to admins so they can apply these better and with more efficiency

Incentivized

• Mobile + Desktop capabilities - Able to use it anywhere, anytime.
• Task management - Easy to view projects and their progress.
• Time management - Easy to see what elements require time / how they interrelate and manage the project on an overall basis.
• Company management - Be able to see from a master dashboard perspective where each project is in its stages of completion.
• Clear communication - It's visually documented who is doing what at what time so that the whole project gets done.

Incentivized

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.

It definitely meets our needs as far as organizing and archiving our tasks and files. As we train more staff to view it, I see opportunities for more improvement, which I am sure this program can handle. I look forward to seeing continued improvement from Smartsheet on their capabilities and functionality.

Incentivized

It is very user-friendly. Takes a new employee an hour to start figuring out how the system works. That's an important factor. You don't want to encounter the issue where employees need a week to understand how the system works. For example, JIRA, I tried using it for a week and I still don't understand the complicated layout. Asana has a simple interface. Once you see it, you get it type of program.

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

Smartsheet is very easy to learn. However, while I have been able to pick it easily, Microsoft Excel and Project super users that I have trained on Smartsheet get bogged down in the differences and can find it frustrating. Explaining the differences ahead of time and why Smartsheet is being chosen instead of a different software seems to counteract those reactions

Incentivized

Working with Asana on a daily basis

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

I haven't had to use their support so I can't rate it. The fact that I haven't needed them reflects the ease of use of the product. I would recommend that any new users schedule a complete demo of the product to ensure that they are using it to it's fullest (there's a lot of useful features).

Incentivized

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

I give this rating because it fills a niche in the market. MS Project scares many away from proper task management but there are limited tools our there, especially cloud-based that are mobile-friendly. Smartsheet fills this market gap, especially for small to medium-sized businesses. IT is not fair to compare it to MS Project, but fairer to see what gaps it fills.

Incentivized

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

It's absolutely paramount to take a few minutes to actually play with the software. It's nearly impossible to do anything wrong or make a mistake which cannot be fixed easily. Under the help menu is Live Training option. After you familiarize yourself with the commands, watch the live training for some in depth understanding of how to make the software fit your needs perfectly.

Asana is a top-tier project management software that helps us organize and track projects from start to finish. It allows us to apply tasks/to-dos to multiple projects without duplication, divide complex projects into smaller tasks, and track project progress. It also helps us organize work on Kanban boards or linear lists. It stands out from the crowd in a big way compared to the competition.

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

Jira and Redmine are much more robust and technologically advanced project management solutions. I enjoy using either when managing a very large project. However, I prefer to use Smartsheet for my smaller to medium sized projects. As for Google Drive - I would say that Google sheets and Smartsheet are almost identical in my opinion when it comes to functionality. Personally I prefer to manage smaller projects via Google Drive, but it is a personal preference!

Incentivized

I used this tool on a daily basis at work and it runs as a solid rock

• Productivity - Most of all, it allows me to be more productive and have a good sense of where I am with projects and deadlines.
• Easy to use - I can make the most of my time to get up (and stay) up and running.
• Project coordination - Allows me to assign tasks to my interns and communicate directly within the platform to keep the work train moving.

Incentivized

• 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

• This has really opened up collaboration across teams. A lot less working in silos.
• It hasn't fully replaced any one tool so it means having to go to another place. Hopefully, we can eliminate a tool or two in the next six months.

Incentivized