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

ms+access+courses - realtionships

Forum home » Delegate support and help forum » Microsoft Access Training and help » ms+access+courses - Realtionships

ms+access+courses - Realtionships

ResolvedVersion Standard

Emily has attended:
Access Introduction course

Realtionships

Hi

I've have created 3 tables. One of these is the main table which holds all of the information I need to know for the events i'm organising this year. these include details such as wheere they're being held, whose working, whether it needs catering etc. I have now created 2 other tables, 1 called 'correspondence' and the other 'booked ambassadors'. Both of these tables hold extra information that i would like to view from the main table but are something that is not visible form the outset (otherwise it would be a very big table!) Now I have already created these tables could you please tell me how to link them togther, adn also from my explanation do you think this is the easiest wa to show this infomration?

Thank you for your help.

regards,

Emily

RE: Realtionships

Hi Emily

Thank you for your question. We cover table reationships in our Access Intermediate course. Also bear in mind that to create effective relationships it does take time and understanding. You may go through several versions of trial and error in trying to create what you are looking for.

We also offer consultancy which mean that we can supply a trainer / consultant to assist you with the creation of your database. Our rates start at

Access tip:

Modal forms

If you have created a form / switchboard and dont want people to get away from using the switchboard, you can change the form properites for Modal to On.

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.1 secs.