Query 1: Paintings by Picasso and Warhol (QUERY 1 Result pic) We want this query is to show the list of paintings that drawn by the two famous artists - Pablo Picasso and Andy Warhol and to provide some related information e.g. museum that borrowed the paintings. All of the fields selected would be shown on the query. In the criteria area of the field - artist we have inputted “Pablo Picasso” or “Andy Warhol”. By doing so, only the paintings either draw by Picasso or Warhol would be selected and shown in the query. The query is useful for the company since the two painters are famous, lots of museums want to borrow their paintings for exhibition use. By maintaining the list company can track the painting’s up to date location and provide better delivery service with shorter wait time. As a result, it helps to increase the service revenue of company. Query 2: Pre-1900 and NY Paintings (QUERY 2 Result pic) We want this query to show the list of paintings that created before 1900 and currently loan to museum located in New York. All of the fields selected would be shown on the query. The field - art id would be renamed and shown at the query as id. In the criteria area of the field – year we have inputted <1900. In the criteria area of the field - museum state we have inputted NY. Only data …show more content…
Thus, our group have created a parameter query. When the user run the query, a pop up window would show up to ask the user to enter the shipping ID. Based on user entry, the query would show the according information of the paintings. Having this query, the company can find out the record of each shipment easily. The records are very important since the paintings are valuable, small damage of the painting during shipment would bring huge losses to the