Copyright: 1998, DATACHART


Contents

Introduction

Tutorial

Index

Program Elements

Main Screen Display

Chart Screen Display

Chart Screen Display Tool Bar

SQL Screen Display

SQL Screen Display Tool Bar

Printing Information

Copyright 1998, DATACHART

http://www.datachart.com


Introduction

Welcome to DataChart !

DataChart is a data visualization application distributed as a shareware.

DataChart for Windows 95 supports many DataBase file format and aliases.  Using the file manager, you can select your favorite database tables and view them in many different graph style.

Click on the following Help Topic to become quickly familiar wiht DataChart.

Back to Main Content Page

Tutorial

Index


Tutorial

To create your first chart, simply press the embossed "Create Chart" button on the main screen.  You will then be faced with two major option.

1 	Selecting: " Existing Alias " or " Folder Navigation ", and

2 	Selecting: " Quick Chart " or " Detail Option " (Like SQL).

-------------Press the Links to find out more about each option !----------------

The rest of the procedure is relatively easy.  And to ensure you get proficient at making graphs and charts, DataChart has provided several sample tables in different database types to assist you in learning how to graph database information.  Each database type has several examples, using each of the above selection discussed.

NOTE:  Some fields in your database tables may contain character, text or strings of text, such as perhaps a name field.  These fields cannot be graphically represented.

Should you select one of these fields accidently, you can use the Reset field button on the Chart and Graph Screen Tool Bar.

Using - MS Access Databases

Using - DBASE Databases

Using - PARADOX databases

Main Content Page

Index


MS Access Tutorial

This program will easily graph both the MSAccess 95 and 7.0 version databases.  There are 2 main different way of acquiring data into DataChart.  To learn more about each of these possible methods, please select the following links.

1 - Using Existing Alias with Quick Chart or Detail Option method

2 - Using Folder Navigation with Quick Chart or Detail Option method

NOTE:  Some fields in your database tables may contain character, text or strings of text, such as perhaps a name field.  These fields cannot be graphically represented.

Should you select one of these fields accidently, you can use the Reset field button on the Chart and Graph Screen Tool Bar.

Main Tutorial

Main Content Page

Index


MSAccess Existing Alias Tutorial

In order to use the Existing Alias method, you must first have created an alias for your *.mdb access database.  Click here to learn how to do this procedure.

If this procedure has been performed or you simply what to use the sample file DataChart has provided you with this program, then continue with the following steps.

Existing Alias with Quick Chart option

For training purpose, we will use the sample file provided in this program.  Here are 5 easy steps to create your first MSAccess Chart.

Please note that the pictures "PIC#" are used for all tutorial function in this program and may therefore not exactly reflect this particular tutorial.

•	Click on the embossed "Create Chart" button (pic#1)

•	Your next screen should already be defaulted to Database Selection "Existing Alias" with Numeric Representation "Quick Chart(Single table)".  And just click "OK" button (pic#2)

•	Now you must select in the "Choose Alias and Table", the Alias "DataChart Sample Access" and automatically the table "TermMark" will appear in the table selection area. Continue by clicking the "OK" button (pic#3)

•	Using the arrow ">" select the field you wish to send into the "Field to show on Graph" Then just click "OK" (pic#4)

•	There you have it, a perfect chart everytime. This is assuming you have picted fields, that could be graphically represented.(pic#5)

Existing Alias with Detail Options

For training purpose, we will use the sample file provided with this program.  Here are 5 easy steps to create your first MSAccess Chart.

Please note that the pictures "PIC#" are used for all tutorial function in this program and may therefore not exactly reflect this particular tutorial.

•	Click on the embossed "Create Chart" button (same as pic#1 above)

•	Next, please select Database Selection "Existing Alias" with Numeric Representation "Detail Options" And click "OK" button (same as pic#2 above)

•	Now you must select in the Open Table, the Alias drop down menu, the selection "DataChart Sample Access" and automatically the table "TermMark" will appear below. Continue by clicking the "OK" button (pic#6)

•	Now you must choose from the TermMark table, the field you wish to graph.  You can do this by double clicking on the field name in the box table "TermMark".  A table will appear below that will have several option.  These option are discussed later in other SQL topics.  At this point all you have to do is simply click "OK" at the bottom of the screen (pic#7)

•	There you have it, another way of charting your favorite database.

MSAccess Main Tutorial

MSAccess Folder Navigation Tutorial

Main Tutorial

Index


MSAccess Folder Nav tutorial
MSAccess Folder Navigation Tutorial

For this tutorial, we will use the sample file DataChart has provided with the program.

Folder Navigation with Quick Chart (Single Table) Tutorial

Here are 7 easy steps to create an MSAccess Chart.

Please note that the pictures "picture#" are used for all tutorial function of this program and may therefore not exactly reflect this particular tutorial.

•	Click on the embossed "Create Chart" button (picture#1)

•	Next, please select Database Selection "Folder Navigation" with Numeric Representation "Quick Chart (Single Table)" And click "OK" button (picture#2)

•	Now you must browse and select the chart you wish to visualize.  For training purpose , please select the folder "Demos" ,then the folder "Access" and select in the "List file of types", "Access Table(*.mdb)".  Automatically the table "TermMark95" will appear in the table selection area. Continue by clicking on the table "TermMark95" and then press the "OK" button (picture#3)

•	A Database Login screen will appear, at this time just press the "OK" button  (picture#4).  The operation of this screen will be explaned in an other topic.

•	Now you will get another screen with the purpose of selecting a "Table",  TermMark should already be defaulted, therefore continue by pressing the "OK" button.. (picture#5)

•	Using the arrow ">" select the field you wish to send into the "Field to show on Graph" Then just click "OK" (picture#6)

•	There you have it, a perfect chart everytime. This is assuming you have picted fields, that could be graphically represented.(picture#7)

Make a chart with Folder Navigation and Detail Options

For training purpose, we will use the sample file provided with this program.  Here are 7 easy steps to create your first MSAccess Chart.

Please note that the pictures "PIC#" are used for all tutorial function in this program and may therefore not exactly reflect this particular tutorial.

•	Click on the embossed "Create Chart" button (same as above picture#1)

•	Next, please select Database Selection "Folder Navigation" with Numeric Representation "Detailed Options" And click "OK" button (same as above picture#2)

•	Now you must browse and select the chart you wish to visualize.  For training purpose , please select the folder "Demos" , then the folder "Access" and select in the "List file of types", "Access Table(*.mdb)".  Automatically the table "TermMark95" will appear in the table selection area. Continue by clicking on the table "TermMark95" and then press the "OK" button (same as above picture#3)

•	A Database Login screen will appear, at this time just press the "OK" button  (same as above picture#4). The operation of this screen will be explaned in an other topic.

•	Now you will get another screen with the purpose of selecting a "Table",  TermMark should already be defaulted, therefore continue by pressing the "OK" button.. (same as above picture#5)

•	Now you must choose from the TermMark table, the field you wish to graph.  You can do this by double clicking on the field name in the box table "TermMark".  A table will appear below that will have several option.  These option are discussed later in other SQL topics.  At this point all you have to do is simply make sure you have at least doubled clicked on one field and press "OK" at the bottom of the screen (picture#8)

•	There you have it, another way of charting your favorite database.

MSAccess Main Tutorial

MSAccess Existing Alias Tutorial

Main Tutorial

Index


Index

#

3D View Tab

B

Boolean Operators

C

Change Chart Options

Change Gallery Type

Change Text Fonts

Chart Screen Display Tool Bar

Chart Screen Display

Chart Spacing

Chart...  Selection

Close Chart

Color Change

Color Option

Contents

Copy to Clipboard as BMP

Copy to Clipboard as TXT

Create DataChart

D

Data Editor

DBase Existing Aliases Tutorial

DBase Folder Nav Tutorial

DBase Tutorial

Detail Option

E

Edit SQL

Edit Table Join

Edit Titles

Existing Alias

Exit

Expression Builder

F

Folder Nav Picture

Folder Navigation

G

Gallery Option Picture

General Tab

H

Help

Horizontal Grid

I

Index

Introduction

J

Join Editor

L

Landscape Orientation

M

Main Screen Display

Making Aliases

Making DBase Aliases

Making MSAccess Aliases

Making Paradox Aliases

Master Table Join

MK Alias Pic 1

Mk Alias Pic 2

Mk Alias Pic 3

MS Access Tutorial

MSAccess Existing Alias Tutorial

MSAccess Folder Nav tutorial

MSAccess Pic 1

MSAccess Pic10

MSAccess pic2

MSAccess Pic3

MSAccess Pic4

MSAccess Pic5

MSAccess Pic6

MSAccess Pic7

MSAccess Pic8

MSAccess Pic9

N

No 3D Shadow on Top Title

O

Open File

Options

P

Page Margin

Palette and Pattern

Palette Bar

Paradox Existing Aliases Tutorial

Paradox Folder Nav Tutorial

Paradox SQL Example Part 2

Paradox SQL Example

Paradox Tutorial

Pattern Bar

Portrait Orientation

Print

Q

Quick Chart

R

Registration

Relational Operators

Reset Fields

Rotate the Chart

S

Save to Disk

Scale Tab

Select Fields to Graph

Series Tab

Show and Hide Legend

Show and Hide Series Legend

SQL Aggregate Functions

SQL Demo00

SQL Demo01

SQL Demo02

SQL Demo03

SQL Demo04

SQL Demo05

SQL Demo06

SQL Demo07

SQL Demo08

SQL Demo09

SQL Demo10

SQL Demo11

SQL Demo12

SQL Demo13

SQL Demo14

SQL Demo15

SQL Demo16

SQL Demo17

SQL Demo18

SQL Demo19

SQL Demo20

SQL Demo21

SQL Demo22

SQL Screen Display Tool Bar

SQL Screen Display

Switch Between 3D and 2D Views

T

Titles Tab

Tools

Tutorial

U

Use 3D Shadow on Top Title

V

Vertical Grid

X

X Axis and Series Lables

Z

Z Clustered Series

Zoom


DBase Tutorial

This program will easily graph most DBase (*.dbf) version databases.  There are 2 main different way of acquiring data into DataChart.  To learn more about each of these possible methods, please select the following links.

1 - Using Existing Alias with Quick Chart or Detail Option method

2 - Using Folder Navigation with Quick Chart or Detail Option method

NOTE:  Some fields in your database tables may contain character, text or strings of text, such as perhaps a name field.  These fields cannot be graphically represented.

Should you select one of these fields accidently, you can use the Reset field button on the Chart and Graph Screen Tool Bar.

Main Tutorial

Main Content Page

Index


DBase Existing Aliases Tutorial

In order to use the Existing Alias method, you must first have created an alias for your DBase (*.dbf) database.  Click here to learn how to do this procedure.

If this procedure has been performed or you simply what to use the sample file DataChart has provided you with this program, then continue with the following steps.

Existing Alias with Quick Chart option

For training purpose, we will use the sample file provided in this program.  Here are 5 easy steps to create your first DBase Chart.

Please note that the pictures "PIC#" are used for all tutorial function in this program and may therefore not exactly reflect this particular tutorial.

•	Click on the embossed "Create Chart" button (pic#1)

•	Your next screen should already be defaulted to Database Selection "Existing Alias" with Numeric Representation "Quick Chart(Single table)".  And just click "OK" button (pic#2)

•	Now you must select in the "Choose Alias and Table", the Alias "DataChart Sample DBase" and automatically the table "Profiles.dbf" will appear in the table selection area. Continue by clicking the "OK" button (pic#3)

•	Using the arrow ">" select the field you wish to send into the "Field to show on Graph" Then just click "OK" (pic#4)

•	There you have it, a perfect chart everytime. This is assuming you have picted fields, that could be graphically represented.(pic#5)

Existing Alias with Detail Options

For training purpose, we will use the sample file provided with this program.  Here are 5 easy steps to create your first DBase Chart.

Please note that the pictures "PIC#" are used for all tutorial function in this program and may therefore not exactly reflect this particular tutorial.

•	Click on the embossed "Create Chart" button (same as pic#1 above)

•	Next, please select Database Selection "Existing Alias" with Numeric Representation "Detail Options" And click "OK" button (same as pic#2 above)

•	Now you must select in the Open Table, the Alias drop down menu, the selection "DataChart Sample DBase" and automatically the table "Profiles.dbf" will appear below. Continue by clicking the "OK" button (pic#6)

•	Now you must choose from the TermMark table, the field you wish to graph.  You can do this by double clicking on the field name in the box table "Profiles.dbf".  A table will appear below that will have several option.  These option are discussed later in other SQL topics.  At this point all you have to do is simply click "OK" at the bottom of the screen (pic#7)

•	There you have it, another way of charting your favorite database.

Main DBase Tutorial

DBase Folder Navigation Tutorial

Main Tutorial

Index


DBase Folder Nav Tutorial
DBase Folder Navavigation Tutorial

For this tutorial, we will use the sample file DataChart has provided with the program.

Folder Navigation with Quick Chart (Single Table) Tutorial

Here are 5 easy steps to create a DBase Chart.

Please note that the pictures "picture#" are used for all tutorial function of this program and may therefore not exactly reflect this particular tutorial.

•	Click on the embossed "Create Chart" button (picture#1)

•	Next, please select Database Selection "Folder Navigation" with Numeric Representation "Quick Chart (Single Table)" And click "OK" button (picture#2)

•	Now you must browse and select the chart you wish to visualize.  For training purpose , please select the folder "Demos" ,then the folder "DBase" and select in the "List file of types", "DBase Table(*.dbf)".  Automatically the table "Profiles.dbf" will appear in the table selection area. Continue by clicking on the table "Profiles.dbf" and then press the "OK" button (picture#3)

•	Using the arrow ">" select the field you wish to send into the "Field to show on Graph" Then just click "OK" (picture#6)

•	There you have it, a perfect chart everytime. This is assuming you have picted fields, that could be graphically represented.(picture#7)

Make a chart with Folder Navigation and Detail Options

For training purpose, we will use the sample file provided with this program.  Here are 7 easy steps to create your DBase Chart.

Please note that the pictures "PIC#" are used for all tutorial function in this program and may therefore not exactly reflect this particular tutorial.

•	Click on the embossed "Create Chart" button (same as above picture#1)

•	Next, please select Database Selection "Folder Navigation" with Numeric Representation "Detailed Options" And click "OK" button (same as above picture#2)

•	Now you must browse and select the chart you wish to visualize.  For training purpose , please select the folder "Demos" , then the folder "DBase" and select in the "List file of types", "DBase Table(*.dbf)".  Automatically the table "Profiles.dbf" will appear in the table selection area. Continue by clicking on the table "Profiles.dbf" and then press the "OK" button (same as above picture#3)

•	Now you must choose from the "Profiles.dbf" table, the field you wish to graph.  You can do this by double clicking on the field name in the box table "Profiles.dbf".  A table will appear below that will have several option.  These option are discussed later in other SQL topics.  At this point all you have to do is simply make sure you have at least doubled clicked on one field and press "OK" at the bottom of the screen (picture#8)

•	There you have it, another way of charting your favorite database.

Main DBase Tutorial

DBase Existing Aliases Tutorial

Main Content Page

Index


Paradox Tutorial

This program will easily graph Paradox databases.  There are 2 main different way of acquiring data into DataChart.  To learn more about each of these possible methods, please select the following links.

1 - Using Existing Alias with Quick Chart or Detail Option method

2 - Using Folder Navigation with Quick Chart or Detail Option method

NOTE:  Some fields in your database tables may contain character, text or strings of text, such as perhaps a name field.  These fields cannot be graphically represented.

Should you select one of these fields accidently, you can use the Reset field button on the Chart and Graph Screen Tool Bar.

Main Tutorial

Main Content Page

Index


Paradox Existing Aliases Tutorial

In order to use the Existing Alias method, you must first have created an alias for your Paradox (*.db) database.  Click here to learn how to do this procedure.

If this procedure has been performed or you simply what to use the sample file DataChart has provided you with this program, then continue with the following steps.

Existing Alias with Quick Chart option

For training purpose, we will use the sample file provided in this program.  Here are 5 easy steps to create your Paradox Chart.

Please note that the pictures "PIC#" are used for all tutorial function in this program and may therefore not exactly reflect this particular tutorial.

•	Click on the embossed "Create Chart" button (pic#1)

•	Your next screen should already be defaulted to Database Selection "Existing Alias" with Numeric Representation "Quick Chart(Single table)".  And just click "OK" button (pic#2)

•	Now you must select in the "Choose Alias and Table", the Alias "DataChart Sample Paradox" and automatically the table "Orders.db" will appear in the table selection area. Continue by clicking the "OK" button (pic#3)

•	Using the arrow ">" select the field you wish to send into the "Field to show on Graph" Then just click "OK" (pic#4)

•	There you have it, a perfect chart everytime. This is assuming you have picted fields, that could be graphically represented.(pic#5)

Existing Alias with Detail Options

For training purpose, we will use the sample file provided with this program.  Here are 5 easy steps to create your Paradox Chart.

Please note that the pictures "PIC#" are used for all tutorial function in this program and may therefore not exactly reflect this particular tutorial.

•	Click on the embossed "Create Chart" button (same as pic#1 above)

•	Next, please select Database Selection "Existing Alias" with Numeric Representation "Detail Options" And click "OK" button (same as pic#2 above)

•	Now you must select in the Open Table, the Alias drop down menu, the selection "DataChart Sample Paradox" and automatically the table "Orders.db" will appear below. Continue by clicking the "OK" button (pic#6)

•	Now you must choose from the "Orders.db" table, the field you wish to graph.  You can do this by double clicking on the field name in the box table "Orders.db".  A table will appear below that will have several option.  These option are discussed later in other SQL topics.  At this point all you have to do is simply click "OK" at the bottom of the screen (pic#7)

•	There you have it, another way of charting your favorite database.

Main Paradox Tutorial

Paradox Folder Navigation Tutorial

Main Content Page

Index


Paradox Folder Nav Tutorial
Paradox Folder Navavigation Tutorial

For this tutorial, we will use the sample file DataChart has provided with the program.

Folder Navigation with Quick Chart (Single Table) Tutorial

Here are 5 easy steps to create a Paradox Chart.

Please note that the pictures "picture#" are used for all tutorial function of this program and may therefore not exactly reflect this particular tutorial.

•	Click on the embossed "Create Chart" button (picture#1)

•	Next, please select Database Selection "Folder Navigation" with Numeric Representation "Quick Chart (Single Table)" And click "OK" button (picture#2)v

•	Now you must browse and select the chart you wish to visualize.  For training purpose , please select the folder "Demos" ,then the folder "Paradox" and select in the "List file of types", "Paradox Table(*.db)".  Automatically the tables "Company.db" and "Orders.db" will appear in the table selection area. Please single click "Orders.db" and continue by pressing  the "OK" button (picture#3)

•	Using the arrow ">" select the field you wish to send into the "Field to show on Graph" Then just click "OK" (picture#6)

•	There you have it, a perfect chart everytime. This is assuming you have picted fields, that could be graphically represented.(picture#7)

Make a chart with Folder Navigation and Detail Options

For training purpose, we will use the sample file provided with this program.  Here are 7 easy steps to create your Paradox Chart.

Please note that the pictures "PIC#" are used for all tutorial function in this program and may therefore not exactly reflect this particular tutorial.

•	Click on the embossed "Create Chart" button (same as above picture#1)

•	Next, please select Database Selection "Folder Navigation" with Numeric Representation "Detailed Options" And click "OK" button (same as above picture#2)

•	Now you must browse and select the chart you wish to visualize.  For training purpose , please select the folder "Demos" , then the folder "Paradox" and select in the "List file of types", "Paradox Table(*.db)".  Automatically the table "Company.db" and "Orders.db" will appear in the table selection area. Continue by clicking on the table "Orders.db" and then press the "OK" button (same as above picture#3)

•	Now you must choose from the "Orders.db" table, the field you wish to graph.  You can do this by double clicking on the field name in the box table "Orders.db".  A table will appear below that will have several option.  These option are discussed later in other SQL topics.  At this point all you have to do is simply make sure you have at least doubled clicked on one field and press "OK" at the bottom of the screen (picture#8)

•	There you have it, another way of charting your favorite database.

Main Paradox Tutorial

Paradox Existing Aliases Tutorial

Main Content Page

Index


Main Screen Display

The main screen display (Picture) has a menu which includes the following functions, to learn more about each option select any of the following jump topics:

Main Screen Top Selections

Chart...

Print

Help

How to Register

Main Screen Embossed and lower Selections

Button "Create DataChart"

Options:

Button  " ? "

Button "Reset Field"

Button "Edit SQL"

Button "Close Chart"


Chart...  Selection

This main screen menu item provide the user with the following selections.  In order to learn more about each specific item select any jump key of your choice:

Note:

Except for the "Create Data Chart" and "Exit" selections, the remaining categories are availlable only after a graph has been created.

Create DataChart

Chart Options

Reset Fields

Edit SQL

Close Chart

Show Tool Bar

Hide Tool Bar

Exit

Back to Main Screen Display

Index


Create DataChart

When you press the button DataChart from the main screen embossed display or select from the "Chart ..." menu DataChart, you will be faced with four selections.

You must first select whether you want to create a chart with Existing Alias or with the Folder Navigation.

Your then must select the Quick Chart (Single Tables) function or choose the Detail Options which enables the user to create a chart with the use of Structured Query Language (SQL).

A description of each options is given in the following Jump Object listed below.

Tutorial

DBase Tutorial

Paradox Tutorial

MSAccess Tutorial

Index


Options

Both the main screen `chart...`selection `Chart Option`and the Òption`selection enables the user to customize in several ways the graph.  Use the following jump keys to learn more about each selections.

Chart Spacing

X-Axis & Series Lables

Edit Titles

Page Margin

Landscape Orientation

Portrait Orientation

No 3D Shadow on Top Title

Use 3D Shadow on Top Title

Index


Chart Spacing

The Chart Spacing selection provides the user with the ability to change the Horizontal and Depth spacing (3D) of the graph.  Graphs are always created with an automatic default value which can be customized by the user.

Options

Index


X Axis and Series Lables

This main screen option allow the X-Axis Title or Numbers to be modified.  Additionally this selection can be use to amend the Title of the Legend.

Options

Index


Edit Titles

Choosing this buttnn displays a dialog!which allows the entry or modific`tion of any and all of four titles.  The fonts of any of thesd titles can!be changed with Change Text Fonts.

Chart Tool Bar

Options

Index


Chart Screen Display Tool Bar

The Chart Tool Bar display can be viewed or hiden by using the "Chart ..." selection on the main screen menu.  Additionally, the tool bar can be sized down and moved anywhere on the screen.  Simply use your mouse to point, click and hold in the tool bar area where there is no icons, then move the curser where you want the tool bar to be and release the mouse button.  The reverse can be use to return the tool bar to its original position.

The Chart Display and Tool Bar have several function buttons, which allow extensive customization of the Graphs.  If the mouse cursor is allowed to rest over any of the buttons for a few seconds, a hint description will appear. Click on any one of the icons listed below to find out more about each function.

 Open File

 Save to Disk

 Copy to clipboard as BMP

 Copy to clipboard as Text

 Printer

 Change Gallery Type

 Color Change

 Switch Between 3D and 2D Views

 Rotate the Chart

 Z-Clustered Series

 Zoom

 Show/Hide Legend

 Show/Hide Series Legend

 Vertical Grid

 Horizontal Grid

 Edit Titles

 Change Text Fonts

 Tools

 Change Chart options

Chart Screen Display

Chart... Selection

Index


Open File

This icon enables the user to open a table directly from the chart screen.  The user simply open the file through a directory structure of choice.

Chart Tool Bar

Index


Save to Disk

As the icon suggest, the user can save a graph to a preferred folder or floppy disk.

Chart Tool Bar

Index


Copy to Clipboard as BMP
Copy to Clipboard as Bitmap

The graph created by DataChart can be copied as a BitMap file to a floppy or a hard drive.

Chart Tool Bar

Index


Copy to Clipboard as TXT
Copy to Clipboard as Text

The graph created by DataChart can be copied to the clipboard as a text file.

Chart Tool Bar

Index


Print

The chart will be printed on the current windows printer. Its settings will be used for all printer characteristics, including the paper orientation.

If the chart information does not all fit on one page, then multiple pages will be printed to display all of the charted information.

Note:

In order to change printer driver, DataChart wil have to be exited and computer rebooted in order for the printer driver modification to takes its effect.

Chart Tool Bar

Landscape orientation

Portrait orientation

Page Margin

Index


Landscape orientation

The main screen Option `Landscape Orientation` is used for printing graph in a wide position, ie: 11.5 inches wide by 8.5 inches high.  If selected it will not be noticeable on the monitor screen.

Print

Portrait orientation

Options

Index


Portrait Orientation

The main screen option `Portrait Orientation` is used for printing in the upright position, ie 8.5 inches wide by 11.5 inches high.  If selected it will not be noticeable on the monitor screen.

Print

Landscape orientation

Options

Index


Page Margin

The main screen option "Page margin" when selected will not be noticeable until it is printed.  The next upgrade to DataChart should include a print preview which will provide the user with more flexibility.

Print

Options

Index


Change Gallery Type

The Change Gallery Type button allows the user to present the chart information in various formats. (Take a look)  Some of the formats are useful only in combination with certain chart parameters.  For instance, the surface chart works best with a 3D chart view, and with Z-clustering enabled.

Chart types enabled in this application are:

•	Area

•	Columns (Vertical Bars)

•	Lines

•	Marks (Only point values with no lines or bars)

•	Fit to Curve

•	Horizontal Bar

•	Scatter

•	Pie

•	Surface

Chart Tool Bar

Index


Color Change

By clicking on the down arrow of the Change Color button, a color grid is displayed. (want to look at it) Choosing one of the colors in the grid with the mouse, changes the color of the Change Color button.  By dragging and dropping the button's current color, chart elements can be changed to an alternate color.  For instance, various colors can be chosen and assigned to data series, the chart background, the series legend area background, and so on.

Font colors are not changed with this button, but rather with the Change Text Fonts button.

Chart Tool Bar

Index


Switch Between 3D and 2D Views

The Switch Between 3D and 2D Views button (glasses) changes a flat chart to one with depth, and vice versa.  In 3D mode, the Rotate the Chart button becomes activated, as does the Z Clustered series button.

Chart Tool Bar

Index


Rotate the Chart

The Rotate the Chart button becomes activated when the chart is in 3D mode (See Switch Between 3D and 2D Views). It allows the user to rotate the chart to a number of perspectives, and can be particularly effective when multiple series are portrayed in separate rows.

Chart Tool Bar

Index


Z Clustered Series

The Z-Clustered Series button is enabled when the chart is in a 3D view and there are at least 3 fields selected from a table (See Switch between 3D and 2D Views).  In a 3D view, depressing this button will typically separate the data series into parallel displays, creating a chart with greater depth and series separation.

Z-Clutered Series ON

Z-Clutered Series OFF

Chart Tool Bar

Index


Zoom

When the Zoom button is depressed, the user can drag the mouse to define a rectangle on the chart area.  This rectangle is then enlarged to illustrate greater detail of the chosen area.  A double click with the mouse will still display the underlying chart value for the selected chart item.  Clicking the Zoom button again returns the chart display back to normal.

Chart Tool Bar

Index


Show and Hide Legend

Depressing this button causes a series legend display to appear on the right hand side of the chart.  The series titles correspond to the field names in the database table being charted.

Note:

If you right click mouse while in the legend area, you will be shown a menu allowing you to make your legend a floating type or adjusted to the left, right, top, or bottom of your screen.

Additionally the "Option" selection enables the user to format the legend box with the following caracteristics:

•	Draw Border

•	Draw Spliter

•	3D Frame

•	Skip Empty

•	Multiline

Chart Tool Bar

Index


Vertical Grid

This selection on the chart tool bar will bring Vertical lines in the back ground of your chart, and will help better define your graphs.

Chart Tool Bar

Index


Horizontal Grid

This selection on the chart tool bar will bring horizontal line in the back ground of your chart, and will help better define your graphs.

Chart Tool Bar

Index


Change Text Fonts

This button when pressed displays a list of text items.  Choosing any item displays a font dialog box, which can be used to choose a font for the item.

Items which are listed for a font choice are:

•	Left Title

•	Right Title

•	Top Title

•	Bottom Title

•	X Legend: The X-axis record numbers.

•	Y Legend: The Y-axis values scale.

•	Legend Box: The series titles displayed with the Show-Hide Series Legend button

•	Constant Legends: Not relevant for this application.

•	Values: Not relevant for this application

Chart Tool Bar

Index


Tools

The Tools button presents a list of choices.  The choices enabled for this application are:

•	Series Legend: A toggle to show or hide the Series Legend.  This toggle duplicates the functionality of the Show-Hide Series Legend button.

•	Palette Bar: A toggle which shows or hides a band of colors across the top of the chart.  The color can be dragged and dropped on chart elements to change their colour.  This duplicates the functionality of the Change Color button.

•	Pattern Bar: A toggle which shows or hides a band of patterns across the top of the chart.  The patterns can be dragged and dropped on chart series to change their pattern, or to change their mode from a solid color to a patterned color.  (The series are either all solid colors, or all patterned colors.)  The Change Chart Options button can also be used to affect whether the series have solid or pattern colors..

•	Here is a look at both the pattern and palette bar

•	Data Editor: Is a toggle which alternates the chart with a display of the series values comprising the chart.  The values in the data editor can be changed, and this will be correspondingly reflected in the chart as well.  It has, however, no effect on the originating database table.

Chart Tool Bar

Index


Change Chart Options

This button presents a set of five tabbed pages, which allow extensive customization of the chart.

General Tab

This tab has several items which affect the presentation format of the chart.  The style of the chart can be defined, as in the Change Gallery Type button.  The choices of blank or grid background, solid or patterned series, the shape of point displays, and the size or thickness of series representations can be set.

Series Tab

This tab allows customization of series characteristics, such as color.  If the Multiple Types box is checked, then different chart styles can be set per series.  For example, one series could be a line, and another could be shown as bars.  Options can also be set to change line or bar thickness and/or shape.

Scale Tab

This tab allows the choice of either a linear or logarithmic scale.  It also allows choices of items such as the minimum and maximum Y-axis values, and a scaling factor for application to the Y-axis.

3D View Tab

This tab duplicates the functionality of the Rotate the Chart button.

Titles Tab

This tab duplicates the functionality of the Edit Titles button.

Chart Tool Bar

Index


General Tab


Series Tab


Scale tab


3d View Tab


Titles Tab
Title Tab


Chart Screen Display

The chart created has each field represented as one series in the graph.  Any adjustment required to the graph is available with the use of the Tool Bar. This Tool Bar allows an extensive number of operations.  Also, if the user double clicks on a chart element (bar, line, etc.), value information will be displayed on the particular item.

Tool Bar Functions

The Chart Tool Bar provides options to change the graph type, add or delete titles or change their fonts, show or hide the series legend (corresponding to field names), change the colors of chart elements, and so on.  It also provides a Zoom feature which allows the user to select a portion of the chart which is enlarged, for viewing of details.  See the above link for more information.

Graph information

The chart presents information from the first record on the left side, and information from the last record on the right side (except for horizontal bar charts), with a scroll bar included if needed to accommodate the volume of information.  The record numbers are displayed as the X-axis values.  The Y-axis represents values from the records, and the maximum value of the Y-axis is determined from the maximum value in the database table fields being charted.

Sizing the graph

The chart can be resized in various ways - the mouse cursor changes to a double arrow when it is over a border that allows resizing.  So for instance, when the series legend is showing, the width of the legend can be increased at the expense of decreasing the display width of the chart itself.

Data points

The number of data points which can be charted may vary somewhat.  Typically 10,000 or more points can be charted (20,000 or more if the values are integer).  A warning is displayed to the user if large numbers of points will be charted.

Main Contents

Index


No 3D Shadow on Top Title

This main screen option is available for screen viewing modification only.  The printed graph will not reflect this change.

Options

Index


Use 3D Shadow on Top Title

This main screen option is available for screen viewing modification only.  The printed graph will not reflect this change

Options

Index


Reset Fields

Once a graph has been built, this button will enable the user to back out of the graphical display and change fields of the graph.

Main Screen Display

Chart...Selections

Index


Edit SQL

As the tiltle explains this embossed button will allow the user to edit the selected field.  If you press this option you will return to the Field Selection Display where you will have the possibility of changing your selection of fields.

Main Screen Display

Chart... Selection

Index


Close Chart

Once a query has been executed and the graph has been saved, printed or otherwise not needed, this embossed selection can be use to terminate the query, close the graphic image and return the DataChart to the beggining screen ready for another query.

Main Screen Display

Chart... Selection

Index


Exit

This selection will terminate and close DataChart application.

Chart... Selections

Index


Help

This main screen menu item provide the user with the selection listing of the program's help content.  Also the validation of user name and registration number required to properly register the software package, and description and copyright of the software.

Main Screen Display

Chart... Selections

Index


Registration

You can register your copy of DataChart by following the instruction given in the "How to Register" file selection.

After registering you will receive a user id and secret code number to certify the registration of your copy of DataChart.  Insert them in the menu "help" file topic subfolder "Enter Registration Info".  This will unleash the full power of DataChart and remove the Unregister notification located on the right side of the graphic screen.

For the latest information on this subject, please read the "readme.txt" file which should be located in the installation folder of DataChart or visit our web site http://www.datachart.com.

Main Screen Display

Chart... Selection

Index


SQL Screen Display

When using the "Detail Option" to create graph, you will using the main SQL screen builder, which consist of a tool bar and table such as the example in this Picture.  To learn more about the tool bar option click on the following jump keys.

SQL Tool Bar

Boolean Operators

Relational Operators

SQL Aggregate Functions

Index


SQL Screen Display Tool Bar

Unables the user to load a saved query from a file.

To save present query to a file.

Removes all tables from present query.

Adds a new table to the present query.

Removes a selected table from the query.

Edit the table joins.  Editor Table Join

Adds an SQL Define field

Show or execute the query.

Show or ena user to write the SQL Text

Show the result of the query in text tables.

In addition to the tool bar, 3 additional check box are found on the Tool Bar.

•	Last field as labels is used when selecting the fields of the tables, if this box is checked the last field selected will display its labels on the graph.

•	Ignore duplicate, as the name implies, will ignore any rows which may be duplicated. as example a name field may be duplicated if your trying to extract all product sales by name.  The name could be display if the same name has purchased different products.

•	Autogroup, as it suggest will automatically group rows matching category.

Detail Option

Boolean Operators

Relational Operators

SQL Aggregate Functions

Index


Detail Option

The primary purpose of this software was to enable users with the flexibility of graphically visualizing Data saved in various DataBase format.  In order to accomplish and optimized this purpose, Stuctured Query Language (SQL) was incorporated.  This powerful tool can quickly search, extract and display specific data in Database tables.

In light of the primary purpose and after much debate, it was decided to limit the SQL options to searching and visualizing data only.  Any editing, deleting or ammending of any sort to database table was disabled in order to prevent any changes to the user data tables.  So with this in mind, feel comfortable to use DataChart without affecting your Databases.  Click on any of the following jump keys to learn more about how to use SQL.

Paradox SQL Example

Main Tutorial

SQL Aggregate Functions

Relational Operators

Boolean Operators

Main Content Page

Index


Paradox SQL Example

It is recommended that you first get familiar with creating charts using the Existing Alias or Folder Navigation with the Quick Chart method, before you continue with this tutorial.

During this Detail Option method, we will construct, using "CompanyName" in the "Company.db" database, a table that shows, for each company, how many orders, are in the database.  Lets get started.

1 	First, Hit the "Create Chart" embossed button.

2 	Select, Existing Alias with Detail Options. We have added pictures to help you along with the tutorial.  Here is what Datachart screen should look like. (Pic)

3 	Then, in the "Open Table" Alias selction, choose "DataChart Sample Paradox.  In the table below, select the table "Company.DB".  Then press the "OK" button. (Pic1)

4 	This will take you to the SQL Builder screen (Pic2).  From the ToolBar menu, select the "Add a new table" icon, it is the icon with a green plus sign.

5 	After you have pressed the "Add a new table" icon, repeat the steps, as in item 3 and add the table "Orders.DB". (Pic3)

6 	After you have pressed the "Add a new table" icon, the screen "Join Editor" will be display with various option.  At this time, accept all the option given by simply pressing the "OK" button at the bottom of the page. (Pic4)

7 	Repeat step 5 and 6 to add the table "Parts.DB". (Pic5) & (Pic6)

8 	After inserting all 3 tables (Company.DB, Orders.Db and Parts.DB), your screen should look like this (Pic7).  At this point we need to define, using SQL, what we want to view from the tables selected.  Continue by pressing the icon on the toolbar which is to the left of the hammer & wrench.  It is called "Add a SQL defined field".  This is what the next screen will look like. (Pic8)

9 	From this screen we need to type "NumberOFOrders" in the "field display name type".  We also must select in the data type, from the drop-down list the name "float".  Next, we need to press the icon with 3 " ... ", this will take us to the Expression Builder screen (Pic9), Now we must choose, by double clicking, from the left hand side of the screen "COUNT( field_name )",  once this is done, then from the right hand side of the screen, double click on " T3."Parts.DB"."OrdersNumber" ".  We are alomost done! Just a few more steps!  Now click "OK" to get back to the "Add a SQL defined field" screen (Pic10), and then once more, hit the "OK" button to exit unto the SQL Builder screen.

10 	From the SQL Builder screen, double click on the CompanyName under the Company.DB table, and then on the right upper part of the screen click on the "Last Field As Labels". Your screen should be like this (Pic11).  This completes the query, however there are 2 possible ways of looking at the results.  You can see the results in a tabular or graphical form.

11 	Before you get to see the results, lets make sure you have asked the right SQL query. To see your SQL query just press the icon which is marked by the letters SQL. Your screen should look like this. (Pic12)

12 	If your screen is identical to the pic 12 then we are in business.  Just press the lightning button on the toolbar to see the tabular results. (Pic13).  If you want a graphical form of this query then press the "OK" button at the bottom of the screen. (Pic14)

13 	Et Voila.  I hope you had fun with all my explanation.  You can continue to learn SQL by doing part 2 listed below.  It simply takes you from where we stoped at item 12 and continue with the same tables asking different query.  Have fun!

Paradox SQL Example Part 2

Learn about the SQL Main Screen

Learn about the SQL Main Screen Tool Bar

Main Tutorial

Main Content Page

Index


Paradox SQL Example Part 2

In this example, we will construct a query that will generate the total price for all ordered item numbres in the sample database datachart has provided.  We will be using the following 3 tables "Company.DB", "Orders.DB" and "Parts.DB".

1 	In order to get started, the first thing we need to do is to press the "Create Chart" embossed button.

2 	Select, Existing Alias with Detail Options.  Here is what Datachart screen should look like. (Pic)

3 	Then, in the "Open Table" Alias selction, choose "DataChart Sample Paradox".  In the table below, select the table "Company.DB".  Then press the "OK" button. (Pic1)

4 	This will take you to the SQL Builder screen (Pic2).  From the ToolBar menu, select the "Add a new table" icon, it is the icon with a green plus sign.

5 	After you have pressed the "Add a new table" icon, repeat the steps, as in item 3 and add the table "Orders.DB". (Pic3)

6 	After you have pressed the "Add a new table" icon, the screen "Join Editor" will be display with various option.  At this time, accept all the options given by simply pressing the "OK" button at the bottom of the page. (Pic4)

7 	Repeat step 5 and 6 to add the table "Parts.DB". (Pic5) & (Pic6)

8 	After inserting all 3 tables (Company.DB, Orders.Db and Parts.DB), your screen should look like this (Pic7).  At this point we need to define, using SQL, what we want to view from the tables selected.  Continue by pressing the icon on the toolbar which is to the left of the hammer & wrench.  It is called "Add a SQL defined field".  This is what the next screen will look like. (Pic8)

9 	From this screen we need to type "TotalOrderPrice" in the "field display name type".  We also must select in the data type, from the drop-down list the name "float".  Next, we need to press the icon with 3 " ... ", (Pic8a).

10 	 this will take us to the Expression Builder screen. (Pic8b)  Now we must choose, by double clicking, from the left hand side of the screen "SUM( field_name )",  once this is done, then from the right hand side of the screen, double click on " T3."Parts.DB"."OrderQuantity"  *  T3."Parts.DB"."ItemSalePrice" ".  Note here that we are multiplying two tables!

11 	We are alomost done! Just a few more steps!  Now click "OK" to get back to the "Add a SQL defined field" screen, same as (Pic8a), and then once more, hit the "OK" button to exit unto the SQL Builder screen.

12 	From the SQL Builder screen, double click on the OrderNumber under the Parts.DB table.

13 	Your screen should be like this (Pic8c).  This completes the query, however there are 2 possible ways of looking at the results.  You can see the results in a tabular or graphical form.

14 	Before you get to see the results, lets make sure you have asked the right SQL query. To see your SQL query just press the icon which is marked by the letters SQL. Your screen should look like this. (Pic8d)

15 	If your screen is identical to the pic 8d then we are in business.  Just press the lightning button on the toolbar to see the tabular results. (Pic8e).  If you want a graphical form of this query then press the "OK" button at the bottom of the screen.

Paradox SQL Example

Main Tutorial

Main Content Page

Index


SQL Aggregate Functions

The Expression Builder contains several functions, although this help file is not intended to teach all the SQL possibilities, here are a few example of available aggregate functions:

•	COUNT: produces the number of rows or non null field values that the query selected.

•	SUM: produces the arithmetic sum of all selected values of a given field.

•	AVG: produces the average (mean) of all selected values of a given field.

•	MAX: produces the largest of all selected values of a given field.

•	MIN: produces the smallest of all selected value of a given field.

Boolean Operators

Relational Operators

SQL Screen Display

SQL Screen Display Tool Bar

Index


Boolean Operators

Basic Boolean operators such as AND or NOT are also available with DataChart. They are recognized in SQL as expression that are either TRUE or FALSE, like predicates.  These operators relate one or more true / false values and produce a single true or false value.  To learn more about other valuable SQL variable follow the links bellow.

Expression Builder

SQL Aggregate Functions

Relational Operators

SQL Screen Display

SQL Screen Display Tool Bar

Index


Expression Builder

The expression builder has several functions and operators which can be use to optimize your query.

Please take note that for safety reason the builder is limited to query only.  It cannot delete or edit in any way the database table.


Relational Operators

A relational operator is a mathematical symbol that indicates a certain type of comparison between two values.  Here are some examples:

•	> : greater than

•	< : smaller than

•	=> : equal or greater than

•	<= : smaller or equal to

Boolean Operators

SQL Aggregate Functions

SQL Screen Display

SQL Screen Display Tool Bar

Index


Color Option


Data Editor


Edit Table Join

As you press the edit table join button, the table join master screen will be displayed.  This screen enables the user to edit or delete table join already formed when tables were first added to the SQL Builder.  Every time you insert a new table to the builder the Join Editor will be displayed and the user has to accept or adjust the value that will join the two tables.  To learn more about the join editor follow the links below.

Join Editor

Back to SQL Tool Bar

Index


Join Editor

The Join Editor's purpose, is to automatically provide natural join to table added to the Query.  The user has the choice to either accept or adjust the the following values.(Join Editor's Picture)

1 	Types of join, selection can be either: one to many, or many to many.

2 	First Table join column.  List all the fields of the first table.  User can choose or accept the value provided by the join editor.

3 	Expression to use for the join.  List all the different options to join the two tables.  The user can accept or join the table with the option:  is equal to, is not equal to, is greater than, is not greater than, is less than or equal to,  is not less than or equal to.

4 	Second table join column.  List all the fields of the second table.  User can choose or accept the value provided by the join editor.

There is also a section for special customization of join.  This section provide the user with the added function of joining table with outer join or changing the clause of the expresion between the tables. (Customized Join Editor).

•	Outer Join.  Generally speaking an "inner join" is a join in which records in the righthand column table must match those in the lefthand table.  In other words, there are no blank linked in any part of the query.   The outer join will return all the records from the tables, not just matching ones.  For example if you had queried a table called customer and another called orders and you were trying  to find out how many customer had outstanding orders.  The inner join would generate a list with all the customer having outstanding orders.  Now suppose you had forgot to insert the name of a customer on one of your orders.  The outer join would provide you with a list of all outstanding orders with or without customer names.

The last customized function is the "Join On Clause".  This selection returns the user to the Expression Builder where a new query expression can be selected.

Edit Table Join

Master Table Join

SQL Tool Bar

Index


Master Table Join


Existing Alias

An Alias in short is way to point to a table and or a database.

Some database software by default prefers to use an Alias to refer to a database. An alias may have either a few or several defining parameters.  Typically, one parameter is a disk pathname for a folder.  This difined folder will contain perhaps many files, which comprises database tables, indexes, and other information.  Another parameter will specify a database format, e.g. Paradox or DBase.  Still other parameters may specify whether the database connection is read only, or perhaps some ODBC driver parameters, etc.

It should be noted that MS Access does not use aliases to refer to databases, rather it just specify a *.mdb file which contains all the relevant tables, indexes, and so on, for a database file / table.  It is however possible to make an alias for an Access *.mdb which is explained in the following topic " Making Aliases "

Main Tutorial Screen

Main Content Page

Index


Folder Nav Picture
Folder Navigation


Folder Navigation

The folder navigation selection provide the user with the ability to navigate any drive or folder in order to select a database.

The directory structure should be defaulted to the installation directory of this program.

Main Tutorial Screen

Main Content Screen

Index


Gallery Option Picture


Making Aliases

Follow the links bellow to learn how to make alias for each separate Database types.

Making MSAccess Aliases

Making DBase Aliases

Making PARADOX Aliases


Making MSAccess Aliases

To create an alias for a MS Access database we will assume that you have a file on your hard drive called " AccessDb.mdb " and that it is located in folder " c:\Mydatabase\sample\ ".

To create the alias for the AccessDb.mdb database file you will be required to open the "BDEADMIN" program file that was installed during the installation of DataChart.  When you start the BDEADMIN, choose from the toolbar menu "Object" and then "New".(See Picture)

•	Under the Database Driver Name drop-down list, choose "MSACCESS" and then "OK" (2nd Picture)

•	A new entry under the "Databases" tab is created with a default name of something like "MSACCESS1". (3rd Picture)  Edit the name to a name you prefer...  For the purpose of this exercise, we will call it "My Favorite Data".

•	Last but not least, on the right hand side of the BDEADMIN screen, under the "Definition", "DATABASE NAME", browse using the icon at the end of the line or simply type in, the exact location of the database name you wish to have an alias. For training purpose, type in "C:\Mydatabases\Sample\AccessDb.mdb".

If this database would have actually existed on your drive , you could not use Existing Alias to open this specific database.  If you want you can try the same procedure on one of your favorite Access (*.mdb) files or continue learning things with the links below.

Making Aliases

Main Content Page

Index


Making DBase Aliases

To create an alias for a DBase type database we will assume that you have a file on your hard drive called " DbaseDb.dbf " and that it is located in folder " c:\Mydatabase\sample\ ".

To create the alias for the DbaseDb.dbf database file you will be required to open the "BDEADMIN" program file that was installed during the installation of DataChart.  When you start the BDEADMIN, choose from the toolbar menu "Object" and then "New".(See Picture)

•	Under the Database Driver Name drop-down list, choose "STANDARD" and then "OK" (2nd Picture)

•	A new entry under the "Databases" tab is created with a default name of something like "STANDARD1". (3rd Picture)  Edit the name to a name you prefer...  For the purpose of this exercise, we will call it "Dbase Data".

•	Last but not least, on the right hand side of the BDEADMIN screen, under the "Definition", "DATABASE NAME", browse using the icon at the end of the line or simply type in, the exact location of the database name you wish to have an alias. For training purpose, type in "C:\Mydatabases\Sample\DbaseDb.dbf".

If this database would have actually existed on your drive , you could not use Existing Alias to open this specific database.  If you want you can try the same procedure on one of your favorite DBase (*.dbf) files or continue learning things with the links below.

Making Aliases

Main Content Page

Index


Making Paradox Aliases

To create an alias for a Paradox type database we will assume that you have a file on your hard drive called " ParaDb.db " and that it is located in folder " c:\Mydatabase\sample\ ".

To create the alias for the ParaDb.db database file you will be required to open the "BDEADMIN" program file that was installed during the installation of DataChart.  When you start the BDEADMIN, choose from the toolbar menu "Object" and then "New".(See Picture)

•	Under the Database Driver Name drop-down list, choose "STANDARD" and then "OK" (2nd Picture)

•	A new entry under the "Databases" tab is created with a default name of something like "STANDARD1". (3rd Picture)  Edit the name to a name you prefer...  For the purpose of this exercise, we will call it "My Paradox Data".

•	Last but not least, on the right hand side of the BDEADMIN screen, under the "Definition", "DATABASE NAME", browse using the icon at the end of the line or simply type in, the exact location of the database name you wish to have an alias. For training purpose, type in "C:\Mydatabases\Sample\ParaDb.db".

•	If this database would have actually existed on your drive , you could not use Existing Alias to open this specific database.  If you want you can try the same procedure on one of your favorite Paradox (*.db) files or continue learning things with the links below.

Making Aliases

Main Content Page

Index


MK Alias Pic 1
BDE Administrator (create new alias)


Mk Alias Pic 2
BDE Administrator (database alias)


Mk Alias Pic 3
BDE Administrator (definitions)


MSAccess Pic 1
Main Screen


MSAccess Pic10
Choose Table


MSAccess pic2
Define Selection


MSAccess Pic3
Choose Alias and Table


MSAccess Pic4
Field Selection


MSAccess Pic5
Main Chart Screen


MSAccess Pic6
Open Table


MSAccess Pic7
SQL Screen


MSAccess Pic8
Database Login


MSAccess Pic9
Folder Navigation


Palette and Pattern


Palette Bar


Pattern Bar


Quick Chart

The Numeric Representation "Quick Chart (Single Table) enable the user to quickly visualize any tables with very little efforts.  Three examples are given in the MSAccess, DBase and Paradox tutorials.  Feel free to visit these links to learn more about how to make charts and graphs using the Quick Chart methods.

NOTE:  Some fields in your database tables may contain character, text or strings of text, such as perhaps a name field.  These fields cannot be graphically represented.

Should you select one of these fields accidently, you can use the Reset field button on the Chart and Graph Screen Tool Bar.

Main Tutorial

Main Content Page

Index


Select Fields to Graph

Using a field selection dialog, select field names from the "Fields Not Displayed" list, and use the arrow button to move the chosen fields to the "Fields To Show On Graph List".  The double arrow can be used to move all fields simultaneously.

If any chosen field cannot be understood as numeric, a message will be displayed to indicate the problem.  The numeric values in the chosen fields will be used to create a chart, with the first record's values on the left, and the last record's values on the right.  The chart will contain a scroll bar if needed.

If several fields are chosen, the chart may have difficulty displaying the information within the space available.  Limitations depend on the video resolution being used, and whether the application window is maximized or not.

Main Contents

Index


Show and Hide Series Legend

Depressing this button causes a series legend display to appear on the right hand side of the chart.  The series titles correspond to the field names in the database table being charted.

Note:

If you right click mouse while in the legend area, you will be shown a menu allowing you to make your legend a floating type or adjusted to the left, right, top, or bottom of your screen.

Additionally the!"Option" selection enables the tser to format the legend box wiuh the following caracteristics:

•	Draw Border

•	Draw Spliter

•	3D Frame

•	Skip Empty

•	Multiline

Chart Tool Bar

Index


SQL Demo00
Define Selection


SQL Demo01
Open Table


SQL Demo02
SQL Builder


SQL Demo03
Open Table


SQL Demo04
Join Editor


SQL Demo05
Open Table


SQL Demo06
Join Editor


SQL Demo07
SQL Builder


SQL Demo08
Field Definition


SQL Demo09
Expression Builder


SQL Demo10
Field Definition


SQL Demo11
SQL Builder


SQL Demo12
SQL Text Panel


SQL Demo13
Tabular Result


SQL Demo14
Main Chart Screen


SQL Demo15
SQL Builder


SQL Demo16
Expression Builder


SQL Demo17
SQL Builder


SQL Demo18
SQL Text Panel


SQL Demo19
Tabular Result


SQL Demo20
Field Definition


SQL Demo21
Join Editor


SQL Demo22
Customized Join Editor


(Customized Join Editor)

<SQL Demo22>


(Join Editor's Picture)

<SQL Demo21>


(Pic-1)

<SQL Demo14>


(Pic11)

<SQL Demo11>


(Pic12)

<SQL Demo12>


(Pic13)

<SQL Demo13>


(Pic14)

<SQL Demo14>


(Pic16)

<SQL Demo16>


(Picture)

<MSAccess Pic 1>


2nd Picture

<Mk Alias Pic 2>


3rd Picture

<Mk Alias Pic 3>


Alphabetical Index


Chart Tool Bar

<Chart Screen Display Tool Bar>


Click here

<Making Aliases>


clicking here

<Paradox SQL Example>


Customized Join Editor

<SQL Demo22>


Data Editor

<Data Editor>


DBase

<DBase Tutorial>


Detail Option

<Detail Option>


Editor Table Join

<Edit Table Join>


Existing Alias

<Existing Alias>


Folder Navigation

<Folder Navigation>


Join Editor's Picture

<SQL Demo21>


Making Alias

<Making Aliases>


Making Aliases

<Making Aliases>


MSAccess

<MS Access Tutorial>


Palette Ba

<Pallette Bar>


Palette Bar

<Palette Bar>


Paradox

<Paradox Tutorial>


pattern and palette

<Palette and Pattern>


Pattern Bar

<Pattern Bar>


pic#1

<MSAccess Pic 1>


pic#2

<MSAccess pic2>


pic#3

<MSAccess Pic3>


pic#4

<MSAccess Pic4>


pic#5

<MSAccess Pic5>


pic#6

<MSAccess Pic6>


pic#7

<MSAccess Pic7>


Pic

<SQL Demo00>


Pic1

<SQL Demo01>


Pic10

<SQL Demo10>


Pic10

<SQL Demo16>


Pic11

<SQL Demo17>


Pic12

<SQL Demo18>


Pic13

<SQL Demo19>


Pic2

<SQL Demo02>


Pic3

<SQL Demo03>


Pic4

<SQL Demo04>


Pic5

<SQL Demo05>


Pic6

<SQL Demo06>


Pic7

<SQL Demo07>


Pic8

<SQL Demo08>


Pic8a

<SQL Demo20>


Pic8b

<SQL Demo16>


Pic8c

<SQL Demo17>


Pic8d

<SQL Demo19>


Pic8e

<SQL Demo19>


Pic9

<SQL Demo09>


picture#1

<MSAccess Pic 1>


picture#2

<MSAccess pic2>


picture#3

<MSAccess Pic9>


picture#4

<MSAccess Pic8>


picture#5

<MSAccess Pic10>


picture#6

<MSAccess Pic4>


picture#7

<MSAccess Pic5>


picture#8

<MSAccess Pic7>


Picture

<SQL Demo15>


Quick Chart

<Quick Chart>


See Picture

<MK Alias Pic 1>


Series Legend

<Show and Hide Series Legend>


SQL

<SQL Screen Display>


table join master screen

<Master Table Join>


Take a look

<Gallery Option Picture>


want to look at it

<Color Option>