old information still golden

This summer it seems my major volunteer effort is going to be assisting with the gathering of heritage and archaeological information inventory for some townships in Simcoe County, the original site of the Huron people.  Interestingly enough,  the starting point is some archaeology reports prepared by Andrew F. Hunter in the period 1900-1910 for the Minister of Education for Ontario.  I have built a prototype database in Microsoft Acess 2007.

I find it intriguing that this information over 100 years old is still the base foundation for archaeological work in this part of Ontario.

database prototype built while getting my blood cleaned in Dialysis run

built a simple prototype database in the first hour or so of my dialysis treatment this afternoon…so built one hand  ed in Microsoft Access 2007….to hold information for an archaeology/heritage inventory for townships in Simcoe County.

I am the “long” guy on my dialysis shift, four and a half hours.  Most patients have their blood cleaned and excess fluid removed for  3.5 to 4 hours.  I go three afternoons per week. I Started dialysis in November of 2008.  Dialysis patients sit in a chair that resembles an easyboy recliner. Patients are given access to individual small television sets with earphones.  Some watch TV, some read, some nap. I use my laptop a couple of times per week.

I dug in on this after a presentation last night to the heritage committee of Springwater Township.   Jamie Hunter, curator of the Huronia Museum, and me, a member of the Huronia Chapter of the Ontario Archaeological Society and a semi-retired technical writer and Access Database systems analyst ( that is a little bit puffed up but not too outrageously), made the presentation which I had built in Powerpoint.  The two of us did wel and the committee seemed sold on the idea of gathering this information about First Nations archaeological sites,  early Euro-Canadian properties and still-standing heritage buildings.  A lot of information has been recorded but it is somewhat scattered.  A database is a good way to gather and share this information.

I am a little rusty in Access and need to brush up on a few things like  one to many relationship table linkage.  Today I built a primary table, one query, one online entry form, and two reports…..with a single test record.

I screen captured the form and the one columnar report and placed them in the revised Powerpoint slide show for use with the next township heritage committee.

It is always best to have a specific project to achieve when trying to learn or relearn software.