Melinda Cooper's Blog

Microsoft Access is definitely in a league of its own. I have to say from the very beginning of the semester when I saw I had to complete a project using Access, I was very skeptical. Mainly because I had never used Access before. I guess you could say I was scared. After watching the lectures, I felt a little more comfortable with Access. After the completion of this project I learned many things that I never knew before. I learned how to create a brand new table. I also learned how to import, export, and append a database to an existing table. To take it a little further, I learned how to create a query and how to adjust a query to meet certain needs. Further, I learned about form and report activity. Form and Report Activity is pretty neat. With the form and report wizards, I learned that you customize a any form or report in so many ways.

There are many ways to enhance the database project. However, we all know the list could go on for days. In my opinion, one way I think that I could enhance this project is to create a different type of report activity. I would utilize the report activity in a different way. I would probably take out the members address and contact information as you already have that in the Members Table, which is just a click away. I would use the report to tell how many active individual and family members were at the gym and whether they were female or male. I think that it is more important to know how many active members (family or individual) you have. I think all the other information is easily gathered from the Members table, so to reduce the information on the report, I would narrow the fields.