DATABASE Project

I learned a vast amount about Microsoft Access this past week, especially since I had never used before. I think of Access as Microsoft Excel with a specific business orientation. Whatever that business maybe, Access has the tools to fit those business needs and keep things organized. I learned how to take a lot of information about customers - demographics, addresses, phone numbers, etc. Then I learned how to take that information and put into new member forms by requesting only those individuals that met certain criteria. I think Access is very useful in that regard.

I think one way to increase the functionality of this database would be to specify it more according to the gym's business model. Are clients signing membership contracts for a year, month-to-month, or no contract. We could further define the customers by membership length instead from a membership standpoint of just "individual" or "family." I think having this aspect of the database will allow the gym to enhance their business by seeing what type of membership most people use, when they cancel, and what membership make the gym the most money.