Create a Database Application Using The Application Wizard

In this topic, you create a database application using the application wizard. You will create a series of pages, these include, a Form on the EMPLOYEES Table with an Interactive Report, a Master Detail Form on the PROJECTS and TASKS table.


Select Application Builder > Database Applications.




Click Create.




Make sure Database is selected and click Next.




Make sure From Scratch is selected and click Next.




Enter Project Tasks Application for Name and click Next.




This wizard window allows you to create pages in your application. Select the Report and Form Page Type and click the List of Values icon to select a table.




Select the EMPLOYEES table link.




Click Add Page.




Your Report and Form pages were added. You also want to add a Master Detail form. Select the Master Detail page type and select the List of Values icon for the Master Table.




Select the PROJECTS table link.




Select the List of Values icon for the Detail Table.




Notice that you only see the tables that are related to the PROJECTS table. Select the TASKS table link.




Click Add Page.




Notice that two pages will be created, a Report of the Master table which you then will select a project from to see the Master Detail page. Click Next.




You want to have one level of tabs. Click Next.




Accept the default and click Next.




You want to specify a default Date Format for this application. Select the List of Values for Date Format.




Select the 12-JAN-2004 date format link.




Accept the default authentication and click Next.




Accept the default theme which is Theme 21and click Next.




To create the application click Create.




Your application was created successfully. Click Run Application.




Enter hr for Username and oracle for Password and click Login.




The Employee report is displayed. Notice that the default date format for the Hire Date is used. Click one of the edit icons in front of one of the rows to see the form.




This page is the Edit Employee form where you can make changes to an employees data. Click the Projects tab.




This is the Projects Report. Click the edit icon in front of one of the rows to see the Master Detail form.




This page contains the Master Detail form showing all the tasks for a particular project. Note there is currently no data in the Tasks table. You will add data into the Tasks table in a later topic. In the next topic, you modify the Employee Report. Click the Application button at the bottom of the window (which is called the Developer Toolbar).