I had a brief overview of Access in another class a couple of years ago. It was so brief, that I was of the opinion this was just another spreadsheet program that was a little more complicated to work with than excel. However, this project taught me the true value of a database and how I can use it on my job to make my life much easier. I work in HR and waste alot of time duplicating information in different spread sheets. I was very excited to find that in a database you can, for example, change an address in one place and it changes the address everywhere it is listed throughout the database.
Another way you could enhance this particular database project would be in the query section. You could sort by gender to find out if the facility was attracting more men or women, or the same way with family or individuals. You could also query the average length of time a member stayed with the club. With this type of information a business could change marketing tactics, or services offered to attract a certain set of individuals that weren't currently using their facility. Or find ways to keep members longer.
Although I found this to be an awesome tool, I have to agree with the posting of many other students. This section lacked alot in clarity. I basically completed the project, as well as the Access Scavenger Hunt through trial and error... lots of error.
No comments:
Post a Comment