CHAPTER 2Migrating to APEX from Desktop Systems

Many organizations come to rely on systems that have been built using desktop applications such as Microsoft Excel, Access, and similar tools. For example, employees might store their own timekeeping data in an Excel spreadsheet, which is sent to the payroll department each month, or the sales department might keep all its customer details in an Access database. These applications often begin as simple data-entry systems, but evolve over time as more functionality is added or the business rules regarding the data change. Using desktop-based systems to manage data has a number of drawbacks, such as the following:

  • Each person who wants to work with the data needs to install the client software (for ...

Get Pro Oracle Application Express now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.