APEX

Hello Everyone,

First I'm Using APEX Version  (select * from v$version;)


I'm looking to get some Help with a Task of Creating a "Simple Transactions" Application using APEX.  
In my Task for School, I'm asked:
1.)  Create a "Transactions" Table and Sequence

*****This is my Main Question*******************************************************************************************************

2.) "Create Simple Application with a Transactions page (Report with Form on Table)
- In the APEX Workspace App Builder Create a Simple Transactions page with Add/Change/Delete Capability.

*****************************************************************************************************************************************
How do I get started with Creating the Simple App After I've go the Tables Created (Below) ?

*****************************************************************************************************************************************

I have Already Created 3 Tables and a Sequence for the Transactions Table for the Primary Key Column Transaction_ID
1.)  Transactions Table
2.)  Transaction_Type Table  -- This Table is a Lookup Table
3.)  Account_Type Table       -- This Table is a Lookup Table

I also Inserted Information the Transaction_Type Table & the Account_Type Table

The scripts I used to Create The Tables, Columns, the Sequence, and Insert Into are listed below:

Create Table Transactions (

       Transaction_ID          Number(7) Default 0,

       Transaction_Type_ID     Number(7) NOT NULL,

       Transaction_Number      Number(7) Default 0 NOT NULL,

       Transaction_Date        TIMESTAMP WITH LOCAL TIME ZONE NOT NULL,

       Payee_Desc              Varchar2(100) NOT NULL,

       Amount                  Number(7,2) NOT NULL,

       Account_Type_ID         Number(7) NOT NULL,

Constraint Transactions_Trans_ID_PK Primary Key (Transaction_ID),

Constraint Transactions_Trans_Type_FK Foreign Key (Transaction_Type)

    References Transaction_Type (Transaction_Type_ID),

Constraint Transactions_Acct_Type_FK Foreign Key (Account_Type)

    References Account_Type (Account_Type_ID),

Constraint Transactions_Trans_Number_UK UNIQUE (Transaction_Number));

--------------------------------------------------------------------------------------------

Create Table Transaction_Type (

    Transaction_Type_ID        Number(7) Default 0,

    Transaction_Type_Desc      Varchar2(100) NOT NULL,

Constraint Transaction_Type_ID_PK Primary Key (Transaction_Type_ID));

--------------------------------------------------------------------------------------------

Create Table Account_Type (

    Account_Type_ID           Number(7) Default 0,

    Account_Type_Desc         Varchar2(100) NOT NULL,

    Balance                   Number(7,2) Default 0,

Constraint Account_Type_ID   Primary Key (Account_Type_ID));

---------------------------------------------------------------------------------------------

Create Sequence Transactions_Trans_ID_seq

Increment By 1

Start With 1

NOMAXVALUE

NOCYCLE

NOCACHE;

---------------------------------------------------------------------------------------------

Insert All

Into Transaction_Type (Transaction_Type_ID, Transaction_Type_Desc) Values (1, 'Payroll Direct Deposit')

Into Transaction_Type (Transaction_Type_ID, Transaction_Type_Desc) Values (2, 'Cash Deposit')

Into Transaction_Type (Transaction_Type_ID, Transaction_Type_Desc) Values (3, 'Check Deposit')

Into Transaction_Type (Transaction_Type_ID, Transaction_Type_Desc) Values (4, 'Check Purchase')

Into Transaction_Type (Transaction_Type_ID, Transaction_Type_Desc) Values (5, 'Check Payment')

Into Transaction_Type (Transaction_Type_ID, Transaction_Type_Desc) Values (6, 'ATM Deposit')

Into Transaction_Type (Transaction_Type_ID, Transaction_Type_Desc) Values (7, 'ATM Withdrawal')

Into Transaction_Type (Transaction_Type_ID, Transaction_Type_Desc) Values (8, 'Electronic Funds Transfer')

Into Transaction_Type (Transaction_Type_ID, Transaction_Type_Desc) Values (9, 'Debit Card Purchase')

Into Transaction_Type (Transaction_Type_ID, Transaction_Type_Desc) Values (10, 'Credit Card Purchase')

Into Transaction_Type (Transaction_Type_ID, Transaction_Type_Desc) Values (11, 'Vehicle Loan')

Into Transaction_Type (Transaction_Type_ID, Transaction_Type_Desc) Values (12, 'Home Loan')

Select 1 From Dual;

Select * from Transaction_Type

--------------------------------------------------------------------------------------------------

Insert All

Into Account_Type (Account_Type_ID, Account_Type_Desc, Balance) Values (1, 'Checking Account',0)

Into Account_Type (Account_Type_ID, Account_Type_Desc, Balance) Values (2, 'Savings Account',0)

Into Account_Type (Account_Type_ID, Account_Type_Desc, Balance) Values (3, 'Business Checking Account',0)

Into Account_Type (Account_Type_ID, Account_Type_Desc, Balance) Values (4, 'Certificate of Deposit',0)

Into Account_Type (Account_Type_ID, Account_Type_Desc, Balance) Values (5, 'Individual Retirement Account',0)

Into Account_Type (Account_Type_ID, Account_Type_Desc, Balance) Values (6, 'Money Market Deposit Account',0)

Into Account_Type (Account_Type_ID, Account_Type_Desc, Balance) Values (7, 'HELOC Account',0)

Select 1 From Dual;

Select * from Account_Type;