Picture of Tynyfelin

Opentrain Oracle Courses

Tyn Y Felin, Penmynydd Road, Llangefni, Anglesey, LL77 7SF
Email: sales@opentrain.co.uk

View from Tyn Y Felin

Oracle SQL

Oracle PL/SQL

Oracle Forms

Oracle Reports

Residential Courses

Prices

Location

 

Oracle Form Builder: Forms Fundamentals
Computer based training course 

Course ID: 61211


Course Overview

This course is the first in a six-part Oracle Form Builder series that is based on Oracle Developer/2000 Release 2. This course introduces the learner to the key features, components, and capabilities of Developer/2000. In addition, this course will help participants learn how to run, create, and customize a form module.

Learn To:

  • Identify the key features, components and capabilities of Developer/2000.
  • Identify the features of the Form Builder environment.
  • Run and create a basic form module.
  • Customize a form module.

Content Emphasis

Skills-Based

Audience

Application developers, database administrators, designer/developers, and technical support professionals. Prior to taking this course, participants should be familiar with SQL and PL/SQL using Procedure Builder, or have taken courses 61111, 61112 and 61113.

Total Learning Time

7 - 8 Hour(s)


Course Contents

Unit 1: Developer/2000 and Form Builder: An Overview

Duration: 3 - 4 Hour(s)

  • Identify the features of Developer/2000.
  • Match the components of Developer/2000 with the tasks that they enable.
  • Identify the common features of Developer/2000 Components.
  • Identify the features of Oracle Toolkit.
  • Identify the features of the Developer/2000 main menu.
  • Set preferences to customize a Developer/2000 session by using the Preferences dialog box.
  • Match the main environment variables with their descriptions.
  • Identify the tasks that various Form Builder executables enable.
  • Match each Form Builder module type with its corresponding description.
  • Identify the descriptions of the main components of a Form Module.
  • Identify the features of the Form Builder block types.
  • Match each Form module object type with its description.

Unit 2: Running and Creating a Form Module

Duration: 2 Hour(s)

  • Match the components of the Form Builder runtime environment with their features.
  • Match the different methods for navigating the Form Builder Runtime with their features.
  • Identify the tasks that can be performed in the two modes of Forms Runtime operation.
  • Perform an unrestricted query by using the default functionality.
  • Perform a restricted query by using the Query Where dialog box.
  • Insert a record by using the default functionality.
  • Update a record by using default functionality.
  • Delete a record by using the default functionality.
  • Make changes permanent by using the menu option.
  • Display runtime errors by using the help option.
  • Exit a runtime session by using the menu option.
  • Using a specified option, create a new form module by invoking the Form Builder Wizard.
  • Create a new form module in a Form Builder component by using a given method.
  • Set the properties of a form module in the Object Navigator by using the Property Palette.
  • Identify the features of the Form Builder wizards.
  • Create a new data block by using the Data Block Wizard.
  • Modify a layout of a data block by using the Layout Wizard in reentrant mode.
  • Deliver a form module based on given specifics.
  • Match the module type extensions with their storage format.
  • Identify and create a master-detail relationship.
  • Identify the definition of a master-detail relationship.
  • Create a master-detail form module by using the Data Block Wizard.

Unit 3: Customizing a Form Module

Duration: 2 Hour(s)

  • Match the component names with their components in the Property Palette.
  • Create a visual attribute in the Object Navigator by using the Create icon.
  • Modify the properties that control the behavior of a data block by using the Property Palette.
  • Modify the properties that control the appearance of a data block by using the Property Palette.
  • Modify the frame properties of a data block by using the Property Palette.
  • Set properties on multiple objects by using the Property Palette.
  • Create a control block in the Object Navigator by using the Create icon.
  • Delete a data block in the Object Navigator by using the Delete icon.
  • Create a text item in a builder component by using a specific method.
  • Modify the appearance of a text item by using the Property Palette.
  • Modify the properties that control the data of a text item by using the Property Palette.
  • Modify the properties that enhance the relationship between text item and database by using the Property Palette.
  • Modify the properties that add functionality to a text item by using the Property Palette.
  • Modify the properties that alter the navigational behavior of a text item by using the Property Palette.
  • Modify the properties that provide context sensitive help by using the Property Palette.




Anglesey has over 125 miles of coastline designated "areas of Natural Outstanding Beauty".

Tyn Y Felin is a mere five minutes away from the A55 North Wales Coast Expressway and is a perfectly situated coastal retreat on the serene and beautiful Isle of Anglesey.