Database Project - Microsoft Access

   

I learned many things in this project. The first thing I learned was that there is a program that can take your database data to the next level of usage. After learning pivot tables in Excel, I couldn't imagine there would be even more that one could do with their data. Microsoft Access enhances databases and makes their information easy to manage. I learned how to import my database and then I learned how to narrow down the information within that database. I also learned how to create a form for new members. I can see the usefulness of  this function for the business that I hope to own someday. The report function also proved to be a benefit for a business. I thought of mailing short surveys (perhaps printed on postcards for easy return) to the members that left to find out why they left. Categorizing these members shows the owner or manager all sorts of information they can utilize to either regain these members or improve their systems for future members' loyalty.

Microsoft Access has so much functionality. I truly enjoyed exploring a variety of the functions access offers. One function I would like to add is the ability to change the format of the cells imported from external data. I wonder if it is not available as an option for some reason like that it would change the continuity of the database and the database manager. Another function I would like access to provide would be to have a group header on the second sheet of a report. At this point, I was unable to carry the group header to the second sheet so when the data carried over to another page there was only a continuation of the list from the previous page. It would be nice if the group heading was able to head the carryover page or pages.