Quick Links ▼

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Access Training and help » microsoft access training - Linking Table in Ms Access

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

microsoft access training - Linking Table in Ms Access

Resolved · Low Priority · Version Standard

Reply Fri 13 Jul 2007, 16:59Delegate Dave said...

Dave has attended:
No courses

Linking Table in Ms Access

How do I link 5 or more database tables together in Microsoft Access 2003?

For upcoming training course dates see: Pricing & availability

Reply Mon 16 Jul 2007, 09:22Trainer David said...

RE: Linking Table in Ms Access

Hi Dave

I hope that you are enjoying Ms Access, and finding our Microsoft office support forum helpful.

Once you have created your tables - with the appropriate primary and foreign keys in, you will need to go into the relationship manager where you can just drag and drop your relationships into place.

Hope this helps
David

Access articles

· Understanding Primary And Foreign Keys In Microsoft Access
· Insert A Real-Time Clock In An Access Form
· How much time could you save with Access?
· How to Find a Third-Party Venue for Microsoft Access Training
· How To Use The New Total Feature In Microsoft Access 2007/10

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.

View all Access hints and tips