Converting Microsoft Access applications

In this section, we will walk through the steps required to convert a Microsoft Access Application to APEX. Converting Microsoft Access applications to APEX involves the following main steps:

1. • Exporting the Microsoft Access metadata

2. • Migrating the Access database to Oracle

3. • Creating an APEX Migration Project

4. • Reviewing and editing application metadata

5. • Generating the application

In this chapter, we will take a closer look at each of the steps required to convert Microsoft Access applications to APEX. We will begin by exporting metadata about our application using the Exporter for Microsoft Access.

Exporting Microsoft Access metadata

The first step in converting a Microsoft Access application is to export the application metadata that will be used to convert the application. APEX provides an Exporter tool that can be used to extract metadata from Microsoft Access versions 97 through 2007. The Exporter tool can be downloaded from the Application...