We've been using excel with linked tabs and a pivot table that ties everything together. It's not perfect, but it's user-friendly, and it works for now. We set it up so that each pest is tied to its "risk" level, which is based on information from museumpest.net. I've attached it to this e-mail, in case any of you would like to modify it for use in your own museum. If you would like to use it, simply add your own unique "Trap Locations" and delete all the information in the "findings" tab.
Megan Jablonski Collections Manager Puget Sound Navy Museum Naval History & Heritage Command 251 1st Street Bremerton, WA 98337 p. (360) 627-2288 f. (360) 627-2273 www.PugetSoundNavyMuseum.org www.history.navy.mil/PSNM www.facebook.com/pugetsoundnavymuseum FOR OFFICIAL USE ONLY - PRIVACY SENSITIVE: ANY MISUSE OR UNAUTHORIZED DISCLOSURE MAY RESULT IN BOTH CIVIL AND CRIMINAL PENALTIES. -----Original Message----- From: pestlist@museumpests.net [mailto:pestlist@museumpests.net] Sent: Wednesday, April 15, 2015 12:21 PM To: pestlist@museumpests.net Subject: [pestlist] RE: IPM Access database? I haven’t found one either, other than the Zak’s Zpest software from museumpests.net, which is helpful and free, but not perfect. Can you post your responses to the list? I’m sure many of us would be interested in knowing what’s out there and how people are tracking their IPM data. Thanks, Dee Dee Stubbs-Lee, CAPC, MA Conservator / Restauratrice New Brunswick Museum/ Musée du Nouveau-Brunswick 277 Douglas Avenue Saint John, New Brunswick E2K 1E5 Canada (506)643-2341 From: pestlist@museumpests.net [mailto:pestlist@museumpests.net] Sent: Wednesday, April 15, 2015 4:01 PM To: pestlist@museumpests.net Subject: [pestlist] IPM Access database? Hi all, We’re interested in creating a custom Access database for our IPM program, but I haven’t had much luck finding a good template or example of one available online. Does anyone have one they might be willing to share? I’d love to take a look at how others have handled this – I’m a bit of a beginner with Access. Many thanks, -Jen logo Jen Tobias Manager of Exhibitions & Art Collections Denver Botanic Gardens 909 York Street Denver, CO 80206 720-865-3636 Phone 720-865-3682 Fax www.botanicgardens.org <http://www.botanicgardens.org/>
PSNM_IPM_2015.xlsx
Description: MS-Excel 2007 spreadsheet
smime.p7s
Description: S/MIME cryptographic signature