Ready database access "Store Supply"
Develop an information subsystem "Store Supply" for the wholesale base. At each time there should be accurate data on the name of the goods, their quantity in the warehouse of the base, the name of the stores of receipts of the goods, the name and quantity of each type of goods in each store, and the requests of stores for this year. Pay attention to the fact that the quantity of goods is measured in different units (pieces, liters, kilograms, etc.). The following operations are required: to include the new goods in the list of goods in the warehouse, to correct or delete the unnecessary goods from the warehouse list, to include the new store in the list of stores, to correct or delete the unnecessary store from the list, to fulfill receipt of some goods to the warehouse, to view the information about the goods in the warehouse , view information about the goods on the shops, make an inventory of the warehouse and each store, give the store the goods from the warehouse and print the invoice, enter the store´s application for the current year. Develop: application menu and dialog tools, input and modification forms, queries (if needed), reports for printing.