The code for the Formation of invoices for payment Car

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

Uploaded: 04.05.2014
Content: text 411 symbols

Description

The code for the Formation of invoices for payment Car

Code database "Formation of invoices for payment Car service" in MS Access.

Download the report on the database screen forms free http://access.avorut.ru/080413/162_otchjot_formirovanie.doc

Title: Formation of invoices for payment in avtoservise.mdb

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

Additional information

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.

Feedback

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