The UK's Number 1 for Microsoft Office Training

Sitemap

Bookmark page

Printable version

Course updates
due to adverse
weather conditions

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Access Training and help » Access

	98.3 % recommend us
	More live stats...

Bookmark this page

Share this with a friend or colleague:

The UK's most regular
instructor-led training courses.

Training information:

Access

Resolved · Low Priority · Version 2007

ReplyMon 22 Jun 2009, 16:38Delegate Jo said...

Access

Do I need to create a second table for more than one contact name at a company/customer entry?

For upcoming training course dates see: Pricing & availability

ReplyTue 23 Jun 2009, 10:24Trainer Rajeev said...

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

Mon 29 Jun 2009: Automatically marked as resolved.

Access articles

· Innovation with Microsoft Access
· Why a Microsoft Access Course Could Change the Way You Do Business
· How Access Can Provide The Key To Successful Stock Management
· What Is The Database Documenter And How Is It Used?
· One To Many Relationships In Access

Please browse our web site to find out more about
microsoft-access-courses and other Microsoft training courses.

Access tip:

Choosing data types in Access

Not sure which data type to use for your Access fields? Here are some guidelines to help you choose a data type to assign to a field.

- The Text data type can accept up to 255 characters. For information that will be recorded in paragraphs, use Memo.

- Also use Text for numbers that aren't going to be used in calculations, e.g. phone numbers.

- Use the Currency data type for monetary amounts.

- Use Date/Time for dates.

- Most other numbers can use the Number data type, but the Field Size property may have to be altered.

- For fields that have only two alternatives (yes, no) use Yes/No data type. If there is likely to be a third entry option (e.g. maybe or don't know) use Text instead.

View all Access hints and tips

The Benefit Of Using Outlook Calendars

For many of us, Outlook is used for emailing, and that can keep us busy for much of the time catching up on activities, responding to messages and keeping track of what people are up to. However Outlook Calendars can be just as powerful, and for many email users, it's a natural progression to use calendars.

» Article: Microsoft outlook courses

When should this function be used? For what purpose? Should it be used in combination with another function?

Thanks