The Database project taught me a lot about Microsoft Access. Watching the lectures from last week explained to me how to complete tasks, but actually using Microsoft Access through the project really familiarized me with the database. Importing the members document into the table that I had already started was the hardest part of the project for me. When I was finally able to figure it out, creating the query, form, and report were fairly easy. I also learned how helpful Microsoft Access could be for a real company. Using the database for the "local gym" allowed me to look at how an actual business would find it helpful and how they could use the database to benefit their company.
To improve the functionality of the members database I would add a few more fields including: e-mail address, picture, and last visit. The e-mail address would provide an easier way of contacting the members and updating them if anything was going on at the gym that they should know about. The picture would be helpful to employees to remember a customer's face and ensure the person using the membership is the member, not a friend or someone pretending to be them. Last visit would be a way for the gym to keep a count of how many people come each day, how often certain people come, etc. This would be helpful also for employees to familiarize themselves with the members that use the gym frequently.
Overall, I think Microsoft Access is a very user friendly database and is very helpful for real world companies.
No comments:
Post a Comment