Sunday, March 27, 2011

Access Database Project

What I Learned...
The past couple weeks I have been working on the Microsoft Access Database Project. After watching the lectures and working through the project, I learned a lot about databases and how capable they are of making many aspects of business easier. In completing this project, I learned how to import data into a database and make sure it's formatted correctly as it is imported. I also learned how to create tables and modify how and what data is displayed.  In addition to the basic data aspects of Access/databases, I learned how to run queries on the data in the database, then sort and group that data, as well as how to create and edit forms and reports in the database. I really had no idea that Access was such a powerful tool and could be so useful in making businesses run more fluidly.

Improvements for the Gym Owner...
One improvement I can think of from the get go would be for the gym owner to add a "Submit" button to the new member form if he or she is going to have that form on the computer. If you work with Access, it's ok to not have that feature, but for customers or potential customers entering their data in to the database, it may be somewhat confusing to know that your data has been added without the option to "submit" the data. Another improvement, or in this case an addition, that I think should be made to the form is an "interests" section, or something along the same lines. This way you can learn more about your customers and what they want to get out of having a membership at your gym. Then, hopefully you can use this information to hire staff that can cater programs geared toward members' interests and goals and help maximize their membership value and experience...which, in the end, could make your gym more profitable. Finally, I'm sure there are many more ways to improve this database to help the gym owner, but when it comes down to it, what really matters is that it helps him or her, and the company as a whole, to conduct business and serve the members in the best way possible.

No comments:

Post a Comment