Microsoft Access

Similar to MySQL and Excel, we start by defining the Access connection handle
Once defined we can write SQL queries against the Access database the same way as MySQL
And then define the SQL
NOTE: The visualizations behave the same irrespective of what data source you choose. So the techniques shown in other sections such as MySQL or other examples are perfectly applicable to Excel Dashboards. If you need help with writing SQL queries then you can leverage the visual query builder of InfoCaptor Desktop
Use online Web Dashboards in the cloud or download and host your own Dashboards