ms+access+courses - realtionships

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

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

ms+access+courses - Realtionships

resolvedResolved · Low Priority · Version 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:

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


Server loaded in 0.1 secs.