hello, McFly!

[dchenes]

In July I went cross-eyed breaking down two years of senior promotions by department, by institution, and by department and institution.

In September I went cross-eyed breaking down two years of senior promotions by institution and by institution by month.

This afternoon I went cross-eyed breaking down two years of senior promotions by month and by type by month.

Immediately after that, it occurred to me that with some basic data in an Access database, we can run queries on it and come up with whatever variation on all these statistics somebody's going to want in December, and I won't have to go back through two years of meeting agendas and lists of names, AGAIN.

So I knocked together a teeny little Access database and entered 135 people's promotion data in it, and on Monday I start writing queries. I wish I had thought of that in July.

Comments

[enochs-fable.livejournal.com]

welcome to the wild wooly world of databases! Found any books particularly helpful? Are you using 2003 or 2007?

[dchenes.livejournal.com]

2003, I think. I've put together databases before, just not for this purpose.

[enochs-fable.livejournal.com]

Cool. I'm near the tail end of building a database for a particular project and had to learn some vb to do it. Interesting.