Microsoft Access Northwind Application Migration

Short Description
Application Migration Workshop. Microsoft Access “Northwind Traders”. Migration to Oracle Application Express. An Oracle Tutorial. May 2007 …

Website: www.oracle.com | Filesize: 2431kb

Content
Oracle Application Express -
Application Migration Workshop
Microsoft Access “Northwind Traders”
Migration to Oracle Application Express
An Oracle Tutorial
May 2007Application Migration Workshop
1.0 Introduction…………………………………………………………………………………………………………………….3
2.0 Export Northwind Traders Metadata…………………………………………………………………………………..3
3.0 Migrate the Microsoft Access Database to Oracle………………………………………………………………..6
4.0 Create an Oracle Application Express Workspace………………………………………………………………18
5.0 Create a Migration Project……………………………………………………………………………………………….18
6.0 Review Your Retrieved Objects……………………………………………………………………………………….20
Tables………………………………………………………………………………………………………………………….20
Queries………………………………………………………………………………………………………………………..40
Forms………………………………………………………………………………………………………………………….43
Reports………………………………………………………………………………………………………………………..50
Databases, Modules, and Pages Information……………………………………………………………………..50
Updated Objects Table……………………………………………………………………………………………………51
7.0 Generate the Oracle Application Express Application…………………………………………………………52
Generate Application Defaults…………………………………………………………………………………………52
Generate Application……………………………………………………………………………………………………..53
8.0 Customize your Oracle Application Express Application…………………………………………………….62
Page 0………………………………………………………………………………………………………………………….62
Navigation List……………………………………………………………………………………………………………..63
Application Name and Logo……………………………………………………………………………………………67
Application Access Control…………………………………………………………………………………………….68
Home Page…………………………………………………………………………………………………………………..70
Login / Logout……………………………………………………………………………………………………………..73
Reports………………………………………………………………………………………………………………………..75
Forms………………………………………………………………………………………………………………………..102
A. Display Image on a Form………………………………………………………………………………………………..108
B. Resolve Invalid Queries………………………………………………………………………………………………….109
C. Screenshots…………………………………………………………………………………………………………………..113
Oracle Application Express - Application Migration Workshop Page 2 of 122…