This project was very informative and interesting. I had never even heard of Microsoft Access before so the experience using the program was quite difficult at first. Access allows users to create tables, reports, queries, and forms using a data set. I found the most useful aspect of this program was that you could import a data set from Excel and Access would turn the data set into a table. As well you could then turn this table into a variety of things helpful to many business's day to day operations. After the first hour of using the program it became fairly easy to use the basic options and I can see the great value it will hold for me in the future.
There are several ways you could enhance this database, but to me the most important way to improve it would be to separate the current members from the past members that had already left. I think that if you created two more queries, one being current members and the other being any members that have left the gym, it would greatly enhance the ability to perhaps find a member to cancel their membership or to even find a departed member to send out direct mailers to try to gain their membership again. I just think that keeping them separate would cut down in the amount of searching through the members to find certain people especially if the members forget their ID number. The last way that I know how to enhance the database is perhaps to make more data fields read only such as birth date, gender, name, and joined date. I would suggest this because these are fields that should never change after the creation of a membership. This would help stop someone from accidentally changing information while trying to add a new member or canceling a membership.
No comments:
Post a Comment