Forum home » Delegate support and help forum » Microsoft Access Training and help » Linking tables

Linking tables

ResolvedVersion 2003

Thu 19 Feb 2009, 16:31 Delegate Parnam said...

Parnam has attended:
Access Introduction course
Access Intermediate course
Access Advanced course

Linking tables

Would it be possible to link 2 external tables to a query and how?

Fri 27 Feb 2009, 11:30 Trainer Simon said...

RE: linking tables

Hi Parnam,

Thank you for your question.

If you open the database and then open the File menu and choose Get External Data and Link Tables.

Find the database that contains the table you want to query and click Link.

Then select the table you want to link to and click OK.

Now you can query the External Table.

I hope this answers your question.

Regards

Simon

Thu 5 Mar 2009: Automatically marked as resolved.

Training courses

98.7 % recommend us

More live stats...

Training information:

Access tip:

Hide Access Tables

One method of stopping your Access tables appearing in Database window, is to rename the table(s) with the prefix usys.

This converts the table into a system object, which cannot be viewed in the Database window.

You can show system objects in the Database window by the following:

Step 1: On the Tools menu, click Options.
Step 2: Click the View tab.
Under Show, select the System Objects check box.
Click OK.

View all Access hints and tips

Linking tables

Linking tables

RE: linking tables

Access articles

Access tip:

Hide Access Tables