Set up help

[Vaimpir]

I posted this on another thread but I'm at a loss. Here is my dilema:

I want to create a database that records client information, ie, Name, Address, Mailing Address(if different), Phone Number, ect. I also want to record property information for a house the client is selling, ie, Bedrooms, Baths, Squarefeet, Sale Price,ect. And Last I want to record the information for the employee that entered the information, ie, Name, Email Address, Contact Phone.

On saving the record I wnat a confirmation emaled to the employee that entered it. I also want an reminder added to my Outlook Calendar of different follow-up dates for mailers to the client, ie, Accepted, Three Week Follow, Five Week Follow, ect.

I then want to be able to do a search for a specific date once I receive a reminder. This date search will look through all records and display all records that have an association to that date whether it be: Accepted, Three Week Follow, Five Week Follow, ect. Then I can print the appropriate mailing letter from a mail merge for that client.

If someone can help me set this up I would appreciate it. I know my way around Access but still do not have a complete grasp of the program.

Thanks,

Steve

 

[Vaimpir]

Can't someone please point me in the right direction.

Thanks,

Steve

 

[sha7jpm]

cut down the request..

no one is going to help you if you just list all the things you need to do..

try cutting down your requests and being more specific that you require and then people will be able to help you more..

otherwise people just think that you want them to write the db for you which will not happen and just put peoples backs up...
for example..

for the emailing issue use docmd.sendobjects... there is lots of threads here regarding that..

as for the table structure then try an employee table, a client table and a property table... make sure you adhere to normalisation (search on the forum) and create the relationships..
.that way you can have 1 to many relationship for clients to property, and 1 to many relationship for employees to property...

the best way is to try that and then post on here with specific queries..

hope this helps a bit...

John