Basecamp vs. Microsoft Access vs. Smartsheet

Basecamp is a wonderful tool for teams of varying degrees of technical knowledge, teams managing lots of different types of "agifall" and waterfall projects, and teams that are remotely distributed. It's probably less useful for more strictly agile-focused development teams, compared to other more flexible software applications like Jira and Asana.

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

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

• Task management - It is very easy to add, organize and discuss tasks within Basecamp's interface.
• The "Campfire" function is great for communicating when you just have a quick question for someone on the team.
• Notifications - Basecamp lets you decide how often and about what you'd like to be notified. The ability to respond to messages in Basecamp directly via email saves a lot of time.

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

• 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

• High Learning Curve. It's true that it can be easy to use, but to use well and effectively takes some time to learn. It's recommended to have an agreed-upon system in your team of what tools to use and when.
• Notification Overload. If people aren't careful they could send a notification to everyone when only a couple people were meant to be prompted. And since emails are sent by default, you could have your mailbox overloaded with unnecessary updates. This is where it takes a bit of training in your team to have an agreed-upon system.
• Lack of organization with Archived Projects. I will often need to reference an archived project to make a new one, but there is only a list of archived projects in alphabetical order, with no way to organize by archive date, or even search.

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

When I bring new people onto a project, it's immediately obvious how to use Basecamp. I don't have to worry about teaching them the features or walking them through it, it's just incredibly user-friendly. For this reason, I'll continue to renew my subscription even as new people are brought onto production jobs or the client changes.

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 easy to use, even for clients who have no experience with the platform. It can only get a little cumbersome to ensure that a client can't see certain documents you might want to keep in the Docs & Files folders. And sometimes, getting a client to actually use an unfamiliar platform can be a challenge.

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

I've never experienced downtime while using Basecamp, or been unable to access it when I needed it. That's not to say they've never had downtime, but I've been lucky enough not to encounter any, and I work odd hours, including late nights when maintenance is often undertaken.

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

For the many reasons I've given, Basecamp is a very strong program. There are a few features I can imagine that might make it even better, but I don't have a basis for comparison to be able to say that there is definitely a better one out there. I've noticed that Basecamp has evolved a bit from the time I started using it until now, so that makes me think that the producer of this program values it and believes in continuous improvement. If you could use the features offered by Basecamp, I would think you could use it with confidence.

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

Decide the process before implementation - i.e. when it's due 8/9 does that mean 8am, noon, 5pm, 11:59pm? Check your to-do list frequently Set-up templates - just not with the dates (they can be funky)

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.

Pretty good, but [Basecamp] has its drawbacks. Honestly I find the interface non-intuitive and sometimes have trouble figuring out how to change the status of a task. Perhaps it has something to do with the way it was originally set up by the admin, but I'm not sure. I liked Jira's drag and drop obvious functionality, but the project management side of the software was lacking. Smartsheet has excellent project management functionality, but the task management isn't as good.

Incentivized

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

• It has saved me time when having to get the same message out to multiple restaurants
• It has helped us make smarter operational decisions because we can all collaborate on an answer in a shorter amount of time (instead of calling a meeting!!!)
• The calendar function allows us to plot out our marketing agenda for the month and add/change it together as needed. The chef will post his recipe, the managers will cost it out, the social media manager will post pictures on it, and ultimately we will get that information out on an info sheet to the staff by printing the page.

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