Code for Settlements with customers for construction wo

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

Uploaded: 18.09.2014
Content: text 449 symbols

Product description

Code for Settlements with customers for construction wo

Code for database "Settlements with customers for the work of building mechanisms" in MS Access.

Download the report on the database screen forms free

Name: Payments to customers for construction work mehanizmov.mdb


Additional information

Ready database Access "Calculations with customers for the work of construction mechanisms"

Create tables:

Table 1. Handbook of construction machinery

Structure of the table: Code of the mechanism, Name, Cost of one machine hour of work

Table 2. Customers

Table structure: Customer code, Organization name, Form of payment (cash / non-cash)

Table 3. Orders

Table structure: Order number, Order date, Customer code, Mechanism code, Amount of work in hours

Enter in Table 1 information about the 10 mechanisms proposed by the company, in Table 2 - data on six customers.
Create the "Order" form for entering data into table 3. Use the combo boxes to enter the codes of the mechanisms and codes of customers. Provide control over the input data (Order Date and Volume of work) and output messages when input errors occur. Enter the data for the five orders made by different customers. In one order, the operation of several mechanisms per customer can be included.
Create a form (main / subordinate type) only to view data by the specified mechanism, which must be selected from the list. The main form should contain information about the mechanism, and the subordinate must have a tabular form and contain data on customers, the volume and cost of work. The form should contain summary data on the scope and cost of the selected mechanism.
Create a report "Report on the use of mechanisms" on the basis of a cross-request, containing information on the amount of work performed by various mechanisms for each of the customers.


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.)