In this 5 day instructor led class, students will acquire knowledge of how to build Oracle Forms™ using Developer 2000. Students will comprehend working in a graphical user interface environment, and will also learn how to customize forms with user input items such as check boxes, list items, and radio groups. In addition, students will learn how to modify data access by creating event-related triggers. This course will give students basic navigation skills in Oracle Developer 2000 and will also help to prepare the student for Oracle’s exam titled Developer 2000: Build Forms I.
Prerequisites: Before taking this course, student should have at least six months of experience using Advanced SQL and PL/SQL™ in Oracle Developer or take Element K’s course, (079155) Oracle® Developer 2000 r2.1™: PL/SQL Functions, Procedures, and Packages
Benefits: After taking this course, students will be able to create basic Forms, develop a basic application using Forms.
Target student: Students enrolling in this course should know SQL and PL/SQL. This course is intended for people who aspire to become Oracle Developers. In addition, it is beneficial for those who will work as project managers for Oracle Projects, as well as for application support personnel.
Hardware/Software Requirements: You will need:
- Minimum hardware required for Instructor and Student computers:
- Pentium II 266 processor
- 128 megabytes (MB) of Random Access Memory (RAM)
- 6 gigabytes (GB) of available hard disk space
- 256k cache
- 4x CD-ROM drive
- Network adapter and cabling. All student machines should at least have an Internet or World Wide Web connection available
- SVGA monitor
- Sound card with speakers
- Mouse or compatible pointing device
- 3.5 inch floppy or other removable read-write media
- Display system to project the instructor’s computer screen
- Minimum software requirements for Instructor and Student computers:
- Microsoft® Windows NT® 4.0 Workstation with service pack 5
- Oracle8i Personal Edition 8.1.5, 8.1.6, or 8.1.7
- Oracle® Developer 2000 r2.1™
- Microsoft® Notepad 4.0
Lesson objectives help students become comfortable with the course, and also provide a means to evaluate learning. Upon successful completion of this course, students will be able to:
- Identify the components of Oracle Developer 2000.
- Create a basic form module.
- Create input and non-input items in a form module.
- List, describe, and create form triggers and built-ins.
- Make a form module user-friendly and easily navigable.
- Create the components used to build a list of values in a form.
- Create a form with enhancements.
- Create messages and alerts in a form.
- Create a form module that uses the new features of Oracle Developer 2000.
- Use multiple forms, transaction processing, and apply changes to the database.
- Write reusable code.
Lesson 1: Identifying the Components of Oracle®Developer 2000 r2.1™
Topic 1A: Forms 5.0™
Topic 1B: Data Manipulation in Forms
Topic 1C: Reports 3.0 and Graphics 3.0
Lesson 2: Creating a Basic Form Module
Topic 2A: Exploring the Components and Wizards of theForm Builder
Topic 2B: Blocks and Frames
Topic 2C: Creating a Simple Form Module
Topic 2D: Creating a Master-Detail Form Module
Lesson 3: Creating Input and Non-Input Items in a FormModule
Topic 3A: Creating Text Items and Display Items
Topic 3B: Creating List Items and Checkboxes
Topic 3C: Creating a Radio Group
Lesson 4: Form Triggers and Built-Ins
Topic 4A: Describing the Scope of Form Triggers
Topic 4B: Types of Form Triggers
Topic 4C: Forms’ Built-Ins
Topic 4D: Debugging Form Triggers
Lesson 5: Creating Windows, Canvases and Menus
Topic 5A: Creating Windows in a Form Module
Topic 5B: Creating Various Types of Canvases
Topic 5C: Creating Menus and Popup Menus
Lesson 6: List of Values
Topic 6A: Creating a List of Values
Topic 6B: Record Groups
Topic 6C: Editor
Lesson 7: Enhancing a Form
Topic 7A: Adding Color, Shapes and Images to a Form
Topic 7B: Visual Attributes
Topic 7C: Property Classes
Lesson 8: Creating Messages and Alerts
Topic 8A: Forms Messages
Topic 8B: Including Alerts in a Form
Lesson 9: New Features of Oracle Developer 2000
Topic 9A: Adding Tooltips to Items in a Form
Topic 9B: Image Items and Sound Items
Topic 9C: Sub classing and Copying
Topic 9D: Creating Template Forms
Topic 9E: Array Processing in Forms
Lesson 10: Multiple Form Applications and Transaction Processing
Topic 10A: Using Multiple Forms in an Application
Topic 10B: Applying a User’s Changes to the Database
Topic 10C: Creating Sequences
Lesson 11: Reusing Code and Objects
Topic 11A: Flexible Code
Topic 11B: Using System Variables and Built-Ins
Topic 11C: Referencing Objects by Internal ID
Topic 11D: Object Groups
To Hire a proven Oracle Forms Subject Matter Expert Consultant and Instructor who teaches this class, call 800-798-3901 today!