Ismg 2050 Assignment Example | Topics and Well Written Essays - 750 words

Ismg 2050 - Assignment Example For instance, I selected all the fields from the three tables. Then, I went ahead and put down California under the criteria section. As for the second query, I choose the VC data table as my preferred choice of data for my query. By following the same procedure as in query 1, I choose the query design from the create query menu. Then I went ahead and choose the violent robbery field from the table. I also choose the city table where I put down the states of Ohio and California on the criteria section. This enabled the query to only look for data in these two states only. Finally, I selected the totals from a design query, which allowed me to select which option I would like to compute. This included the sum, standard deviation, maximum and minimum totals under the group by drop down menu. For the third query, I used the city and property crime data tables. I selected the create query that set up a query design process. I then linked the two tables together and proceeded on selecting all the fields from the property crime table and the cities from the city data table. However, under the cities I put down the letters R and S for the criteria and or rows on the query. This then brought the desired results. Finally, in the fourth query I incorporated all the tables provided to come up with the results. First, I selected the design query from create menu and selected all the tables. I then proceeded in selecting all the required fields. In choose the city, the state, the property crime and violent crime