Below are screen shots from a very simple application created for a DVD / Video shop using Microsoft Access. 

This was created on a very tight budget. The staff at the video shop had no previous IT experience and say they find it very usable. The application is based around two main forms: one accepts input, displays films and allows searches for Films; the other does the same for People mainly Customers. Both forms have a bottom section that accepts input and displays hires pertaining to the film or customer currently visible in the top half.

There are two parts to the Films Form below. The top part is all about the film, in this case it is "Hotel Rwanda", it's a DVD, you can see all the other film details in blue.
The bottom part is the list of hires of this film. So far there have been 11 hires of this film. When someone wants to hire it again the shop assistant simply adds a new hire row and enters the customer number, all other fields will self populate with default values. See steps 1 to 4 in red.
So to enter a new hire, that is: one click on  the new record button (no 1 in red),   type in the customer number,  press "tab", "tab" then the "Enter" key. .......Simple as that!



Below is the Person form which is mostly used for customers but also for staff and distributors hence the field person type. This form functions in much the same way as the films form. the top part displays customers (you can scroll through them). The bottom half is for the entry of hires and lists the hires against the customer currently visible in the top half.