for the base code data including parts movement of stoc

Affiliates: 0,1 $how to earn
Pay with:
i agree with "Terms for Customers"
Buy this item cheaper:
Sold: 30 last one 05.06.2020
Refunds: 0

Uploaded: 04.05.2014
Content: text 392 symbols

Product description

for the base code data including parts movement of stoc

The code for the database, "Accounting for the movement of parts in stock" in MS Access.

Download the report on the database screen forms free

Name: Allowance for movement of parts on sklade.mdb


Additional information

Ready-made Access database
Variant 9. The account of movement of details in a warehouse
Create tables:

Table 1. Movement

Table structure: Part number, Part name, Balance, Date of last movement

Table 2. Consignment note for receipt

Table structure: Invoice number, Part number, Received quantity, Date of arrival

Table 3. Requirement for issuance

Table structure: Number of requirements, Part number, Number issued, Issue date

Enter in Table 1 information about 10 parts. Fields remainder and the date of the last movement is not filled.
Create a form "Accounting for warehouse receipts" to enter data in Table 2, providing for the control of the imported data (the number and date of arrival) and the issuance of messages when input errors occur. The part code is selected from the list box containing the part name. After you enter the data into the form, you must update the Last Move Date and Balance fields in Table 1. Enter the details of the receipt of several parts within three days.
Create the form "Stock accounting from the warehouse" to enter the data in Table 3. Enter the part code using the combo box containing the names and part codes. After entering the data, provide an update of the Last traffic date and Balance fields in Table 1. Enter the details of the issuance of several parts within three days.
Create the "Stock record card" form (main / subordinate type) only for viewing details of the movement of the part. The part code must be selected from the list box containing the part code and name. The main form should contain the data from Table 1. The subordinate form should contain the following columns: Date, Quantity Received, Number Issued.
Create a report "Information on the receipt and issue of details" for the period of time, the beginning and end dates of the period should be entered when the report is opened. The report should contain information about the dates, the amounts of receipts and the issuance of all the details for the specified period.


No feedback yet.
In order to counter copyright infringement and property rights, we ask you to immediately inform us at 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.)