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.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s