Access or Excel?

Microsoft Access is often compared to Excel, and for good reason.  Both can store your data. But knowing which to use is crucial right from the start of your business or project. 

Rule of Thumb

If your data has more than one, but an unknown number of associated data, you need Access.  Examples:

  - One Customer Can Have Any # of Orders

  - One Donor Can Have Any # of Donations

  - One Student Can Have Any # of Classes

  - One Client Can Have Any # of Cases

We Can Help You Make The Right Choice
(If you are already knee-deep in a monster Excel spreadsheet and want to switch to Access, we can help sort it out.)

Take Note!

         Microsoft Access Has Been Marketed As An

                      "Easy To Use End-User Tool" 

In fact, it's a complex, powerful, relational database management system with an incredible built-in report writer.  It does not lend itself to casual use but it has many user friendly features for non-programmers. 

(Located in Lower Westchester COunty, NY_
       Access CAN Be Used On A Network.
 Anyone Who Says Otherwise...is Wrong!

Why would anyone use a database that can only work on one computer?  MS Access was designed to be used on a network. 

 

If you set it up correctly you can have many users accessing the data simultaneously.  We have seen multi-user Access databases working well, and we have seen single user databases fail miserably.

COVID Adaptation - You can use Remote Desktop to connect to your Access Database if you are working from home.

Microsoft Access As A Web App?
Existing Database - Most Access databases evolve over time and become quite "feature rich" and include complex reports.  In this case, moving the database to the "cloud" or the "web" is not going to work unless you are willing to have the web version be different and have fewer features.  
New Database - Evaluate your needs carefully and create specifications before you decide to use Access as a web app. Check out this information from Microsoft. 
We work with Access 97, 2000, 2002, 2003, 2007, 2010, 2013, 2016, 2019

    R Levine Consulting, LLC             914.450.2650 mobile              914.478.1553 office