The developed program is essential for maintaining a database of food products in the store. As a database accounting software product used goods Access, and data access technology ADO.
For storage use three tables. Two tables are accounting software manuals: "Categories" and "Units" for a table with headings.
For headings, you can specify the following information:
- Category (Taken from the directory "Categories";
- Product Name;
- Wholesale price;
- Extra charge for the goods (the default is the value specified in the category of goods);
- Number of product;
- Unit (Gr., KG., Pcs., Etc., is taken from the table "Units");
- Photos to product size 300h220.
Pointing out the wholesale price of the product, and mark quantity calculated retail price and the amount of produced goods. Also, when changing the margins in the "Categories" are automatically converted retail prices and amounts in the existing headings.
You can search by product name, unit of measure, the number of goods for an extra charge, in wholesale and retail prices, as well as the amount.
If necessary, you can be sorted by any field in ascending order or descending.
Products found in the program of the treatment of products can be printed using the double-click on the desired product or "Print the selected items" in the "Print" button.
No feedback yet