Topic: Access database of department of computer technics in shop
Data domain - department of computer technics in shop.
Solved tasks: output of convergence on the goods (the description, the price in rbl. and c.u., an amount in a warehouse, mark, etc.) and about their implementation (goods mark, the seller, sale date).
Requests: Streamlining on fields: type of the goods and an amount in a warehouse; type of the goods and the price.
Search: characteristics of the computer of mark ; sales of seller in day .
Sampling: printers at the price of no more Y; the goods which in a warehouse remains less than 5 pieces.
Calculations: an amount of sales for January; the total of sales of seller .
Correction: removal of convergence on sales for last year; change of the price in roubles in connection with a rouble course change;
The tabular report: the information on the goods; grouping on types (separately - printers, computers, monitors, etc.).
Here that at me it turned out:
- Request on the goods <5 pieces
- Request on type and the price
- Request on type and an amount
And remaining it is impossible... Help simply on an example (probably you have a similar basis or video as it becomes)...
The basis attached. (On . Language)
I will be grateful!