Graf-FX will work with any data that Microsoft Access understands and all the useful grafs and queries that are built by the drilldown Launchpad form can be incorporated into your own access application. Graf-fx does this because

	The queries that are generated are built using sql and are stored as Access queries that can be used in this database or any other database with the same underlying (linked) tables and actual queries.
	The drilldown results can be shown as sql select queries and exported to any other sql environment using windows cut and paste.
	The grafs that are generated are Access forms that have a Microsoft Graph object and a form text field object. They are fed with the sql and titles that are suited to the current drilldown requirements.

Following is a level 2 drilldown inquiry that is illustrated in the Experimenting with Graf-FX help

In this example we are looking at finding the sum of all coke sales by region and we have selected the query option to look at the data. The results have been displayed using a query called "yourQuery" which is the standard name for all queries that are generated in the system.

If you wish to keep this query for use in the system

	First make sure that the "yourQuery" window has the current focus by clicking anywhere in that window.
	Select the menu options File .. Save As/Export as shown in the example and choose a new query name or export the query to an other database.

Switch to the Database window using the Graf-FX Toolbar

Now that you have added a new linked table or query, you will find that they will instantly appear in the launchpad like the example as follows. Here "aNewTable" and "aNewQuery" were added to the graf-fx database.

Note that all the graf-fx example tables and queries have been saved with a "z" prefix so that they are easy to separate from the users real information.

Saving a Graf For Future Use

Using the same drilldown and analysing the data with a graf by selecting the button will open up a graf window as follows

Return to the Launchpad form and select the snapshot button on the level that you are currently working on (level 2 in this case). This brings up a dialog box where you will enter the name for the graf that you want to use later. Enter the name of the new graf. We have used "myNewGraf". This will generate a new Access form with your current drilldown query.

It is recommended that you store grafs using naming conventions that sort into a sensible order. Also grafs take up reasonable amounts of disk space compared to queries so saving lots of grafs will make your database expand unnecessarily.

Now you can

	Use the form in your own application with the query that you have generated by exporting it to your own application database.
	Use the form the the Happy Snaps playback utility where you can group collections of grafs for different people/functions and replay them al back together without any programming.
	Modify the new graf to a new Microsoft Graph design and reuse the new design in your drilldowns. In the following example, the design of "MyNewGraf" has been modified to a 3D ribbon graf by viewing the form in design mode, changing the MS graph object to 3D ribbon, exiting MS Graph and saving the form.

Note that Microsoft Graph has a large varieties of display modes and is functionally the same product as that used in MS Excel.

Now the Launchpad will now change which graf it will use for drilldowns on this level and will default to "MyNewGraf" and whatever MSGraph designs that you decide to incorporate into this form. If you want to incorporate other drilldown forms into the Launchpad, select one from this list.