Project on Access 2013

profileNaathi_viih

I have 2 projects on access 2013

i need you create the query ans reports below.


Project 6


Create a query for the following

  1. How many primary factor Alcohol related tickets issued in the database.
  2. Which primary factor has the least tickets and how many tickets are there
  3. Which primary factor has the most tickets and how many tickets are there
  4. Create a new query that identifies how many tickets M and F have, in other words who has the most ticket Male or Female

Project 8 


 create the following

  1. a query and a report that shows how many rock songs are in the database
  2. a query and a report that shows the total for each genre category example jazz rock etc and the grand total of songs. The grand total can be on the report only for all. sort by greater to lowest 
  3. a query and report that shows how many songs released after 01/01/2002
  4. a query and report that shows who has the most recording labels total count for it.
  • 8 years ago
  • 35
Answer(1)

Purchase the answer to view it

blurred-text
NOT RATED
  • attachment
    Project6.accdb
  • attachment
    Project8.accdb