Database Project

Well, the Database Project is complete! I feel like I have garnered a tremendous amount of useful information regarding Microsoft Access. While I understand that there is a whole lot more to Access than what was required for this project, it was a very meaningful exercise for me. Meaningful in that I learned that playing around with this software is a very useful teaching tool. There were a couple of instances where I was presented with a problem that was not fixable by just watching the lectures. For example, when I worked on the Reports part of the project everything turned out perfect except for the zip code and left date sections. When I tried to view the report in "print preview" mode, the numbers were not displayed. There were # signs in place of the digits and I couldn't understand why that was occurring. My first thought was to use the "Property Sheet" tab on the ribbon to fix it. However, after trying for probably too long with no success, I moved on to see if there was another way. Finally, I stumbled on a way to fix it. I was in Layout View and noticed when I moved a column over a bit, I could see digits. I then realized that I just needed to add space between the columns. Upon doing so, I was very pleased to see all the data displayed to specification. So while I learned how to maneuver within Access and how to use the software to achieve a desired goal, maybe the biggest takeaway for me was to not be intimidated by the unknown and to take a relaxed approach when an unforeseen problem arises. In other words, don't panic. It can be fixed!

One way to enhance the functionality of this database would be to add a form called "Reason for Leaving". This would be something filled out by members upon termination. You could use this information to see if there is a common element as to why members are leaving. You could then create a marketing campaign to address these issues based on the feedback. This would be a great way to get former members to return and possibly retain current members, while hopefully attracting new members concerned with similar issues at the gym they currently use. Since the member mailing information is already on file, a direct mailing effort would be a perfect way to inform all current and former members of the changes being made to improve service.

That's all for this week! Go Gators!