advanced microsoft access in london - Linking Tables

The UK's most regular instructor-led training courses.
Training information: advanced microsoft access in london · Microsoft access courses · Microsoft Access Training London
See also · microsoft access training · access vba courses · access database course

Resolved · Low Priority · Version Standard

Linking Tables

Brian has attended:
Access Intermediate course
Access Advanced course

by - delegate Brian [4 posts] (2007 Mar 16 Fri, 16:55) Reply

Can you link tables from different databases or would it you have to copy the table into the database.

Version	Date	Location	Places available	Book	Next place rate:
Access Intermediate 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Nov 25 Tue	Bloomsbury	4	book now	£207	£215
2002/XP	2008 Nov 26 Wed	Tooting	0	FULL
2003	2008 Dec 2 Tue	Southwark	5	book now	£198	£215
2007	2008 Dec 5 Fri	Bloomsbury	4	book now	£224	£224
2003	2008 Dec 9 Tue	Bloomsbury	0	FULL
2002/XP	2008 Dec 11 Thu	Tooting	0	FULL
Full Schedule: See all 55 Access Intermediate course dates. Bookings currently available until 24th November 2009.

RE: Linking Tables

by - trainer Richard platinum contributer [818 posts] (2007 Mar 20 Tue, 10:09) Reply

Brian,

You can link a table from another database or even an excel spreadhseet.

Use the following:

1. FILE > GET EXTERNAL DATA > LINK
2. Natigate to file
3. Specify table or query to link

Richard

· Do You Have Trouble Understanding Databases? Consider a One-on-One Access Course
· Microsoft Access: Unleash the True Potential Today
· Convert a Paper Trail to a DBMS
· Turning your Spreadsheets into Interactive Data Warehouses with MS Access Courses
· Learn about Subqueries in Access Courses

Access tip:

Create a custom Close button on a Form

By default, Forms that you create in Access have a full set of control buttons, that is, a title bar with Minimize, Maximize and Close buttons in the top right-hand corner and a Control Menu in the top left-hand corner.

Sometimes Access needs to follow certain procedures or events as users close a Form (such as automatically opening another Form perhaps). So it is often a good habit to create a custom Close button on a Form for everyone to use, rather than the standard closing cross.

To create a custom Close button:

1) In Form Design View, draw a Command Button onto the Form.

2) Use the Command Button Wizard to select Form Operations under Categories, and Close Form under Actions.

3) Choose Finish.

Access then creates the button and code to close the form for you. You can add any extra code that needs to run as the Form closes to the same Close procedure.

However, the creation of a custom Close button is pointless if the closing X in the top right-hand corner of the Form remains active. To make the closing X inactive, open the Form Properties box then on the Format tab set the Close Button setting to No. This will grey out the closing X leaving it visible, but inactive.