Adding addresses with a form

OK, Keeping track of addresses has got to be one of the most common uses for
a database. No mattter what type of buiness it is, you need to keep track of
companies, customers, suppliers addresses. What is the best, most accurate,
easiest way to add addresses with a form. Should they be broken down into
street number, direction (N,S,E,W), and street name? Should a drop down list
be used to input the street name? What is the best way for it to look on a
form? How do you assure that they will be input correctly?


Thanks,

Tom

--
Message posted via http://www.accessmonster.com

The answer to this question depends upon your particular needs. If your
application of addresses needs to be very specific -- for example, addresses
which will be used in conjunction with a GIS database must be very specific,
otherwise, the GIS cannot find the location -- then yes, you might need that
level of detail. I've personally never done anything more specific than
than to break addresses down to Address1, Address2, City, State, Zip.

Linda



"Tom Knapp via AccessMonster.com" wrote in
message ...
OK, Keeping track of addresses has got to be one of the most common uses
for
a database. No mattter what type of buiness it is, you need to keep track
of
companies, customers, suppliers addresses. What is the best, most
accurate,
easiest way to add addresses with a form. Should they be broken down into
street number, direction (N,S,E,W), and street name? Should a drop down
list
be used to input the street name? What is the best way for it to look on a
form? How do you assure that they will be input correctly?


Thanks,

Tom

--
Message posted via http://www.accessmonster.com