A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » New Users
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

? regarding client database



 
 
Thread Tools Display Modes
  #1  
Old February 17th, 2006, 01:52 AM posted to microsoft.public.access.gettingstarted
external usenet poster
 
Posts: n/a
Default ? regarding client database

I am trying to build a client database, which has the info of new potential
clients (ie contact info, emails, etc)

I need to track when we send a letter of intro, send samples, etc

What is the best most efficient way to accomplish this?

thanks,
Robin, Access newbie

  #2  
Old February 17th, 2006, 08:13 AM posted to microsoft.public.access.gettingstarted
external usenet poster
 
Posts: n/a
Default ? regarding client database

Hi Robin,

The most efficient way may well be to buy a ready-made application such
as Act! or Goldmine and to work within its limitations. Otherwise, be
prepared to spend hundreds of hours learning about databases in general
and Access in particular, analysing your business's needs and processes,
and finally designing and implementing the solution, or adapting an
existing one.

The book "Microsoft Office Access 2003 Inside Out" by John L Viescas
includes a real working contact-tracking database. If it doesn't meet
your needs as it stands, by the time you've studied the 1200+ pages
you'll be able to modify it.

Here
http://www.databaseanswers.org/data_...ema_dezign.htm
is a simplified diagram of the tables in an actual
contact/client-tracking database. There are lots of other examples on
that site.

On Thu, 16 Feb 2006 16:52:28 -0800, "rmsilver"
wrote:

I am trying to build a client database, which has the info of new potential
clients (ie contact info, emails, etc)

I need to track when we send a letter of intro, send samples, etc

What is the best most efficient way to accomplish this?

thanks,
Robin, Access newbie


--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.

  #3  
Old February 17th, 2006, 04:58 PM posted to microsoft.public.access.gettingstarted
external usenet poster
 
Posts: n/a
Default ? regarding client database

thanks john-was afraid of that

"John Nurick" wrote:

Hi Robin,

The most efficient way may well be to buy a ready-made application such
as Act! or Goldmine and to work within its limitations. Otherwise, be
prepared to spend hundreds of hours learning about databases in general
and Access in particular, analysing your business's needs and processes,
and finally designing and implementing the solution, or adapting an
existing one.

The book "Microsoft Office Access 2003 Inside Out" by John L Viescas
includes a real working contact-tracking database. If it doesn't meet
your needs as it stands, by the time you've studied the 1200+ pages
you'll be able to modify it.

Here
http://www.databaseanswers.org/data_...ema_dezign.htm
is a simplified diagram of the tables in an actual
contact/client-tracking database. There are lots of other examples on
that site.

On Thu, 16 Feb 2006 16:52:28 -0800, "rmsilver"
wrote:

I am trying to build a client database, which has the info of new potential
clients (ie contact info, emails, etc)

I need to track when we send a letter of intro, send samples, etc

What is the best most efficient way to accomplish this?

thanks,
Robin, Access newbie


--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.


  #4  
Old February 17th, 2006, 06:34 PM posted to microsoft.public.access.gettingstarted
external usenet poster
 
Posts: n/a
Default ? regarding client database

It's not quite that bad! You could start by downloading (for example)
the sample contact management database at
http://office.microsoft.com/en-us/te...178391033.aspx
and getting some ideas from that.

You have, of course, already got a pretty reasonable contact management
system that integrates quite well with Access in the form of Microsoft
Outlook. It might be worth giving some thought to what's best done in
each application and how to pass data from one to the other.

Steve

rmsilver wrote:
thanks john-was afraid of that

"John Nurick" wrote:

Hi Robin,

The most efficient way may well be to buy a ready-made application such
as Act! or Goldmine and to work within its limitations. Otherwise, be
prepared to spend hundreds of hours learning about databases in general
and Access in particular, analysing your business's needs and processes,
and finally designing and implementing the solution, or adapting an
existing one.

The book "Microsoft Office Access 2003 Inside Out" by John L Viescas
includes a real working contact-tracking database. If it doesn't meet
your needs as it stands, by the time you've studied the 1200+ pages
you'll be able to modify it.

Here
http://www.databaseanswers.org/data_...ema_dezign.htm
is a simplified diagram of the tables in an actual
contact/client-tracking database. There are lots of other examples on
that site.

On Thu, 16 Feb 2006 16:52:28 -0800, "rmsilver"
wrote:

I am trying to build a client database, which has the info of new potential
clients (ie contact info, emails, etc)

I need to track when we send a letter of intro, send samples, etc

What is the best most efficient way to accomplish this?

thanks,
Robin, Access newbie

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.


 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Outlook 2003 does not recieve emails Mark Marek Installation & Setup 13 October 18th, 2005 04:51 AM
Networking Database Gary General Discussion 1 June 9th, 2005 04:53 PM
how do I set up a database for client information Insurance Tracie General Discussion 1 May 13th, 2005 05:11 PM
Multiple worksheet queries liam Worksheet Functions 3 February 16th, 2005 07:52 PM
Macro possible? Nimit Mehta Worksheet Functions 5 June 7th, 2004 10:39 PM


All times are GMT +1. The time now is 09:38 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.