Car sales (counter. Work in MS Access 2003)
Replenishment date: 19.01.2008
Content: 80119124114493.rar (56.1 KB)
️Automatic issue of goods ✔️
️Automatic issue of goods ✔️
Sales:
1
Refunds:
0
Reviews:
0
Views:
689
Seller discounts
for all goods
for all goods
The goods are given a discount for regular customers.
If the total amount of purchases from a VSbest seller is more than:
If the total amount of purchases from a VSbest seller is more than:
the discount is: 3%
Description
To design a database “Car sales”.
Tables Cars, Buying a Car, Buyer.
Link the created tables.
Create queries in SQL language:
1. Show data on cars, the price of which is in the range of 100000 to 150000 rubles.
2. Calculate the total revenue from car sales.
3. Show data about buyers by Vamiliya Stepanov and Smirnov.
4. Create a form that displays data on car purchases made in 2003.
5. Create a report that would contain a list of buyers living in the Omsk region.
Tables Cars, Buying a Car, Buyer.
Link the created tables.
Create queries in SQL language:
1. Show data on cars, the price of which is in the range of 100000 to 150000 rubles.
2. Calculate the total revenue from car sales.
3. Show data about buyers by Vamiliya Stepanov and Smirnov.
4. Create a form that displays data on car purchases made in 2003.
5. Create a report that would contain a list of buyers living in the Omsk region.
Additional Information
Database in Microsoft Office Access 2003Database only. There is no description.