Enterprises have data stored in different kinds of databases from flat-files to relational databases. It is often necessary to generate reports from disparate databases.  The rapid application development that is possible with MS Access allows one to rapidly deploy the report created to the intranet web site without writing so much as a line of code.   This tutorial shows you the steps involved in creating a MS Access front end in the form of a Data Access Page for an Oracle 10g Express Edition database.  Linked tables are used which are at the heart of distributed queries.  The MS Access project links to the Oracle XE tables using an ODBC connection.  The tutorial also shows how to create a data access page using data from the Oracle XE and host it on the intranet server.

Oracle 10g Express Edition [xe] is Oracle's latest software, downloadable from this link.  It is an easy to administer, free to develop, deploy and distribute product ideal for those who are interested in working with a cutting edge RDBMS.  It has a sample database with which the front end on MS Access has been developed.  After downloading and installing the Oracle 10G XE software, one has to use the Admin credentials to login and give the login permissions to the front end developer.  This is described in considerable detail in the provided link.  Figure 1 shows the object browser in Oracle 10G Express Edition listing all the tables in the sample database, HR.

Figure 1