Change Database values using MS Access (JDE E1 Oracle)

For people who have problems with SQL, there’s an easier way of changing backend database values. How about using MS Access where you can directly type in the values, and it gets updated or you can Insert, Update Delete & you can export, import…. and all.
Following is the tutorial for setting up MS Access with Oracle Database Backend for JD Edwards EnterpriseOne.

EnterpriseOne 9.0 Learning Resources/Tutorials

The JD Edwards EnterpriseOne Tutorials are created with User Productivity Kit or called as UPK. Oracle UPK provides a collaborative development environment to create system related assets – the “People to System” documentation – which are used throughout the rest of the project lifecycle