Database "Accounting for sales of food products"
Table 1: Product Groups Reference
Table structure: Group code, Group name
Table 2. Price list
Table structure: Item code, Product name, Group code, Unit. measurements, Price
Table 3: Invoices
Table structure: Invoice number, Item code, Quantity received, Date of receipt
Table 4. Sales
Table structure: Check number, Item code, Number sold, Sale date
Table 5. Balance
Table structure: Item code, Balance, Residual value
Enter in Table 1 information about the three groups of food products, in Table 2 - information about 15 products included in the three groups, in Table 5 - information about the balances at the beginning of the month of all goods. When you enter the product code in Table 5, use the combo box.
Create the "Goods Receipt" form to enter the data in Table 3 on the receipt of goods for the month. One consignment note can receive several goods. The invoice number and the date of receipt should be placed in the form header. Information about each product is entered in the rows of the table, placed under the heading. To enter the product code, use the combo box. Enter the data on the receipt of 15 goods on five consignment notes.
Create a form "Sale of goods" to enter the data in Table 4 on the sale of goods for the month. One item can be sold several goods. Check number and date of sale place in the form header. Information about each product is entered in the rows of the table, placed under the heading. To enter the product code, use the combo box. At the time of input, the quantity is sold to check for the actual availability of the goods, in the absence of the required quantity, provide for the output of the message. Enter data on the sale of 10 goods on five checks.
Create a report on the receipt-sale of goods for the month. The report should contain a table of goods in a breakdown of the groups, indicating the balance and value of the balance at the beginning of the month, the quantity and value of goods received and sold, the balance and value of the balance at the end of the month, and the results by groups and total.
Create a request to update the records of Table 5 at the end of the month.