If your business already uses Microsoft Access then you likely have contacts stored in some fashion in one or more Microsoft Access databases. There are a number of strategies for organizing the contacts-related tables and fields including addresses, phones, company relationships, follow-up tasks, communications, etc…
Beyond what data is tracked and how it is organized, another important element to encourage your folks to record critical contact data involves the user interface–the screens, reports and flow of the contact manager.
Building it yourself is fine but the outcome often depends on the amount of time you have to spend refining the look and feel and flow and your skill level.
A great place to start (or land) is the free Contact Template for Access which can be downloaded at http://www.msAccessGurus.com/Contacts.htm
- Names of People and Companies
- Phone numbers
- Email addresses
- and much more
It also includes Project Management and additional tables for common business needs along with some cool address mapping tools.
Try it out. It’s a great business tool and an awesome way to learn (or learn more) about Microsoft Access development.