
The Microsoft Access project was pretty new to me. I learned that Access is a very ueful tool, especially from a business standpoint. I like the way that you can compile records and data to show only the information that is useful for what you need. For example, if you had to create a report for a monthly meeting, you could put together a report with only the information needed without going through all your records and pulling out the information individually. These tools can save time.
One way that I could enhance the functionality of this database is by adding a calculated field to the footer in my report. I could have at the bottom of my report a calculation of say the number of members who have left within the past 6 months "and" have less than one year as a member. This number could be helpful in quarterly meetings to show retention of new members. Quarterly goals could be set at a number or percentage to work for. This could show how new classes, gym hours, or other areas are affecting retention of new members.

No comments:
Post a Comment