Summons to the traffic police. Test
Replenishment date: 19.01.2008
Content: 80119124509150.rar (65.67 KB)
️Automatic issue of goods ✔️
️Automatic issue of goods ✔️
Sales:
0
Refunds:
0
Reviews:
0
Views:
222
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
Create a database "Cars". The database must contain tables:
- "Owner" with fields owner code, surname, name, patronymic, address, phone number.
The table must contain at least 5 records.
- "car" with fields owner code, car make, car number, color, year of manufacture, insurance. One person can own more than one car. The table must contain at least 8 records.
Fill the table with data.
Establish one-to-many relationships between tables.
Create a multi-tabular view form. Editing and data entry.
Using query:
- select information about cars of a certain brand. The brand is entered from the keyboard (query with a parameter). The resulting table must contain the following fields:
owner code, surname, address, car make, car number, color
Using the report:
- according to the request created in the previous task, prepare summons for car owners of a certain brand to appear in the traffic police (see sample)
Address: Novopolotsk, st. J. Kupala 18-3
Dear Ivan Ivanov!
You need to appear on 24.09.2007 at the traffic police in Novopolotsk (room number 12)
- "Owner" with fields owner code, surname, name, patronymic, address, phone number.
The table must contain at least 5 records.
- "car" with fields owner code, car make, car number, color, year of manufacture, insurance. One person can own more than one car. The table must contain at least 8 records.
Fill the table with data.
Establish one-to-many relationships between tables.
Create a multi-tabular view form. Editing and data entry.
Using query:
- select information about cars of a certain brand. The brand is entered from the keyboard (query with a parameter). The resulting table must contain the following fields:
owner code, surname, address, car make, car number, color
Using the report:
- according to the request created in the previous task, prepare summons for car owners of a certain brand to appear in the traffic police (see sample)
Address: Novopolotsk, st. J. Kupala 18-3
Dear Ivan Ivanov!
You need to appear on 24.09.2007 at the traffic police in Novopolotsk (room number 12)
Additional Information
Database in Microsoft Office Access 2003The base itself and a small description of the work done