SSB Home Page\Why use MS Access to create a business system\examples of forms created for a video shop

Small Systems for Business Specialising in providing user friendly MS Access systems for small businesses and organisations at very reasonable prices.

Below are screen shots from a very simple application we created for a DVD / Video shop using Microsoft Access.  Incidentally this example application is available for sale and can be altered to suit your needs.           This was created on a very tight budget. The staff at the video shop had no previous IT experience and have said they find it very user-friendly. 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 of 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.