DB Transport .mdb

Affiliates: 0,08 $how to earn
Pay with:
i agree with "Terms for Customers"
Buy this item cheaper:
Sold: 6 (last one 22 days ago)
Refunds: 0

Uploaded: 09.03.2016
Content: Грузовые перевозки 2003.rar (362,27 kB)

Description

DB Transport .mdb DB Transport .mdb

Transport database .mdb
Download the report on the database screen forms for free http://access.avorut.ru/1/gruzovye/223_otchjot_dlja_gruzovye_perevozki.docx

Note: If the yellow Message Bar appears when you open a file, you must click on "Enable Content" button.

Additional information

Ready database access «Freight transport»

Freight transportation
The company carries out transportation on various routes. For each route a certain name is defined, an approximate distance is specified and some payment for the driver is established. Information about the drivers includes the surname, name, patronymic and seniority. To carry out the calculations, it is necessary to store the data on the transportation (route, driver, date of dispatch and arrival). On the fact of some transportations to drivers the premium is paid.
A possible set of entities
Routes (Route code, Name, Range, Number of days in transit,
Payment).
Drivers (driver´s code, surname, first name, patronymic, seniority).
Work done (Route code, Driver code, Date of dispatch, Date of return, Award).
The company decided to introduce a new payment system, now the payment to drivers should depend not only on the route, but also on the length of service, it should be borne in mind that the transportation can be carried out by two drivers.

2.3.15. Freight transportation
Description of the subject area
You work in a company engaged in the transport of goods. Your task is to track the cost of transportation, taking into account the wages of drivers. Your company carries out transportation on different routes. For each route you have defined some name, calculated the approximate distance and set some payment for the driver. Information about the drivers includes the surname, name, patronymic and seniority. For the calculation, you keep full information about the transportation (route, driver, date of departure and arrival). On the fact of some transportations to drivers the premium is paid.
Tables
Routes (Route code, Name, Range, Number of days in transit, Payment).
Drivers (driver´s code, surname, first name, patronymic, seniority).
Work done (Route code, Driver code, Date of dispatch, Date of return, Award).
 The development of the formulation of the problem Now the situation has changed. Your company decided to introduce a flexible payment system. So, payment drivers should now depend not only on the route, but also on the length of the driver´s experience. In addition, you need to consider that the transportation can carry two drivers. Add changes to the table structure that take into account these facts, and modify existing queries. Add new queries.
Task for creating a database in a Microsoft Access environment
The order of the work:
• Selection of the subject area in accordance with the student´s serial number in the journal;
• Analysis of the textual description of the subject area;
• Selection of table structures and their creation;
• Filling in the data in the tables;
• Development of user interface. Creating forms;
• Creation of calculated queries;
• Creating output reports.

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