Enter in Table 1 information on 15 types of work for the three brands of cars, in Table 2 - information on the five performers.
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.
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.
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.
Create a report on the basis of a cross-request for the cost of performing work on the car brands and work executors.
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.)