Thursday, March 24, 2011

Microsoft Access Database Project

     Having used an Access Database through work for the last few years, I am very familiar with using a database that is already put together. However, this is the first time I have had any option to actually build my own database.  I didn’t realize how much work actually goes into the creation of a database. Nearly everything that we were instructed to do in this project was new to me. I had not created queries, reports, or forms until this project, but now I think I have the knowledge to keep using the Access Database! I particularly like the query function, I definitely think that it is the most useful and is what makes Access different from the rest of the programs in the Office suite. I also learned why Access is used for databases so frequently. It makes it very easy to organize and find data.

     I thought the database seemed pretty functional to begin with, but I believe it to be quite slack on the amount of data. If it is to be used to keep track of information about the customers, I believe it should contain more fields of data than name, address, begin and end date, birthdates, and gender.  I think that the database should also include the amount paid for membership depending on if it was an individual or family account, as well as phone numbers and email addresses.  By including email addresses the gym would be able to send special offers to their customers, and possibly have the ability to recruit new customers through referrals.





No comments:

Post a Comment