Go BackOracle: Forms 4.5 and Reports 2.5

Synopsis
Oracle: Forms 4.5 and Reports 2.5 provides an overview of Oracle Forms 4.5 and Oracle Reports 2.5.

Audience
This course is for programmers who need who need to learn how to create forms and reports in the Oracle Developer/2000 development environment.

Time
4 hours

Product Code: ORDC02
After completing Oracle: Forms 4.5 and Reports 2.5 , the user should be able to:
 
Develop a Forms application, a menu, and a library
Use the PL/SQL Editor in Oracle Forms
Develop tabular and master/detail reports
Use the Data Model Editor, Parameter Form Editor, and Program Unit Editor in Oracle Reports

Overview of Oracle Forms
 
Creating forms modules, windows, blocks, items, and triggers
Getting connected to the database

Introducing Forms Designer
 
Identifying Forms object types
Using the Object Navigator toolbar
Using the Layout Editor toolbar and tool palette
Using Properties windows
Creating a block

The Layout Editor
 
Using item-drawing layout tools
Creating a List of Values (LOV)
Creating the Form Layout

The PL/SQL and Menu Editors
 
Using the PL/SQL Editor
Creating a menu with the Menu Editor

Creating Forms Objects and Libraries
 
Using default capabilities
Creating Forms objects by default
Creating and attaching libraries

Overview of Oracle Reports
 
Defining queries and layouts
Using fields and triggers

Introducing Reports Designer
 
Identifying Reports object types
Using the toolbars and tool palettes
Using Properties sheets
Working with the Data Model

The Reports Designer Editors
 
Using the Data Model Editor
Using the Layout Editor
Using the Parameter Form Editor
Creating triggers with the Program Unit Editor

Displaying Report-Style Formats
 
Creating default layouts
Building a tabular report
Creating a Parameter Form by default

This course is distributed with
 
Exercises that allow users to practice in Oracle Developer/2000
A file containing the text of the exercises
Supplied files that allow you review the answers to the exercises
Supplied files that allow you to replicate a database
Simulations that allow users to practice course skills, even if they don't have access to the Oracle product
An Oracle glossary


 

Go Back