Code for Accounting for sales of food tovarov.mdb

Affiliates: 1,59 $how to earn
Pay with:
i agree with "Terms for Customers"
Buy this item cheaper:
Sold: 14
Refunds: 1

Uploaded: 19.09.2014
Content: text (415 symbols)

Description

Code for Accounting for sales of food tovarov.mdb

Code for database "Accounting food sales" in MS Access.


Download the report on the database screen forms for free

http://access.avorut.ru/1/177_uchet_prodazh_prodovolstvennykh_tovarov.doc


Title: Accounting for sales of food tovarov.mdb


Link: http://access.avorut.ru/load/0-0-0-177-20

Additional information

Database "Accounting for sales of food products"
1.
Create tables:

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

2.
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.
3.
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.
4.
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.
5.
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.
6.
Create a request to update the records of Table 5 at the end of the month.

Feedback

0
No feedback yet.
Period
1 month 3 months 12 months
0 0 0
0 0 0
In order to counter copyright infringement and property rights, we ask you to immediately inform us at support@plati.market the fact of such violations and to provide us with reliable information confirming your copyrights or rights of ownership. Email must contain your contact information (name, phone number, etc.)