By: William Gee
As a Microsoft Office software instructor for fifteen years, I am sometimes asked whether to use Access or Excel to keep track of database information and calculate summaries, subtotals or complex formulas and functions with the data. The fact is that Excel, which is probably best known for its number crunching capabilities, has robust database functionality. Access, which is indeed a database program, can perform many of the complex math formulas and functions that Excel is known for. So which should you use?