(410) 489-5957   Email: GettingStarted@JonPearsonAnalytics.com

Access Database Programming

Jon Pearson and Associates is a full service Microsoft Access Database Programming company.

We can:

• Help you develop your database from scratch.
• Manage changes and improvements to your existing database.
• Develop easy to use reporting tools that link to non-Access data sources.
• Migrate Excel Applications to Access Databases.
• Set up sharable Access databases for multiple users.

Microsoft Excel ----> Microsoft Access Database

Microsoft Excel is a great tool that can do almost anything, if you push it hard enough. 

Maslow's Law -  "I suppose it is tempting, if the only tool you have is a hammer, to treat everything as if it were a nail."

Unfortunately Excel is not the best tool for everything.  When Excel becomes cumbersome, Access is often the best solution.

Warning Signs that you may be better off using Access vs. Excel:

• Using lots of Vlookups - The Vlookup function is extremely useful in Excel.  But over reliance on it can signal that you may actually be better off using Microsoft Access.
• Multiple Workbooks - Having each customer, month, or order in a separate workbook creates work for yourself.  It also makes it very difficult to aggregate information.  With Access you can store and retrieve all of you data in a single place, making it easy to slice and dice your data at any level.