Article: Click on the table that you want to link. This can be an existing database or a brand new one containing no information. This will help you keep the data straight. Click the "Access" button in the horizontal toolbar. A dialog box will appear that says "Get External Data." Select the table within that database that you want to link. Click "Ok" when you have located it. " Click "Ok." You may be asked to enter your password at this point. Once it is linked, you can change the data in your new database and it will also change in your original table. This is true of changes in the original file as well. You can link to many tables at once.
What is a summary of what this article is about?
Open the new access database where you will add the table information. Name the table the same name or a similar name as linked table in your other database. Save the database and get ready to link tables. Use the browser button to find the existing database that holds the table you want to link. Select the radio button that says "Link to the data source by creating a linked table. Wait for the table to appear. Repeat the procedure.