2. Right click on the center of your MS Access work area and click the "Link Tables" as shown.
3. The Link dialog box would appear as shown below.
4. Click the "Files of Type" pull down menu and click "ODBC Databases".
5. The "Select Data Source" dialog box appears. Click the "New" button.
6. The "Create New Data Source" dialog box opens. The Oracle 10G datasource is already in the dialog if you have already installed it. If you have not yet installed it, download the Oracle 10G ODBC driver from the internet and install in your computer. Click the Oracle 10G driver from among the choices.
7. Type the name you want for your datasource as in shown below. You can name it according to your preferred name, then click "Next".
8. Click the "Finish" button as shown below.
9. Type the credentials required for the database you are connecting/linking to. Service Name (usually "localhost"), user name and; password. Click the "Ok" button.
10. Your datasource link has been created as shown below. Click the "Ok" button.
11. The "Link Tables" dialog opens. Choose the tables you want to connect/link to. Then click the "Ok" button.
12. You have now successfully linked a non-MS Access table to your MS Access database. You can now work on it, create queries using the linked table as if its part of your MS Access database. Practice connecting to a different type of database like MySql. The steps are the same.
