Objectives
To enable the creation, manipulation, extraction of data from an Oracle database using the Oracle Forms & Reports Interfaces The course takes you through creating basic forms and reports and enhancing them to create the basis of complex applications incorporating formatting techniques and images, logos and objects. The course is organised into chapters covering the course objectives in a lecture format interspersed by set exercises designed to illustrate the points covered and are completed by the delegate.
Course Content
Course content has been developed for real-world, commercial scenarios by our expert instructors. See below for detailed syllabus, or if you have a technical query email .
Duration
5 Days
Who Should Attend
The course is suitable for any personnel involved in the maintenance and development of Oracle applications and for users with some technical knowledge who wish to extend that knowledge and for end users who wish to construct their own reports.
Pre-Requisite Skills
Delegates should have a good knowledge of their operating system, of SQL and PL/SQL.
What You Will Learn
1. Create and maintain Oracle Forms.
2. Use and enhance the Default Forms.
3. Produce complex Forms as Part of an Application.
4. Create and maintain Oracle Reports.
5. Use and enhance the Default report formats.
6. Produce complex tabular, master detail and matrix reports.
7. Produce parameterised front ends for the execution of the report.
Associated Course(s)
Introduction to Forms and Reports
- An overview of the Developer Suite
Invoking the Forms and Reports Designers.
The Object Navigators
- Creating, Deleting, Moving & Copying Objects within the forms and reports Interfaces
The Forms and Reports Designers
Designer Menu
Using Modules
Storing Modules on the Database
Deploying Forms and Reports Applications.
Creating Forms
Creating a Base Table Block.
Adding a Detail Block.
Saving and Generating the Form.
The Runtime Interface.
Normal & Enter Query Mode.
Manipulating the Database.
Inserting, Updating, Deleting.
Transaction Control
Enhancing the Form.
Formatting the Form Layout
Modifying Object Properties
Enhancing Functionality with PL/SQL.
Layout Editor
Setting Visual Attributes
Using the Drawing Options
Using Colour Palettes
The Properties Window
Property Classes
Visual Attributes
The Menu Editor
Creating, Deleting & Moving Menus and Menu Items.
Forms Objects
Blocks & Relations
Items
Generic Property items.
Text Items and Display Items.
Events
Creating Reports.
The Data Model.
The Layout Model.
The Parameter Form
Modifying Properties
Model Objects
Frames, Fields, Boilerplates, Anchors.
Specifying a Runtime Parameter Form.
Formulae & Summaries
Creating Formula Columns.
Creating Group Summaries
Sub-totals & Grand Totals on your Reports
Changing Fonts & Modifying Field Properties
Format Masks
Fonts & Colours
Changing Column Labels
Page Layout
Adjusting Page size.
Specifying Margins.
Page Headers & Footers.
Adding Report Titles.
Adding Report Dates & Page Numbering.
Report Headers & Footers
- Creating Multiple Page Headers & Footers
Anchors
Explicit & Implicit Anchors
Suppressing & Unsuppressing Text field Display
· Creating Forms
· Creating Form Letters
· Creating Mailing Labels
· Creating Matrix Reports
· Combination Reports
Combining default Layouts in a Single Report.
Creating Parameter Forms.
- Parameterising your reports
- Designing Multi-Function Reports.
Adding Buttons, Images and Other Objects to Your Reports.
Creating Templates
Adding Templates to the default design Interface.
The Runtime Interface.
|
|
|