Oracle Form Builder: Enhancing the User Interface

Audience

Application developers database administrators designer/developers and technical support professionals. Prior to taking this course participants should be familiar with SQL and PL/SQL or have taken courses 61110 61111 61112 and 60113. In addition participants should have taken the first part of the Oracle Form Builder series: Course 61211 Oracle Form Builder: Forms Fundamentals.

Objective

• Create input and noninput items.
• Create Lists of Values (LOVs) and Editors that are Form Builder objects to supplement the text item object.
• Create and set properties for Windows and Canvases.
• Identify the events associated components and execution hierarchy of triggers.
• Add functionality to input and noninput items by creating triggers containing builtins.

Topics Include

Unit 1: Creating

• Identify and create input items.
• Identify the input item types.
• Create a check box in the Layout Editor by using the Check Box tool.
• Convert an existing item into a check box in the Layout Editor by using the Property Palette.
• Create a list item in the layout Editor by using the List Item tool.
• Convert an existing item into a list item in the Layout Editor by using the Property Palette.
• Create a radio group item in the Layout Editor by using the Radio Button tool.
• Convert an existing item into a radio group item in the Layout Editor by using the Property Palette.
• Identify non-input item types.
• Create a display item in the Layout Editor by using the Display Item tool.
• Create an image item in the Layout Editor by using the Image Item tool.
• Create a sound item in the Layout Editor by using the Sound Item tool.
• Create a button in the Layout Editor by using the Button tool.
• Create a calculated field based on a formula by creating a new item using the Create icon in the Object Navigator.
• Create a calculated field based on a summary by creating a new item using the Create icon in the Object Navigator.

Unit 2: LOVs and Editors

• Create and attach LOVs and Editors.
• Identify the features of LOVs.
• Identify the objects required to design a LOV.
• Identify the uses of record groups.
• Create a LOV by using the New LOV dialog box.
• Set LOV properties by using the Property Palette.
• Attach a LOV with a text item by using the Property Palette.
• Create a customized editor by using the Create icon in the Object Navigator.
• Attach an editor with a text item by using the Property Palette.

Unit 3: Windows and Canvases

• Match the display objects with their definitions.
• Match the types of windows with their features.
• Identify the definition of a content canvas.
• Identify the benefits of creating a new window.
• Create a new window by using the Create icon in the Object Navigator.
• Set the window object properties by using the Property Palette.
• Create a content canvas by using the Create icon in the Object Navigator.
• Set the Window property of a content canvas by using the Property Palette.
• Create a stacked canvas by using an appropriate method.
• Set the stacked canvas properties by using the Property Palette.
• Check the display position of a stacked canvas in the Layout Editor.
• Create a toolbar canvas by using the Object Navigator.
• Set the toolbar canvas-related properties by using the Property Palette.
• Create a tab canvas by using an appropriate method.
• Set tab canvas-related properties by using the Property Palette.

Unit 4: Form Builder Triggers

• Identify the events that invoke a trigger.
• Identify the trigger type given their description.
• Match the scope of a trigger with their description.
• Identify the statements that are allowed in trigger code.
• Match the execution hierarchy of a trigger with their description.
• Create a trigger by using an appropriate method.
• Match the PL/SQL Editor components with their description.
• Match the trigger properties with their descriptions.
• Identify the rules for writing trigger code.
• Match the Form builder variable name with their type.
• Match the standard built-in subprogram names with their descriptions.
• Copy a built-in name and argument in an existing code.

Unit 5: Adding Functionality

• Create a trigger to add functionality to a radio group.
• Add functionality to a check box by creating a trigger containing the CHECKBOX_CHECKED built-in.
• Add functionality to a List Item by creating a trigger containing built-ins.
• Display LOV from a button by creating a trigger containing the SHOW_LOV built-in.
• Display an image in an image item by creating a trigger containing the READ_IMAGE_FILE built-in.
• Identify the built-ins that can be used to hide or display or get information about each component of a sound item control programmatically.

Duration

8

Minimum Requirements

The CDROM version of this course requires:

• At least a 486DX 33Mhz CPU.
• Microsoft Windows 3.1 or higher and a Microsoft compatible mouse.
• At least 8MB RAM.
• At least VGA graphics capability with a minimum 512K video RAM (1MB video RAM recommended).
• At least a double speed CDROM drive.
• An MPC compliant sound card with attached speakers or headphones is recommended (Currently only the CDROM version supports audio).

• At least a 486DX 33Mhz CPU.
• Microsoft Windows 3.1 or higher and a Microsoft compatible mouse.
• At least 8MB RAM and 22MB available hard disk space or file server space.
• At least VGA graphics capability with a minimum 512K video RAM (1MB video RAM recommended).

Media

CDROM