ms+access+courses - Realtionships

Resolved · Low Priority · Version Standard

Wed 31 Jan 2007, 10:44 Delegate Emily said...

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

Wed 31 Jan 2007, 12:13 Trainer Richard said...

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

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Access tip:

Splittng a database

Split your database into two (at least).

Keep all of your code, forms, reports, etc. in one 'code' database and all of your tables in another 'data' database which is then linked to the 'code' database.

This makes modifications, updates and back-ups that much easier and allows you to work on a new version of your 'code' database without affecting existing users. It also makes it easier should you wish to convert a single user databases into a multi-user networked version.

View all Access hints and tips