for the base code data including parts movement of stoc

Ready-made Access database
Variant 9. The account of movement of details in a warehouse
1.
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

2.
Enter in Table 1 information about 10 parts. Fields remainder and the date of the last movement is not filled.
3.
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.
4.
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.
5.
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.
6.
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.