|
More Resources by
Google: |
|
|
|
|
IMPORTANT-READ
CAREFULLY
Before
going through your Hands-On training, lets take note of the following
important definitions to remember:
-
The main Form Builder
components are FORM modules, MENU modules, PL/SQL libraries, and Object
libraries.
-
The Form Module is a
binary program code that is generated by Form Builder.
-
The Menu Module is a
binary menu code that should be compiled and used by the Form Module.
-
The PL/SQL libraries are
storage for stored procedure.
-
The Object libraries are
storage for FORM objects.
-
The four types of canvases
are: Content, Stacked, Tab, and Toolbar.
All can coexist within a single window.
-
A content canvas is the
basic background for all windows.
-
A stacked canvas lays on
top of the others.
-
A tab canvas is the same
as stacked canvases with handy “tabs” at the top.
It can simply move from one canvas to another.
-
A toolbar canvas contains
push buttons giving users quick access.
-
Data Block Wizard will be
used to create and modify data blocks.
-
Layout Wizard is used in
Form Builder to create, and modify forms quickly and efficiently.
The Layout Wizard asks you a series of questions and then generates a
basic form that fulfills the criteria you have specified. You can later use
the Layout Wizard to modify the form if you want to change its fundamental
design or contents. You always
can modify the layout manually to better suit your applications’ needs.
-
A master/detail relationship
or parent/child relationship is a relationship between two data blocks.
A primary key of a master table is referenced by a foreign key in the
detail table.
-
In Hands-On 01, you will
experience how to use Form Builder, tab canvas, and master/detail
relationship.
-
The Property Palette
provides complete control over your objects.
It contains the property list of an object.
The properties are grouped by category.
-
The properties of an
object can be changed to control the behavior of the object.
-
The Item properties such as
Tooltip, Hint, and Display Hint automatically, will be used to
provide item-level assistance for the client.
-
A text item appearance can be
modified by manipulating properties such as Justification, or Format Mask
properties
-
In Hands-On 02, you will
learn how to use Tooltip, Hint, and format mask properties.
-
A List of Values (LOV) is
a modal window that populates a text item based on a selection made by the
user from the list. The user can search a List of Values (LOV) for strings
that occur anywhere within the values.
-
A Record Group is a query
that displays data from the database into the List of Values.
-
In Hands-On 03, you will
experience how to work with a list of values or “LOV”, and a record
group.
-
A radio button group
allows values stored in a data source column to display in a more graphical
fashion, by having one radio button assigned to each possible value. Once a
radio group is created, each radio button within it must be assigned a
unique value.
-
In Hands-On 04, you will
experience how to use radio buttons.
-
Display items are
read-only items and are only useful for calculated data such as subtotals
and unchangeable data.
-
For controlling the data within a
text item or display item, you can use properties such as Calculation
Mode, and Lowest and Highest value.
-
Summary columns can be
read-only or text items. They
will calculate average, sum, min and max of a group of items in a block.
-
Function columns also can
be read-only or text items. They
return calculations of binding variables
-
In Hands-On 05, you will
experience how to work with display items, and summary and function columns.
-
A forms trigger is a set
of PL/SQL actions that happen each time an event such as
when-checkbox-changed, when-button-pressed, or when-new-record-instance
occurs.
-
A Post-Query trigger fires
after records are retrieved but before they are displayed.
So, you can use it to enhance a query’s records in a number of
ways. Your Post-Query trigger
can contain code to calculate or populate control items.
-
In Hands-On 06, you will
experience how to work with triggers to display the product description on
the FORM module.
-
A Property Palette
contains object properties. The contents of the Property Palette are referred
to as the “Property sheet” for the object.
You use the Property Palette to modify object properties.
To open the Property Palette of an object, go to the object and right
click on the mouse button then select Property Palette.
Now,
you should first read your case study, and try to solve the questions. Then play the Hands-On training movie until you become
familiar with the subject. For more
information about the subject, you are encouraged to read from a wide selection
of available books.
Good
luck! |