This project was definitely the most challenging so far, since I have never before used Microsoft Access. It was so interesting to learn how to use this new application, especially because I can see how useful it will be to my future. The program can be used for large databases, helpful to any career, whether it is an order sheet, product list, clientele, or a way to keep track of your co-vendors. The hardest part for me was figuring out how to import the data correctly from an Excel file to the Access database. After many trials and errors, playing around with various advanced features, and using intermediary programs such as Notepad, I was able to import the data perfectly into my current Members database. Creating the query, form, and report were fairly easy, though still very interesting to learn how it all worked firsthand.
To increase the usefulness of this database, I would recommend collecting the home phone numbers of all current members and adding them to the table. I would also enhance the functionality of the database by adding a query sorting the remaining members by Joined Date, finding breaking points to create multiple queries, in order to retain the memebrs with different approaches. Since there are many formatting options available, it would probably help the functionality to add color coding, bolding, or darkened borders. I would take advantage of the filter tool, as well as the relationships function. By analyzing various relationships, the gym could see if there is a relationship between leaving/staying and location, age, or membership type, which would definitely help with recruitment and retention.
To increase the usefulness of this database, I would recommend collecting the home phone numbers of all current members and adding them to the table. I would also enhance the functionality of the database by adding a query sorting the remaining members by Joined Date, finding breaking points to create multiple queries, in order to retain the memebrs with different approaches. Since there are many formatting options available, it would probably help the functionality to add color coding, bolding, or darkened borders. I would take advantage of the filter tool, as well as the relationships function. By analyzing various relationships, the gym could see if there is a relationship between leaving/staying and location, age, or membership type, which would definitely help with recruitment and retention.
Here is a print screen of my Members Database:
No comments:
Post a Comment