2021

Create a query named q1 to derive data from the Customers and Rents tables. The query will export the following fields in the following order: Surname, FirstName and RentDate. Sort the three fields in ascending order. Then apply a criterion to the RentDate field to retrieve the records of a date greater than or equal to 01/08/2004.

2022

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

2023

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.

2024

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

2037

Delete the All the customers query.

2054

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

2097

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.

2098

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

2099

Create a new query that will use the Description and Price fields from the Products table and the FileRoot field of the ProductsPhoto table. Apply a criterion to the FileRoot field to retrieve all records which contain 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.

2100

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

2101

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

2102

Insert the Price field after the Description field in the PhotoSizeWithRoot query. Change the criteria so that the value of the TotalPixels field is less than or equal to 1000. Save and close the query.

2103

Locate the PhotoSizeWithRoot query and change the place of the FileRoot field so that it is displayed first. Apply sorting by TotalofPixels in descending order. Save and run the query.

2123

Modify the design of the CenterCustomers query to display the Area field when the query runs. Save and run the query.

2124

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

2128

Create a new query named sumquantity to retrieve the sum of the quantity field of the Orders table. Use sum1 as name for the calculated field.

2129

Create a new query named all_products to retrieve the total number of records of the Products table. Use total as name for the calculated field.

2130

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.

2132

Create a new query based on the Products table that will display the Code, Description and Price fields (in the above order) and only the records which contain Price values from 1000 to 2000 (hint: Use between). Save the query as pricelevel2 and close it.

2133

Create a new query in design view based on the Orders table that will display all fields and records where the value of the CustomersCode field is 3 or 5. Save the query as customers35 and close it.

2135

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

2162

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.

2842

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

2845

Create a new query named Ord50 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.