1- Hands-On 01: Tab canvas, Master-detail relationship

    2- Hands-On 02: Tooltip, Hint, format mask, properties

    3- Hands-On 03: LOVs, Record Group

    4- Hands-On 04: Radio Buttons

    5- Hands-On 05: Display items, Summary and Function columns

    6- Hands-On 06: Triggers (POST-QUERY)

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 main objects in a Form module are:  Windows, Blocks, Items, and Canvases.

• 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!