Input, process, output

requesting membership card.1. Members details are looked up: details will be displayed on screen or printed out if letter needs to be sent to customer who are overdue or need to be contacted for other reasons.DVD1. New DVD is brought: information for the new DVD is provided by the supplier and it will be added using a DVD entry form.2. An existing DVD's details change: This will be amended using the data entry form.3. Existing DVD is returned to supplier or sold: these DVDs are selected by using a query which picks out DVDs that haven't been rented out over a certain period. Information will be deleting by generating the existing data in the form and pressing the delete button which will also remove it from the existing DVD list.1. New DVD details need to be saved: After the new DVD is added the details will be checked and amended, then saved and added to current DVD list2. Changes to any existing DVDs need to be saved: changes will be amended and saved and details on current DVD list will be updated3. DVDs that have been returned to suppliers or sold need to be removed from the current DVD list1. DVD matching a members enquiries are looked up on screen: DVDs can be searched using queries that can locate movies using categories such as title, category, certificate and date released Rentals1. A DVD is rented: A new rental is generated using the rental form. The DVD, customer and length of rental is added. The DVD and customers are not entered manually but can be searched using a combo box. The length of the rental is entered and the due date is calculated automatically. Rentals are added to the rentals list. As the shop only has 1 of each DVD when a rental is made the same DVD cannot be rented again, preventing double renting.2. A DVD is returned: After the DVD has been returned and paid for it is marked as returned on the rental form and is now added back into the available DVD list1. New rental needs to be saved: rental is saved to the rental list and rented DVD is marked not available2. The rental is saved and marked as paid for. The DVD returned is now marked available and is returned to its case.1. Searching for rentals: an employee can now search for specific rentals and is aware if DVDs are available or not. This will be viewed on screen or can be printed.Query: searching for customers1. Search for customer query is added: customer information such as customer id or the members name is needed and is imported from the current customer list.1. Producing searched customer: the query matches the search criteria with the current customer list and generates of possible matches along all the customer details.1.view list: this list can now be printed or viewed on screen but a report will be automatically producedQuery: searching for inactive customers1. Search for inactive customer query is added: customer information is required and is sourced from the current customer table. A relationship is made between a customer and the number of rentals they have made over a certain period of time. 1. Producing inactive customer: The query will select the customers that have rented the least or no DVDs over the desired period of time.1. View list: a list will be produced of all the least active customer along with their contacts so an employee has the choice of contacting the member. The list is view in report form onscreen or can be printed outQuery: Search for least 25 rented DVDs1. Search for 25 least rented DVDs query is added: DVD information is needed along with rental information. A relation is made between the DVD and number of times the DVDs have been rented. 1. Producing 25 least rented DVDs: the query will select the least 25 rented DVDs over a certain period of time1. view list: this information is organised into a report which can be viewed onscreen or it can be printedQuery: Searching for DVDs due on a specific date1. Search for DVDs due on a specific date query is added: rental information is required. Rental details hold information on DVDs, customers and due dates, so a relationship doesn't need to be made.1. Producing DVDs rented on a specific date: the user needs to enter the date they are enquiring about. The query will then search and produce all the rentals that are due on that date along with customer and contact information1. View list: the list will be organised onto a report, containing information of the DVD, customer contact details and the due date. This information in turn can be printed or just view on screen