Acces interogari - Tapcov

Extras din document

Laboratory work Nr.6 (10hours) Theme: Queries in Access Select queries: 1. Select all clients from certain city; 2. Select all products made from “Viscose”; 3. Select all products suitable for Women; 4. Select all products of certain size (“XLL”); 5. Select all clients from certain city, certain street, which orders certain product (use the asterisk “*”); 6. Select all products that have been sold last two months; 7. Select all products special models; 8. Select all products suitable for Boys or Girls and ordered by women; 9. Select all products suitable for Boys or Girls and ordered by clients from certain city; Select all clients which put order of certain product