Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

STL - Formerly Best Training Solutions Through Learning
TrustPilot
Excellent
Request Callback We will call you back
0207 987 3777 Call for assistance
Your Basket Basket is empty
linking external tables

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

Linking external tables?

ResolvedVersion 2003

Hemant has attended:
Access Introduction course
Access Intermediate course
Excel Intermediate course
Excel Advanced course

Linking external tables?

How do you link external tables?

RE: Linking external tables?

Hi Hemant

To link a Access to a table in another database, do the following:

1. In the Access database Select File / Get External Data / Link tables

2. In the Link dialog box search for and locate the required database.

3. Click Link

4. In the Link Tables Wizard select the required table. Click OK.

Your new table appears in Access with the link symbol ready to be used.

Hope this helps

Carlos

Tue 16 Dec 2008: Automatically marked as resolved.

Access tip:

Relationship maps

It is important to create proper relationships between tables. You can use Access to help check your designs and evaluate them by printing them in graphical format to help with design purposes


Click on the Tools menu, click Relationships.
On the File menu, click Print Relationships. View or print as required

View all Access hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.09 secs.