Access

Dear Jo

Thank you for attending Access 2007 Introduction course!! I hope you enjoyed the course and benefited from it.

Yes, if you are creating a database for contact management where you have companies (your Clients or customers) and within those companies you have contacts then it is advisable that you create two seperate tables. One for Company and One for the Contacts.

You will have Company ID in the Company table as the Primary key and Contact ID in teh contacts Table as the Primary key. Once you have established teh Primary keys then you will assign company ID as a Foreign key in the Contacts table so that you can create a One to Many relationship between the two. One company can have many contacts at one time but one Contact can only be in one company at one time.

Please refer the following link that provides a very good example of a contact management database. I beleive that you can e-mail and get the sample database free of charge from the website owner.

http://www.databaseanswers.org/data_models/contact_management/index.htm

I hope this has answered your query.

If this has answered your query then I would request you to please mark the question as resolved!! If not and you have a specific question related to this then please post it as a new question and we should be able to provide you the solution for it!!

Kindest Regards


Rajeev Rawat
MOS Master Instructor 2000 and 2003
MCAS Master Instructor 2007
MCT