1. INTRODUCTION:
JIM’s Electronic store is a small privately-run business owned by Mr Jimm Yahya. They specialise in sales of electronic like microwave, television, washing machine, laptop, play stations, refrigerators etc. The business is a subsidiary for only one product supplier Philips. They have managed to build a good customer base in Girne.
Profits are made by the means of sales of goods through local advertising and promotions. In spite of the customer based engaged by Jimm sales are still recorded manually and it is difficult to calculate business profit, stock re-ordering and customer documentation due to the limitation of paper/manual filling system. Due to the on-going expansion of the business of introducing more product makes like Samsung, Sony and LG, Mr Jimm Yahya has decided to invest on a comprehensive Recording and Stocking information system that will provide adequate stocking and prompt re-ordering process, customers on guarantee and also to keep track of business cash flows and profits. The Electronic Store information System is a system that contains and provides access to computerized records of products and sales of a store. The Information System includes the inputs and outputs that are generated as well as reports for the manager to make effective decision making. The system contains information of customers with guarantee offers, suppliers of different electronic s, invoices of purchased goods, and the stock of all items for sales. The electronic store serves the purpose of sales of various electronics such as TV, Play Stations, and Laptops etc which provides comfort to the consumer. As a business, the income of the store is dependent on people purchasing electronic products and how many products are sold thereby bringing about customer satisfaction. A database which is a structured collection of related data is produced using access 2003, this stores the records of