iSelfSchooling.com  Since 1999     References  |  Search more  | Oracle Syntax  | Free Online Oracle Training

    Home      .Services     Login       Start Learning     Certification      .                 .Share your BELIEF(s)...

 

. Online Accounting        .Copyright & User Agreement   |
    .Vision      .Biography     .Acknowledgement

.Contact Us      .Comments/Suggestions       Email2aFriend    |

 

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)  

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)  

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)  

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)  

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