I need help building a database

[homevestors]

Instead of trying to do this by "learning on the fly", I figure someone here must have already experienced or built what I need or tell me where to find it.

Here is what I want. I am in the real estate investing business. We have a full time employee that literally drives neighborhoods looking for distressed properties that I can buy. He writes down the address and then goes online to the courthouse to find the owner's name from the property record card.

In the past, we were copying and pasting those names and addresses to a MS Word file giving us a list of names that cannot be manipulated. Every neighborhood would have a different file name. We would open the Word file, do a mail merge to a post card, and send out mailing for each neighborhood.

I want to know if I can do the same thing here, but have better control of the names we collect. I want to have the neighborhoods seperated with the names of each in it.

Can anyone help me with that? I have attached a sample of what we do now.

I greatly appreciate it.

 

[alastair69]

Instead of trying to do this by "learning on the fly", I figure someone here must have already experienced or built what I need or tell me where to find it.

Here is what I want. I am in the real estate investing business. We have a full time employee that literally drives neighborhoods looking for distressed properties that I can buy. He writes down the address and then goes online to the courthouse to find the owner's name from the property record card.

In the past, we were copying and pasting those names and addresses to a MS Word file giving us a list of names that cannot be manipulated. Every neighborhood would have a different file name. We would open the Word file, do a mail merge to a post card, and send out mailing for each neighborhood.

I want to know if I can do the same thing here, but have better control of the names we collect. I want to have the neighborhoods seperated with the names of each in it.

Can anyone help me with that? I have attached a sample of what we do now.

I greatly appreciate it.

I have a little programme i could let you have a look at, if you send me your wording you normaly use i could let you see.

Regads

Alastair

 

[homevestors]

What do you mean by "wording"? Are you referring to the field names? I can always change and/or add those. If you have something that will get me started, that would be wonderful!

 

[Pat Hartman]

May I suggest a technology upgrade. Invest in a PDA for the person who drives the neighborhoods. There is software you can purchase that lets you create very simple databases. Your scout can enter the address and any other notes in the PDA and then back at the office, the software will let you upload the data into your Access database.

 

[homevestors]

Pat,

That would be great if my guy was even slightly computer literate.

Thanks