Where can I find an editable Contact Manager template for Access?

G

Guest

MS Access community,

I need to find a better solution to organizing a medical contacts list for
my non-profit naturopath referral list. I'm currently using Microsoft
Outlook and with over 9,000 contacts and counting, Outlook is starting to
show its weaknesses as a database app, not to mention performing search or
mining for a specific string is becoming virtually impossible. The DB engine
in Access is much more robust and I think its time to transition to something
more powerful than Outlook, thus my inquiry.

A best-case scenario would be some sort of ready-made relational Contact
Manager database template (with editable fields that can be added, deleted
or modified) that lets me import or merge data fields from Outlook (comma
delimited or otherwise). I would then need to modify some of those fields
(renaming them or changing primary keys) as well as adding new data columns
for details not supplied natively in Outlook.

Anyone have some ideas where to find (or create) such a template? I'm open
for all advice, links, resources or other non-MS database options, but would
prefer Access since it works best with other Office 2003 apps.

I'm kind of in a time-crunch, thus creating one from scratch probably isn't
the best approach since I'm leaving town for a 2 week conference in a few
days. I need to do anything I can to avoid being forced to rely on Outlook
again (and facing even more MS Outlook crashes and field limitations) as I
add another 1,000+ records during this event. What direction should I should
go in getting something like? Thank in advance... Alex aka RunningHoove...
 
A

Arvin Meyer [MVP]

Not sure which version of Office you have, but there is a Contact management
database template wizard which comes with later versions. I'm not sure if
it's installed by default. You might also want to export all of your Outlook
contacts into either a spreadsheet or a database file. Then eliminate the
fields which are unnecessary, and use that as a starting place. At the very
least, it will help with the data conversion.
 
A

aaron.kempf

why would you possibly reccomend Excel?

how could you even do this in Excel

in outlook, right-click IMPORT dude
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top