[mso] Re: Access or Excel? :VSMail mx3

  • From: Virtual Executive <virtualexec2000@xxxxxxxxx>
  • To: mso@xxxxxxxxxxxxx
  • Date: Fri, 15 Aug 2003 10:59:02 -0700 (PDT)

Hello James,

I have set up the first table: for the contact info.

In this table, do I make a column for the contact info
AND the 5 different specialties or just the contact
info (name, address, #, etc.)?

Now I am getting ready to set up the second table:
listing all the numerous specialties  

This will be just a very simple table listing ONLY all
the specialties, correct?

Thank you!


--- James LaBorde <jlaborde@xxxxxxxxx> wrote:
> 
> Your best choice would be Access.  I would recommend
> 3 tables, one for your
> contact info, a second for a listing of all
> specialties and a third that
> would list all of the specialties of each contact. 
> This way you could set
> up a form listing the contact in the main part of
> the form and a sub-form to
> list their specialties.  This would allow you to
> enter as many (or as few)
> specialties as each contact has.  It would also make
> searching for specific
> specialties much simpler.
> 
> James
> 
> -----Original Message-----
> From: Virtual Executive
> [mailto:virtualexec2000@xxxxxxxxx]
> Sent: Friday, July 04, 2003 6:12 PM
> To: mso@xxxxxxxxxxxxx
> Subject: [mso] Access or Excel? :VSMail mx3
> 
> 
> Hello everyone,
> 
> I have a contact list of over 500 people.  I need to
> categorize them into the specialties they offer.  
> 
> I have the regular contact info: name, address,
> phone,
> fax, email, website, etc.
> 
> Then each contact has 5 specialties and there are
> easily 70-100+ specialties! (I hope this is making
> sense :-)).  
> 
> I want to set up the best database for my needs. 
> For
> example, a client will contact me and request
> resources for performance improvement or sales.  I
> want to then be able to go to my database and
> retrieve
> all the consultants who specialize in the requested
> resource.  That could be 2-60 consultants.  
> 
> I will also be using this database for mailing
> labels.
> 
> Would it be better to set up a database in Access or
> Excel?  Any suggestions?
> 
> 
> 
> =====
> ~*~*~*~*~*~*~*~*~*~*~*~*
> Virtual Executive Services
> Online and Offsite Assistance
> LaShay Canady, President
> http://www.virtualexecservices.com
> mailto:lashay@xxxxxxxxxxxxxxxxxxxxxxx
> 303-832-2740 (off.)/719-623-0573 (fax)
> 
> __________________________________
> Do you Yahoo!?
> SBC Yahoo! DSL - Now only $29.95 per month!
> http://sbc.yahoo.com
>
*************************************************************
> You are receiving this mail because you subscribed
> to mso@xxxxxxxxxxxxx or
> MicrosoftOffice@xxxxxxxxxxxxxxxx
> 
> To send mail to the group, simply address it to
> mso@xxxxxxxxxxxxx
> 
> To Unsubscribe from this group, send an email to 
> mso-request@xxxxxxxxxxxxx with the word
> "unsubscribe" (without the quotes)
> in the subject line.
> 
> Or, visit the group's homepage and use the dropdown
> menu.  This will also
> allow you to change your email settings to digest or
> vacation (no mail).
> //www.freelists.org/webpage/mso
> 
> To be able to use the files section for sharing
> files with the group, send a
> request to mso-moderators@xxxxxxxxxxxxx and you will
> be sent an invitation
> with instructions.  Once you are a member of the
> files group, you can go
> here to upload/download files:
> http://www.smartgroups.com/vault/msofiles
>
*************************************************************
>
*************************************************************
> You are receiving this mail because you subscribed
> to mso@xxxxxxxxxxxxx or
> MicrosoftOffice@xxxxxxxxxxxxxxxx
> 
> To send mail to the group, simply address it to
> mso@xxxxxxxxxxxxx
> 
> To Unsubscribe from this group, send an email to 
> mso-request@xxxxxxxxxxxxx with the word
> "unsubscribe" (without the quotes) in the subject
> line.
> 
> Or, visit the group's homepage and use the dropdown
> menu.  This will also allow you to change your email
> settings to digest or vacation (no mail).
> //www.freelists.org/webpage/mso
> 
> To be able to use the files section for sharing
> files with the group, send a request to
> mso-moderators@xxxxxxxxxxxxx and you will be sent an
> invitation with instructions.  Once you are a member
> of the files group, you can go here to
> upload/download files:
> http://www.smartgroups.com/vault/msofiles
>
*************************************************************


=====
~*~*~*~*~*~*~*~*~*~*~*~*
Virtual Executive Services
Online and Offsite Assistance
LaShay Canady, President
http://www.virtualexecservices.com
mailto:lashay@xxxxxxxxxxxxxxxxxxxxxxx
303-832-2740 (off.)/719-623-0573 (fax)

__________________________________
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com
*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or 
MicrosoftOffice@xxxxxxxxxxxxxxxx

To send mail to the group, simply address it to mso@xxxxxxxxxxxxx

To Unsubscribe from this group, send an email to 
mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the quotes) in 
the subject line.

Or, visit the group's homepage and use the dropdown menu.  This will also allow 
you to change your email settings to digest or vacation (no mail).
//www.freelists.org/webpage/mso

To be able to use the files section for sharing files with the group, send a 
request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with 
instructions.  Once you are a member of the files group, you can go here to 
upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************

Other related posts: