I learned a little more about databases this semester with this assignment. I did something similar to this about 2 years ago in my ISM course at Palm Beach State. We did the basics when it comes to Query's and forms and reports. I know I am going to lose points because of lack of understanding when it came to the query and where it said "membership types who have left the gym within the last six months (six months prior to the database project due date)" From what I understand our database project is due April 1st 2012, and six months prior to that date is October 1st 2011. Well the excel spread sheet that was called for on this assingment has the most recent date for someone to leave the gym as 8/5/2011 so I ended up just putting all the members who left. Wouldn't I have a blank database? Or query.
I hope it isn't too many points... :( I did note in my week 10 blog post about microsoft access that I am sure there is a lot more to it then what we are diving into. I could only imagine what the access book is like because the Excel book is over 1000 pages. I have not a clue on how I could enhance the functionality of this database... I know I am still kind of lost when it comes to Microsoft Access but I will keep messing with it until I get it figured out like with most things that I do. Practice makes perfect and this is a great tool especially in the business world. I use it every day at work, just to input data, I by no means create these things.
No comments:
Post a Comment