IT Technical & End User
Course Listings

For further information, or to make a telephone booking, or to receive a competitive quotation for an in-house course, you can call Pentland Training now on 0800 328 2766.

All of our training courses can be delivered on your own site, at Pentland Training facilities, or at an off-site venue.

Hot Topics

3-day ITIL Foundation

5-day PRINCE2™ Practitioner

4-day Business Analysis

3-day Project Management Fundamentals

Course Title:
ORACLE Forms Developer

Duration: 5 days

Course Overview
This course teaches you to develop applications using Oracle Forms. Using the Forms Developer application delegates will learn how to customise forms through the use of input items and how to control data access through the use of triggers. This course is very hands-on and allows the delegate to work in a rapid development environment.

Target Audience


Forms developers

Course Objectives


By the end of the course attendees will be able to:

• Create form modules
• Create master-detail forms
• Display form modules in multiple windows
• Link form modules
• Use triggers in their forms
• Reuse objects and code

Prerequisites


Ideally, delegates will have attended the Fundamentals of SQL and SQL*Plus and the Fundamentals of PL/SQL courses.

Course Content


Introduction
• Forms Concepts
• Mandatory Objects
• The Data Block Wizard
• The Layout Wizard

The Development Environment
• Object Navigator
• Layout Editor
• Property Palette

Creating Master-Detail Forms
• Using the Wizards
• Manual Creation

Formatting a Form
• Formatting with the Layout Editor
• Visual Attributes
• Property Classes

Items
• Text Items
• Display Items
• Buttons
• List Items
• Radio Buttons
• Checkboxes

Triggers and Built-Ins
• The Basics of Triggers
• Creating Triggers
• Forms Built-ins

LOVs and Alerts
• Creating LOVS
• Creating Alerts

Frames, Canvases and Windows
• Working with Frames
• Content Canvases
• Stacked Canvases
• Toolbar Canvases
• Tab Canvases and Tab Pages
• Creating Windows
• Window Properties
• Assigning Multiple Content Canvases to a Window

Object Groups and Object Libraries
• How to Create Object Groups
• How to Reuse Object Groups
• How to Create Object Libraries
• How to Reuse Object Libraries

Template Forms
• Creating Template Forms

Using PL/SQL in Forms
• Program Units
• PL/SQL Libraries
• Stored PL/SQL Objects

Forms Calling Forms
• How to Call a Form from Another Form

Beginner’s Guide to Reports
• Creating a Simple Report
• Running Reports from Forms
• Passing Parameters to Reports

Menus
• Creating Menus
• Menu Security
• Pop-Up Menus

Tabbed Canvases

PL/SQL Blocks
• Creating Forms from PL/SQL Blocks

Enter your email address to register for our newsletter: