Ready-made Access database
Variant 9. The account of movement of details in a warehouse
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.
In order to counter copyright infringement and property rights, we ask you to immediately inform us at firstname.lastname@example.org 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.)