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

Ismg 2050 - Assignment ExampleFor instance, I selected all the fields from the three tables. Then, I went frontwards and put down California under the criteria section.As for the second call into question, 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 construct query menu. Then I went beforehand 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, utmost and minimum totals under the group by drop down menu.For the third query, I used the city and attribute crime data tables. I selected the create query that set up a query design process. I the n 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 coveted 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