Code for Settlements with customers for construction wo

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.