iSelfSchooling.com - Copyright © 1999-2009 iSelfSchooling.com ||  References  |  Job Openings  || Login (Staff | Members)
    Home  | Search more...  |  FREE Online VIDEO Oracle Training 

    Oracle Syntax  | Suggestions  | Private Tutoring  | Group Collaboration

  Copyright & User Agreement

Email2aFriend  | Homepage us! |  Bookmark

Services

 Vision/Mission

 Services

 Biography

 Contact Us

 FREE Training

 SQL

 PL/SQL

 Forms 

 Reports

 Other TOOLS

 Fundamentals

 Performance

 OEM

 Application Server

 Grid Control

 Articles

 Prepare for OCP

More Training

 Q & Answers

 SQL-PL/SQL

 DBA

 Developer

 Important Notes

 Case Studies

 9i New Features

 10g New Features

 10g Qs/As

 Grid Control

 OracleAS # I

 OracleAS # II

  LDAP and OID

  HTTP Server

 Instructor-Led

  Virtual Hosts

More to know...

Acknowledgement**

 Who is who

 University Directory

 Links...

 

 

IMPORTANT-READ CAREFULLY

Click here for important notes

More Resources by Google:

 

Forms Case Study

The FORM section consists of 16 user requirements that we will call Hands-On Oracle Form Builder.  In these Hands-On, your client is a company that keeps track of its customers’ orders.  You have been assigned to develop a customer order data entry application based on their requirements.

These are designed to challenge your skills in developing user’s friendly applications.

Assuming, you as a developer gathered the requirements during prototyping sessions with the client, using the Rapid Application Development (RAD) model.

   

Hands-On Form Builder (Internet Applications Tool)

Hands-On 13(Forms) - Manuscript

Your client loves what you have done for them.  But they would like you add the same functionality you did at Hands-On 12 to have it on the main menu of the “Customer Order” application.

You have been assigned to modify the main menu and add functions from Hands-On 12 to their window's main menu.

See Figure 15.

 

Your tasks are:

1-   Modify the default main menu and add a menu item as “Data” and a sub-menu item as “Product Price” on the “Customer Order” Form.

2-   Delete some unused menu items.

3-   Pass product ID as a parameter between these two Form applications.

4-   Run and test all user functional requirements.

 

FYou will learn how to:  create or modify default main menu, use and assign global variable from one form to another, use global variable to execute query base on its parameter, create and use the "WHEN-NEW-FORM-INSTANCE" trigger, use tab canvas, use “object navigator,” use “Data Blocks,” use “Layout Editor,” use “Property Palette,” use “Run Form,” and “Execute Query.”

   

Figure 15

 

 

Hands-On 14(Forms) - Manuscript

Your client wants to have capability to cut, paste, and copy words or lines when they type their comments in the "comments" item at the "Customer" tab canvas.

You have been assigned to add the above functions into the "comments" text item in their application.

See Figure 16.

 

Your tasks are:

1-   Add more functionality into the “comments” text item.

2-   Create pop-up menu to have cut, past, and copy functions.

3-   Associate pop-up menu to the “comments” item.

4-   Run and test all user functional requirements.

 

FYou will learn how to:  create "pop-up" menu, with following functionality "cut," "paste," and  "copy,” use tab canvas, use “object navigator,” use “Data Blocks,” use “Layout Editor,” use “Property Palette,” use “Run Form,” and “Execute Query.”

 

 

Figure 16

 

 

Hands-On 15(Forms) - Manuscript

All your client functional requirements have been met.  Now, your user focuses on the appearance of the application.  They would like you to move and add some objects.  They want their logo be displayed on each of their application tab canvas.

See Figure 17.

 

Your tasks are:

1-   Perform some cosmetic layout changes.

2-   Add a logo to their application.

3-   Copy the logo to each tab canvas.

4-   Run and test all user functional requirements.

FYou will learn how to:  move objects around, create, copy, and paste logo, use tab canvas, use “object navigator,” use “Data Blocks,” use “Layout Editor,” use “Property Palette,” use “Run Form,” and “Execute Query.”

 

 

Figure 17

 

 

Hands-On 16(Forms) - Manuscript

They ask you that they would like to run their application from the desktop.  They want to use Forms “Runtime” to execute their application.

See Figure 18.

 

Your tasks are:

1-   Create an icon on the client PC desktop.

2-   Use Forms “Runtime” to run their application.

3-   Associate their “Customer Order” application to the Forms “Runtime.”

4-   Run and login to application from icon.

5-   Run and test all user functional requirements.

 

FYou will learn how to:  run your application from desktop.

   

Figure 18  

 

 
 
 
Google
 
Web web site