I wish to extend the an "off the shelf" database template for Microsoft Access 2007/2010. As there is some current functionality to export/import contacts from Outlook, this functionality should remain in tact.
I would like to have the following done:
> Split the Address field into Address1 and Address2 for street address
> Add Categories / SubCategories fields with a separate administrative function to manage categories and subcategories. On the user side, once a main category is selected, the appropriate subcategories would then be populated for selection.
Attached is the stock Access Template as well as the Category List.