Database Car Rental (2) .mdb

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

Uploaded: 13.06.2016
Content: Прокат автомобилей 2003.rar (111,53 kB)

Description

Database Car Rental (2) .mdb Database Car Rental (2) .mdb

Database Car Rental (2) .mdb

Download the report on the database screen forms for free http://access.avorut.ru/1/245_prokat_avto/245_otchjot_bd_prokat_avtomobilej.doc

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

Additional information

Task for the database in access 2003 "Car Rental"

Car rental
Description of the subject area
You are the head of a commercial service in a car rental company. Your task is to monitor the financial performance of the rental office. In your fleet includes a number of cars of different brands, values ​​and types. Each car has its own rental price. Customers are turning to the rental point. All clients undergo mandatory registration, in which they collect standard information (name, surname, patronymic, address, telephone number). Each client can contact the rental office several times. All customer requests are recorded, with each transaction remembering the issue date and the expected date of return.
Tables
Cars (Vehicle code, Brand, Price, Rental price, Type).
Clients (Customer code, Last name, First name, Middle name, Address, Telephone).
Issued vehicles (Vehicle code, Customer code, Issue date, Return date).
The development of the formulation of the problem
Now the situation has changed. A simple analysis showed that the cost of renting a car should depend not only on the car itself, but also on the period of its hire, as well as on the year of manufacture. Also need to introduce a system of penalties for the return of the car in an inappropriate form and a system of discounts for regular customers. Add changes to the table structure that take into account these facts, and modify existing queries. Add new queries.
Car rental
You are the head of the commercial service in the firm engaged in renting cars. Your task is to monitor the financial performance of the rental office.
In your fleet includes a number of cars of different brands, values ​​and types. Each car has its own price. The cost of car rental depends not only on the car itself, but on the year of production. The database contains data on cars: State number, Mark, Model, Year of manufacture, Vehicle price, Daily rental price.
Customers are turning to the rental point. All clients undergo obligatory registration, in which standard information is collected about them (Surname, Name, Patronymic, Address, Telephone). Each client can turn to the rental office several times.
In the vehicle fleet a system of discounts (Name of discount, Percent of rental amount) for regular customers and a system of penalties (Naimenovanie fine, Amount of penalty) for the return of the car in an unsuccessful form.
All customer requests are recorded in the database, with each issue of the vehicle memorized: Date of issue, Number of days, Expected return date, Rental amount [Rental amount = Rental fee per day * Number of days], Discount amount, Amount of penalty, Final amount of money. In one issue, one car, one customer, one discount and maybe several types of fines are involved.
Subject areas for independent work
Stages of individual self-employment:
1. Create a table structure by means of MS Access;
2. Create a data schema;
3. Develop screen forms for entering and viewing information;
4. Fill in the tables (10-15 records);
5. Develop and execute various types of queries to the database:
• for sample;
• using logical operations in the selection condition;
• with the parameter;
• cross request;
• for updating;
• to add;
• to delete;
• with calculated fields (if this is possible for your predefined area).
6. Develop various types of reports for printing data;
7. Organize work through a button form or headband. The database should look like a complete software product.
18. Car Rental
Description of the subject area
You are the head of a commercial service in a car rental company. Your task is to monitor the financial performance of the rental office. The fleet includes ...

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