Sunday, April 4, 2010

Access Database

The Access Database Project was a hugely valuable lesson. As a graduating senior potentially looking for jobs in the digital marketing field, many job descriptions recommend or require experience with databasing and SQL. I feel like the project covered all the basic utilities that I would need to use in Access. My favorite use of Access was in form mode. Once the skeleton of a database is created, I really think that most widespread use would be through forms. I imagine creating a data collection tool to be distributed throughout an organization for use (I can dream can't I?).

If I were to change or improve the database I would like to analyze the frequency of someone using their membership. I understand that this data was not included in the initial members.csv file, but I think it would be a truly interesting analysis. If you were to combine that data with the members who left within 6 months, you can better try and understand why they left or did not renew their membership.I would break down the usage data by check-ins per month. That way you can see whether their usage increased, decreased, or stayed constant over a period and group members into high, medium, and low usage groups.

No comments: