I think of Access as the tool to use when Excel isn’t the best solution. There are projects you would use Word and not Excel, and there are projects where Access just works better than Excel. Steve Comeau addresses this topic in his excellent blog post here.