MS Access Visual Query Builder

Once you launch Access Dashboard Designer, you can click on the connect button.

In this example we are using the northwind sample database

Image

Click on connect

Once connected it will open the Option wizard

Image

Since there is no dashboard open, the “Build New Query” is disabled.

Click on the “New Blank Dashboard”

Image

Enter some name for the dashboard “Northwind Dashboard”

Click OK

This Action immediately launches the Query Builder interface

Image

Expand the node on the left

Image

This displays a list of available tables

Double click on any table and it brings the table in the Query Builder window

Image

You can now select columns and join then

To create joins, just drag the mouse on a column in the orders table. Once you see the join link appear you may release the mouse button. Now go to the second table and click on the column to which it needs to be joined.

Image

Click on the SQL tab and you can see the SQL query that is automatically built for you

Image

Now click on the “Create Table” button

Image

This action creates a Qlet and places it in the dashboard

Image

You can now right click on any column and create a drop down parameter

Image

Image

The parameter now automatically refreshes the qlet when you change the value