Code for Settlements with customers for construction wo

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

Uploaded: 18.09.2014
Content: text (449 symbols)

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 access.avorut.ru/1/175_raschety_s_zakazchikami_za_rabotu_stroitelnykh.doc


Name: Payments to customers for construction work mehanizmov.mdb


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

Additional information

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

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

2.
Enter in Table 1 information about the 10 mechanisms proposed by the company, in Table 2 - data on six customers.
3.
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.
4.
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.
5.
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.

Feedback

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