Calculate Median in Microsoft Access - Mean, Mode, Median, and Other Statistical Functions in MS Access 2007

Calculating the statistical mean in MS Access is straightforward, but calculating the median & mode requires Visual Basic and SQL programming skills. There is a way to calculate the median and the mode in Microsoft Excel, and it requires no special programming skills. By importing an Microsoft Access 2007 table in Microsoft Excel, we can use the formulas for calculating median and mode. This article demonstrates the different ways to calculate and use the formulas for mean, median and mode in Microsoft Access 2007.