Application Express

Key Features
Reporting
Forms
Charting
Spreadsheet Upload
User Interface Themes
Flow Control and Navigation
Conditionality
External Interfaces and
Extensibility
Security
SQL Workshop Tools

Creating an Application
Saving SQL for Use in Applications
Creating a Report Drill Down Adding a Tabular Form
Editing Application Objects
Applying a New Theme

Build a Functional Application
Creating a Table from a Spreadsheet
Adding a Master Table
Modifying a Table
Adding a Table Using a Script
Adding Constraints
Adding a Master Detail Form
Creating Lists of Values (LOVs)
Adding an Item Validation
Updating the Home Page Navigation List
Adding a Logo
Creating Users
Restricting Access

Tabular Forms
Changing an Updatable Column to a Select List

Parameterised Reports
Report Utilising a Form Input
Creating Regions
Adding Form Items
Adding a Button to Submit a Page
Adding an On-load Process

Control Form Layout
Creating a Table and Data Input Form
Altering Region Attributes
Adding a Region Header and Footer
Making a Region Conditional
Changing Item Types
Label Templates
Changing Buttons

Check Boxes
Multi Value Check Boxes to Filter Content
Adding Check Boxes in a Report

Charts
Creating Chart Queries
Adding Additional Series
Editing Chart Attributes

Upload & Download Files
Creating an Upload Form
Creating a Report with Download Links
Storing Additional Attributes
Storing a Document in a Custom Table
Downloading Documents from the Custom Table

Access Control Page
Access Control Administration
Creating an Access Control Administration Page
Creating an Authentication Function
Updating an Authentication Scheme
Applying Authorisation Schemes to Components

Build & Deploy an Application
Create Summary Reports
Breadcrumb Menus
Email Notification
Application Security

PDF Reports using BI Publisher
Create a Master-detail form
Create a report layout
Link a PDF report to an application

Administrative Features
Export an Application Definition
Import an Application Definition
Create a Workspace
Supporting Objects