Database Project

Unlike all the previous projects, this project was a complete nightmare. However, I did learn the most during this project as I have never used Microsoft Access before. I learned how to create a table, form, run queries and reports. Learning these different techniques was challenging and time consuming, I felt that many of the videos did not help me with my project. I learned much more then I needed to as I played with many of the different buttons trying to figure out how to properly use access. Learning the query was the most beneficial of everything as it is incredibly easy to sort through information with one simple step. This project taught me the fundamentals of Access and I believe it will be of great help in the future if I am ever required to use it.

To make the database more functional I think the owner could sort each of the id's by zipcode. This will help him sort where all of his members live and help the owner target new areas to prospect. Once he gets more members he can add them via the form button that was created and target additional areas. The owner then could sort how many family and individual membership types are in each of those areas and help upgrade individual memberships to family if available. Thus ultimately generating more profit and more revenue for the company.