Database Project-Microsoft Access

The Database Project was a nice little project, I used Microsoft Access to do my project since I use a PC and not a Mac. I learned so much from the project being that I have never used Microsoft Access before the project. It was real intersting to see how you could import data from an Excel file and turn it to a nice readable table. The project gave me a sense of understanding on how to create a simple report or query, it also showed me how easy it can be to organize data once the database is created for the purpose desired. The only part that I think I will have some trouble with is remembering formulas and such to make validation rules and such.

"Images created by Christopher Ondrako, 2012. Permission granted to reuse with attribution."

 Thinking of ways to enhance the functionality of this database, I thought that we could then export the information back to Excel to create charts and graphs to see trends. These trends could range from Profit, length of membership, what part of year are people joining or cancelling. Another thing is that we could run the report, and those that cancelled, send surveys and offer promotions to return. The survey would give the company an idea on what is going right/wrong and we could adjust accordingly. It would also offer a sense to see if we would need to hire more employees for a certain time of the year or not.

*Permission granted for reuse by Standard YouTube License.