Plan for Low-Cost Automated Inventory System Assignment

Plan for Low-Cost Automated Inventory System - Assignment theoretical accountIt includes 3 more sub formations.Manually, it is very difficult to keep such information accurate and updated in the stock registers and the business financially may become in loss when incorrect information of their head has been entered in these registers. So, it is very necessary to make their inventory and accounting system system computerized. For that purpose you create a database for your small business Cloth-Shop, which provide you such environment from which you can handle the process of inventory and accounting at the same time by investing nominal cost on it.Ms-Access, a database system is basically just a computerized record keeping system used to create such programs where proceedings are needed because it keeps the data in the form of tables on which a user can arrange variety of operations easily and quickly. Such asCreate 3 tables, one for customer information, piece for item informat ion, and third for stock availability. Required fields for evade 1 are Customer-id, Customer-name, Item-no, Date-Purchase, Item-Price, etc. For Table 2 are Item-no, Size, color, Quantity, date-received, company-no. etc. For Table 3 are Item- no., Item-sold, Item available