News Features


FMS Development Team BlogCrash Alert for Access 2010

Microsoft Office 2010 Update KB3085515 Crashes Access Databases


Total Access Startup 2016
Always Launch the Latest Version of your Database with the Right Version of Access!

Microsoft Access Database Launcher


Total Access Detective 2016
Pinpoint Exactly what Changed in your Access Databases!

Find exactly what is different between Microsoft Access databases, objects, code, and data


Microsoft Access to SQL Server Upsizing
Updated Microsoft Access to SQL Server Upsizing Center with whitepapers, resources, and SQL Server Express Downloads


Get our Latest News

Email NewsletterLatest Newsletter (Sign up)

FMS Development Team BlogBlog with us and subscribe to our RSS feed.

FMS TwitterFollow us on Twitter


Microsoft Access 2013, 2010, 2007, 2003, 2002, 2000, and 97Microsoft Access Query Help Center

Examples, Syntax, VBA, Errors, Tips, and Techniques for Beginners to Advanced Access Users and Developers

Here are some of our resources to help you better understand and use Microsoft Access queries across all MS Access versions:

Retrieving Records

Modifying Data with Queries


Advanced Data Analysis in Microsoft Access with Total Access StatisticsNumerical Analysis Beyond Microsoft Access Queries

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.

Get the free trial: Numerical Analysis for Microsoft Access: Download the Trial Version of Total Access Statistics


Microsoft Access to SQL Server UpsizingUpsizing Microsoft Access Data to SQL Server