Steve Zaske posted a blog on data collection a while back. Nice to see folks catching on to this useful feature.
Here is the URL to his original blog post http://steve.zaske.com/?p=12.
BTW - I'm surprised nobody has responded to my post on How do you use Access? There are almost 2,000 readers of this blog. You all are a shy group...
(Sorry, I should really have proof read that first!)
I use Access for a lot of data manipulation, when Excel just isn’t fit for the job, but SQL Server would be overkill.
For example, just recently I pulled down some country stats from the net (it was an economic freedom report) with various scores and past scores. I could use Access really quickly to query, sort, group, rank, and filter results (almost as quickly as I thought of new views I wanted to see).
It gets a bit of flack when used in production environments, but I still love its ease of use, and the assumptions it makes for you.
Clint, the link to the hi-resolution version of the video doesn’t work.
I have removed the link.
Sorry about that. The hi-res video is again available (http://www.loc8r.com/media/Access2007_Demo.wmv)