Saturday, November 6, 2010

Database project

I have not used Access before, so I learned new skills in each section of the database project.  I learned how to create a new table and how to add fields and field descriptions.  The process of importing data into the database was the most difficult part of this project for me.  This was because some of the field descriptions that I used did not match those in the data I was importing.  Also, date fields like birthdates and joined dates were input differently.  It took quite a while to get all of the data to match so the import would work correctly, but I finally learned how to do it. I also learned how to create a Select query, with the data ordered in ascending order.  I learned how to create a Form, add information to the form and set a field so that it is read-only, by using the Lock feature. Finally, I learned how to create a report, where the data is grouped and sorted, and how to add a footer to the report. 

Regarding enhancements to the database, I thought of several types of information that could be added.  I would think the manager of any business, like a gym, would like to see some financial information on a report.  For example, the report could show the annual or monthly amount each members pays, or whether any members are past due in their payments.  Since the report shows when certain members left, it could also show the reason why they left.  Finally, for the “Individual” members, the report could show if they are married or have children, so that the manager could sell to the family members. 

No comments:

Post a Comment