Total Access Statistics is the most powerful data analysis program for Microsoft Access. It runs as an Access add-in and offers a wide range of statistical functions to analyze your data.
Does Total Access Statistics work with tables that are linked to SQL Server, MySQL, or other server base databases options?
Yes, Total Access Statistics can Analyze Any Linked Table.
Total Access Statistics is a Microsoft Access add-in program that can analyze any local or linked table in your Access database.
Linked tables can be in other MS Access databases (ACCDB or MDB), Excel spreadsheets, and server based databases. As long as the linked data sources are supported by MS Access and can be opened (password credentials are saved with the link), Total Access Statistics can use them.
This means it can analyze tables linked to SQL Server, MySQL, Oracle, ODBC, etc. If you can open the table and see its data from your Access database, Total Access Statistics can analyze it.
Total Access Statistics Output
In general, Total Access Statistics puts its results in tables in the current Access database. For some calculations, the source table is updated. For those features, you need write permissions for the table.