Do you have tasks or procedures that you do only occasionally, perhaps just once a year? I tackled one of my annual projects recently.
I maintain the membership database for my hand spinning guild (Illinois Prairie Spinners). Before I produce the annual membership directory, I send members customized letters that list their current information and ask for updates if needed. I start by modifying the previous year’s mail merge template that pulls information from the membership database in Access. However, making these changes can be tricky, as there are nested IF…ELSE statements in the template. These need to be changed in several places. I also need to update fields and queries in Access. It’s difficult to remember the details from year to year. For example, does -1 in an Access query mean True or False? (True!)
So I was pleased to find my notes from last year’s verification project. I’d forgotten that I’d written them, but fortunately I had saved them where I would come across them this year. They saved me lots of time and frustration.
The next time you’re working on tasks you only do once in a while, take a few extra minutes to jot down some notes on your procedures. They don’t need to be elaborate, but record key steps or details that are difficult to remember or time-consuming to recreate. Save your notes where you will find them again easily when you next do the task. You’ll be glad you did! Eventually you may even want to develop your notes into a detailed written procedure, which could enable you to hand off the project to someone else.
Have you used this technique to save yourself time and frustration? Share your ideas by posting a comment!