Please use Microsoft Access to answer the following queries from the attached:
1) How many "alarm" calls did the agency have in2004?
2) How many "gas/convenience" store robberies ("robbery") did the agency have in 2004? Do you see in patterns? (Hint: include the "notes" field) Elaborate.
3) Look at "commercial break" incidents that occurred at jewelry stores. In what month and year did most occur? Do you see any patterns here? Elaborate
4) Perform a query on your "people" table. How many white females are in the database? Sort in ascending order by date of birth--what town is the oldest from?
5) Now combine person and incident information into the same query (hint: it involves three tables). How many white males have been arrested for shoplifting?
6)Finally, run an aggregation query on the data to tell: what are the top three locations for noise complaints in 2004, and how many did each location have?
I have attached the files that are associated with the queries. If the correct file did not upload, please let me know, thanks