Project Detail

Description

After reviewing my needs on the mailing list you are working on as well as the other two lists that already exist I have determined that I need to database all these lists.

In addition I have another list of 112 names for datamining from a website.

All told the database will contain apx. 1,141 records inclusive of the 827 you are working on now and the 112 that still need to be datamined.

My feeling is that XL would work fine, but if you prefer access that would also be ok.

Database format - Fields Should be as follows:
First Name
Middle Name
Last Name
Title 1 *** See notes below
Title 2 *** See notes below
Company
Adddress
City
State
Zip
Phone
Fax
Email
County
Profession +++ See notes below
Area of Practice ^^^ See notes below

Notes:
*** Esq. should be filled in this field for all but those in the list called SO CAL Mediators 112.xls

For that List, Esq. should be filled in to Title 1 where Esq. is after their name in the website. In addition, Title 2 should be filled in with "Mediator"

For all others (not in SO CAL Mediators 112.xls), Title 2 should be "Attorney at Law"

+++ Profession "Attorney" should be filled in this field for all but those in the list called SO CAL Mediators 112.xls

For that List, Profession is "Mediator"

^^^ This is based on the Tab Names in the XL file you have, and the file names for the others.
All areas of Practice should be:
Estate
Mediator
Bankruptsy
Family Law
Taxation



Additional files submitted:
Additional Lists.zip