Maricopa Community Colleges  CIS164AC   19996-20015 
Official Course Description:   MCCCD Approval:  03/23/99
CIS164AC     19996-20015 L+L 3 Credit(s) 4 Period(s)
Oracle: Developer Forms I
Building and testing interactive applications consisting of one or more Developer forms modules. Building a complete forms application using Oracle Developer. Customizing forms with graphical user input items, such as check boxes, list items and radio groups. Modifying data access by creating event-related triggers. Prerequisites: (CIS117DO and CIS164AB) or permission of instructor.
 
Go to Competencies    Go to Outline
 
MCCCD Official Course Competencies:
 
CIS164AC   19996-20015 Oracle: Developer Forms I
1. Run a forms application. (I)
2. Create a basic form module. (II)
3. Create custom blocks, control dependencies, and text items. (III, IV, V, VI)
4. Create input and non-input items. (VII, VIII)
5. Modify forms by using triggers. (IX)
6. Work with mouse events, custom messages, and design alerts. (X, XI)
7. Create multiple forms applications. (XII)
8. Enhance the default menu. (XIII)
Go to Description    Go to top of Competencies
 
MCCCD Official Course Outline:
 
CIS164AC   19996-20015 Oracle: Developer Forms I
    I. Running a forms application: retrieving, displaying, modifying, and storing data
      II. Creating a basic form module
          A. Creating a form consisting of blocks
          B. Building a new block using an existing table specification
          C. Saving and running a form module from the designer
          D. Building a master/detail form module
          E. Characteristics of each forms file storage type
        III. Customizing blocks
            A. Modifying the behavior and appearance of blocks and their components to suit an application
            B. Building blocks that do not directly correspond to Oracle tables
            C. Removing redundant blocks and their components
          IV. Controlling dependencies between related areas of information within a form module
              A. The concept of a relation and its properties
              B. Creating a new relation explicitly/implicitly
            V. Creating and modifying text items
              VI. Supporting text items with List of Values (LOVs) and editors
                VII. Creating input items: check boxes, list items, and radio groups
                  VIII. Creating non-input items: display items, image items, and buttons
                    IX. Modifying forms using triggers
                        A. The different categories of triggers
                        B. Planning the type and scope of triggers in a form
                        C. Creating and modifying triggers that can access the database
                      X. Causing the forms application to respond to mouse events
                        XI. Constructing custom messages and design alerts
                          XII. Creating multiple forms applications
                              A. Starting additional forms with the same transaction and session
                              B. Passing values between forms using global variables
                            XIII. Enhancing the default menu
                                A. Adding basic menu items
                                B. Attaching a menu module to a forms module
                            Go to Description    Go to top of Competencies    Go to top of Outline