Tools from Database Architect Ed Tuggy
In order to keep track of egg production on our homestead, I wanted a calendar that would show me the entire year on a single page (11 x 8.5 inches), giving me space to write one or two digits for each day of the year. Since I couldn’t find anything like that, I designed a database in Microsoft Access that will print out such a calendar for me using a starting month I specify. Now you can use it, too, for any purpose: e.g., days you jogged and how many miles you jogged, days you had a migraine, etc. You will be amazed at the patterns that appear. You state the purpose in the title you give your calendar, and print out as many different calendars as you need. This solution is offered free of charge. You can download the file here.
Have you ever printed out labels of your contacts in Microsoft Outlook? If so, you had to go through a rigmarole to get the contacts into Microsoft Word, then use a complicated Merge process to print out the labels. I’ve created a database in Microsoft Access called Global Address Master™ that keeps a set of contact records synchronized with those in Outlook, and allows you to select and print out labels quickly and easily. Or perhaps you wanted to send out a mailing that is composed partly of printed labels and partly of e-mails. Global Address Master™ also automates the process of sending paper mail to contacts that want paper mail, and e-mail to those that want e-mail.
Do you use multiple applications or datasets to track contact information?
Have you ever wanted to enter new information for a contact in one
place and have that new information propagated to all the datasets in
your office, avoiding duplication, confusion and frustration? At the
very least, you should be able to synchronize a contact that appears
twice in Outlook, e.g. under
Personal Folders\Contacts and
Business Contact Manager\Business Contacts.
Global Address Master™ already does
this for Outlook, and is customizable to synchronize all your datasets. Other
datasets I have synchronized include ACCPAC (with comma-separated
value [CSV] files), MyMailList, and UPS Address Book. I will be
happy to perform such customizations for you.
Have you ever wanted a contact management database that went beyond first, middle and last names to more international naming conventions? Global Address Master™ gives you first and second names and first and second surnames (i.e., two “last names”). Have you ever wanted a database that could parse more addresses than just the city, state and zip kind? Global Address Master™ already correctly parses many international addresses, and further improvements are under construction.
To get started, read the download instructions, then download Global Address Master™ with or without the runtime. Then read the startup instructions. Please consider sending a contribution if the program meets your needs.