Here are some of our resources to help you better understand and use Microsoft Access queries across all MS Access versions:
Discover how Total Access Statistics brings advanced numerical analysis to Microsoft Access. Running as a Microsoft Access add-in, Total Access Statistics extends the power of MS Access queries with a wide range of statistical analysis including the calculations of percentiles, regressions, correlations, frequency distributions, rankings, financial cash flow analysis, moving averages and sums, t-Tests, ANOVA group analysis, Chi-square, non-parametrics, probabilities, etc. It can even perform data normalization of your "spreadsheet like" tables.
All results are in Access tables that you can query or add to your forms and reports. A statistical analysis library offers a programmatic interface to VBA developers. A royalty-free runtime distribution license is included.