Sunday, November 29, 2009

database work

Met with Ralph today at his home. We reviewed the Access database he uses for the RASC Toronto Centre membership recording keeping. I made a few suggestions and learned more about how he uses it. We added some new fields, built a good query for adding and editing records, and compressed the file (32 MB to 16).

Then, with the database working better, and using a new custom query, we added some missing data, in particular, the member's occupation, and if they are retired. This will help us with some future demographic analysis.

I was most interested in who is involved in the IT industry. Maybe I can recruit some of these people...

Watch out!

No comments: