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