"Hi. I have loads of dvd's and i'm at uni and my housemates are always borrowing my films so one day i decided that i would make up a rental system database on access xp just to pass the time. however i soon discovered that i got an E in my Computing A Level for a reason. I am totally stumped on how to go about this task. I have set-up a table of my dvd's. a table for my housemates and a table for rentals. i then set-up queries for the different genres of films, a list of available and not-available films and also a quetry for customers. i then made a form but i cannot for the life of me remember how to get my database to work in the format of:
a housemate goes to a form to rent movies. they choose the films they want and these are sent to the rentals form. ther movies that have been rented then go into the 'not available' category. when the films are returned the films returned then go into the 'available' category. it should be simple enough to do but i just cant work it out. can anyone help?