microsoft access training - linking table ms access

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

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

microsoft access training - Linking Table in Ms Access

resolvedResolved · Low Priority · Version Standard

Dave has attended:
No courses

Linking Table in Ms Access

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

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 tip:

Dsum

You can create percentage values based on individual products / items by using a Dsum function (used with a grouped query)

[Each value column] / Dsum[field:total for the column needed to be calculated],[tablename]

View all Access hints and tips


Server loaded in 0.08 secs.