Wow! After struggling with this project, I am done and satisfied. I knew this was going to be a struggle for me, but now I can say I do have a simple understanding of Access. I learned how to make a table with all the different field labels and data types. Then I imported data and compiled it all into the Members table. Importing the data, surprisingly enough, is what took me the longest. I thought it had to be opened up as an excel file; however, after about and hour of struggling, I finally realized that it needed to be opened as a text file. The rest was pretty straightforward after watching the lectures I was able to walk through the query, the form, and the report pretty well. Hopefully sometime in the near future I can put this skill to practical use!
To enhance the functionality of this database, I would make it so that there would be drop down options for filling in some of the form. That would directly show what the person was supposed to fill in. It would also be great to have another table linked to the Members table. It would be a table about the people who had ended their membership with more detail. A form could then be made from there and the members could fill it out to possibly shed light as to why they were leaving. The possibilities are probably endless on how to make this database even better.
No comments:
Post a Comment