LOL!! The video store database is a very common assignment... there are many threads on it... You will find some good info herehttp://www.utteraccess.com/forums/showflat...p;Number=684993
I'll start you off... the most important thing when designing a database is to make sure that it starts off and remains normalised... this means getting the structure right...
I would suggest that your Structure should be something like...Tbl_MediaType
MediaTypeID (PK - Autonumber)
MediaType (i.e. VHS Video, DVD, Computer Game etc...)Tbl_Media
MediaID (PK - Autonumber)
PersonID (PK - Autonumber)
PersonTitle (mr, Mrs etc...)
AddressID (PK - Autonumber)
CommunicationsTypeID (PK - Autonumber)
CommunicationsType (i.e. telephone, mobile, e-mail etc...)Tbl_PersonCommunication
PersonCommunicationID (PK - Autonumber)
EmployeeID (PK - Autonumber)
RentalSessionID (PK - Autonumber)
RentalItemID (PK - Autonumber)
That should get you started.