Database Project

In the last two weeks we had to work on a project which included the use of Microsoft Access. In that project we were supposed to imagine that we work for a local gym and got the request to set up a database to store individual information about the gym's members. As I had never used the software Microsoft Access before, I learned a lot of new things during that project. It all started with making up 5 entries for our database, including different individual information. Then we imported a list of 1000 members of the gym which then became the basis of all further operations we did. Accordingly we set up a query where we differentiated members having an individual membership and having left the gym during the last 6 months. Furthermore we set up a "new members form" to enter data for potential new members, and we created a report about the database. As said before, I never used Microsoft Access before, thus all these tasks were very helpful for me to learn about databases and Microsoft Access.

To further improve the created database one could e.g. also add new fields to the database to find out the reasons why people want to go to the gym. As the manager of the gym this information could be helpful to further customize your gym in terms of work-out methods, training offers, cardio machines, and so on. One could for example include a field called "reason" where people could enter their intention when they join the gym. You could also put this than in the form of a report to better present the reasons to the manager of the gym. But this all depends on the purpose of the database, and should just be considered as one possible extension of the functionality of the database.

All in all I really liked that project as this was a very good and practical way to learn about a software which could be very helpful in the future.