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.
