'ms access+course' - Link table

The UK's most regular instructor-led training courses.
Training information: 'ms access+course' · Courses in microsoft access · Microsoft Access Training uk
See also · microsoft access training · access vba courses · access database course

Resolved · Low Priority · Version Standard

Link table

rachael has attended:
Access Introduction course

by - delegate rachael [1 post] (2007 Jan 30 Tue, 16:14) Reply

how do i link to a table from another database?

Version	Date	Location	Places available	Book	Next place rate:
Access Advanced 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2008 Sep 24 Wed	Bloomsbury	0	FULL
2003	2008 Oct 8 Wed	Southwark	4	book now	£224	£235
2003	2008 Oct 24 Fri	Bloomsbury	7	book now	£203	£230
2003	2008 Oct 29 Wed	Bayswater	7	book now	£203	£230
2003	2008 Nov 5 Wed	Southwark	7	book now	£190	£224
2003	2008 Nov 21 Fri	Bloomsbury	7	book now	£110	£224
Full Schedule: See all 53 Access Advanced course dates. Bookings currently available until 25th November 2009.

RE: link table

by - trainer Richard platinum contributer [788 posts] (2007 Jan 30 Tue, 16:44) Reply

use the following:

Click FILE > GET EXTERNAL DATA > LINK TABLES

Then specify the file you want to link, and the appropriate table within the database.

· Take an Access Course to Learn About Relational Databases
· The Benefits of Certified Microsoft Training in Access
· 3 Useful Things You'll Learn in Microsoft Access Training Courses
· Reasons to Consider Microsoft Access Training
· Microsoft Access Cheat Sheet: Tips and Shortcuts

Access tip:

Compact database automoatically

To ensure optimal performance, you should compact and repair your

Open the Access database or Access project that you want Access to compact automatically.
On the Tools menu, click Options.
Click the General tab.
Select the Compact on Close check box.

View all Access hints and tips