Database Project

I had never discovered Microsoft Access before this assignment and the many uses were overwhelming at first. The combined lectures and discussion board made the completion of this assignment possible. The assignment taught me how to use tables and interrelate data. It was interesting to see how any data source could be utilized. Using queries to qualify and categorize data seemed familiar, as so many Microsoft programs have similar functions. I can definitely see how, with a little practice, Access could improve my business capabilities.
The only things I would add to the form to make it better would be cost verifiers. Something to calculate the rate at which they signed up for and their monthly rate, etc. Consider how most gyms give you a high month to month rate and a better annual rate, discounting it further for two or three year commitments. It would be good to have a column to distinguish between rates paid. I guess you could also have a column for dues owed or a list of clients who are in collections for dues owed. That is fairly common for gyms, as clients lose their motivation and stop paying before their contracts expire. The gyms end up sending the clients to collections for the balance of their unfulfilled contract and generally are successful in collecting a portion of the balances.