Topics: Hands-On 06 - Developer Tools (Graphics Builder)
Graphics Builder
lets you to create interactive graphical displays of the data in a database. You
can include these graphics in your forms or reports. Graphics Builder provides
a complete set of drawing and editing tools, along with a “Chart Wizard” to
simplify the process of using the tools.
In this Hands-On,
you learn how to: Create a chart, Write a query, Execute a query, Modify a
query, and Save a chart.
You will create a
chart to show a salary distribution in each department.
|
More Resources by
Google: |
|
|
|
|
Open the “Graphics
Builder” tool.
Create a chart to
show a salary distribution in each department.
Click on the
"chart” icon.
Drag the cursor and
click anywhere on the “layout editor.”
Type the query
name.
Write a query to
show the total salaries paid for each department.
Click "execute" and
login as iself password “schooling” then click “CONNECT.”
Check the query.
Click “OK.”
Type the chart’s
name and it's title (Salary Distributions).
Select the type and
subtype.
Click “OK.”
This is the chart.
Change the
department number to department name.
Click on the “SQL”
icon.
Join the employee
table with the department table and add the department name to the query.
Click “OK.”
Click “Yes,” to
remove the department number from the chart.
This is much easier
to understand, than the previous chart.
Save the chart in
the “iself” folder using the “file system” option.
Now, you should
practice this over and over, until you become a master at it.
Good Luck.
|