The code for the Formation of invoices for payment Car

Ready database access Formation of invoices for payment in a car workshop
Option 10. Forming invoices for payment in a car workshop
1.
Create tables:

Table 1. Reference works types

Table structure: Job code, Vehicle brand, Job description, Cost of work

Table 2. Directory of work executors

Table structure: Artist´s code, Surname I.O.

Table 3. Orders

Table structure: Date, Order number, Customer, Vehicle brand, Job code, Executor´s code

2.
Enter in Table 1 information on 15 types of work for the three brands of cars, in Table 2 - information on the five performers.
3.
Create the "Order" form to enter the data in Table 3. Use the combo boxes to enter the work code and job codes. Enter data on five orders for different dates for three customers. Each order must contain at least three works.
4.
Create a form (main / subordinate type) only to view information about orders executed by a particular performer whose code should be selected from the list. The main form must contain the executor´s code and his surname. The subordinate form should contain in the tabular form a list of works with indication of their name, car brand, customer and cost of work. In the form, the total value of all works performed by the executor should be calculated.
5.
Create a report "Invoice for payment of orders". The order number must be selected from the list. In order to display the date, order number, information about the car brand, the name of the customer and the cost of performing each job and the whole order.
6.
Create a report on the basis of a cross-request for the cost of performing work on the car brands and work executors.