6579

Create a query named q1 deriving data from the Customers and Rents tables. The query will export the following fields in the following order: CSurname, CName and Date1. Sort the three fields in ascending order. Then apply a criterion to the Date field to retrieve the records of a date greater than or equal to 8/1/2004

6580

Delete all criteria of the current query. Save and close the query.

6581

Insert the appropriate criteria in the current query so that it returns only the customers whose PC begins with 54. Save and close the query.

6582

In the current query insert the PC field after the Address field. Save and close the query.

6583

Delete the AllCustomers query

6584

Modify the current query so that it displays the CName and PC fields only for the customers whose PC begins with 54. Save and close the query.

6585

Create a new query based on the Products table that will display the Description and Price fields only (in the above order). Save the query as q1 and close it.

6586

Create a new query based on the Products table that will display the ID and Description fields only (following this order). Sort the Description field in ascending order. Apply a criterion to the Price field which will return records displaying values equal or lower than 10. Save the query as q1 and close it.

6587

Create a new query that will use the Description and Price fields from the Products table and the FilePath field of the ProductsPhoto table. Apply a criterion to the FilePath field to retrieve all records containing a photo. Make sure that when the query is executed the Description and Price fields only (following this order) are displayed. Save the query as q1 and close it.

6588

Modify the PhotosJPG query to retrieve all gif photographs instead of jpg photographs. Save and close the query.

6589

Modify the PhotosJPG query to retrieve all gif photographs instead of jpg photographs. Save the query as PhotosGIF. Close the query.

6590

Insert the Price field after the Description field in the PhotoSizeWithPath query. Change the criteria so that the TotalPixels field displays values up to 1000. Save and close the query.

6591

In the SizePhotoWithPath query change the place of the FilePath field so that it is displayed first. Apply sorting by Description in descending order. Save and run the query.

6592

Modify the design of the CustomersKrini query to display the Area field when the query runs. Then run the query.

6593

Modify the design of the PhotoSize query so that when the query is executed, the TotalPixels field is not displayed. Then run the query.

6594

Create a new query based on the Products table that will display the ID, Description and Price fields (in the above order) as well as all records containing Price values ranging between 1000 and 2000 (use Between). Save the query as pricelevel2 and close it.

6595

Create a new query in design view based on the Orders table that will display all fields and records displaying 3 or 5 as CustomerID. Save the query as customers35 and close it.

6596

Insert the appropriate criterion in the Payment query to display customers who pay by cheque only. Save and close the query.

6633

Create a new query named myprice that will display the average of the product prices displayed in the Products table. Use avgprice as name for the calculated field.

6634

Create a new query named Ord30 that will display the Description field of the Products table, where the value of the Quantity field of the Orders table records is set to 30.

6635

Create a new query that will display all fields from the Products table and any records where the Description field value contains the phrase MATRIX Y AUTO

The Y character may be any character. Make sure there is an empty space before and after the Y character. Use the like operator. Save the query.

6637

Modify the Orders20 query to retrieve only the products of a price lower than or equal to 50 euros that have been ordered on 01/30/2004. Save the query.