Cal's Blog

Friday, August 04, 2006

First Access Assignment

Answers to Problems.

#1: Yes, there is enough data.
#2: Yes, there is enough data.
#3: No, there is not enough data, you would need to add the publisher to the table.
#4: Yes, there is enough data only if the edition refers to the year published. If the edition refers to just that, then there is not enough data.
#5: You would need the Qty. on Hand, the Reorder Point, and the Product Name and/or Number in your table.
#6: You would need the Item and Price in your table.
#7: You would need the Item, Selling Price, and Cost in the table.
#8: You would need the Customer Name, the car make/model, Value of the car, and the Customer Rating.
#9: I would probably want their Name, Relationship, Date of Birth, Date of Death (if applicable), Place of Birth, Anniversary Date, Spouse Name, Chidren's Name(s).

Microsoft Access Tutorials

I found this site about Microsoft Access. I like it because it isn't too complicated. I found many of the other tutorial sites I visited were too intense and even though they all basically taught you how to create a database, this one got right to the point.

http://www.courses.psu.edu/infsy/infsy540_gjy1/access_tutorial_2000.html