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 ahead and put follow out California under the criteria section.As for the atomic number 42 examination, I remove the VC data table as my preferred choice of data for my interrogation. By future(a) the same procedure as in query 1, I choose the query design from the piss query menu. Then I went ahead and choose the violent robbery field from the table. I besides choose the city table where I put down the states of Ohio and California on the criteria section. This enabled the query to exclusively 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 desig n process. I then linked the two tables in concert 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