Access Database Project

After finishing this project in Access, I have learned a lot about this piece of software that I had never used before. Its similarity to the other software applications in Microsoft Office 2007 allowed me to understand the basic functions and made it easy to learn how to maneuver through Access. For me when it comes to Databases, it's out of sight out of mind. Never having known about Access, I never knew there was a such database that made it so easy to sort data the way Access does. I learned how to move data between Access and Excel in order to make the most of the different pieces of software that are out there. I learned how to use my critical thinking to get what I want out of a set of data.


In order to increase the functionality of this database with the data that we have of the membership to the fitness center, I would sort the data in a way that would show me how long the members remained members at the fitness center. This set of data returned the start date as well as the leave date for each member that has left. For those that are no longer members, I would dive into the information to see if I could uncover the reason for them leaving. Using a Query, I would (in theory) subtract the start date from the leave date to see how many months the average member remained a member. This average could then be tracked over time to determine if there was a need for some sort of incentive program for retaining members.

This picture was taken by Karina Mills in 2011 showing the screen shot of part of my Access Project. Pictured is the Query section where I sorted the Individual members who left the gym in the past 6 months by end date and last name.