Project on Access 2013
I have 2 projects on access 2013
i need you create the query ans reports below.
Project 6
Create a query for the following
- How many primary factor Alcohol related tickets issued in the database.
- Which primary factor has the least tickets and how many tickets are there
- Which primary factor has the most tickets and how many tickets are there
- 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
- a query and a report that shows how many rock songs are in the database
- 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
- a query and report that shows how many songs released after 01/01/2002
- a query and report that shows who has the most recording labels total count for it.
8 years ago
35
Answer(1)![blurred-text]()
![]()
Purchase the answer to view it

NOT RATED
- Project6.accdb
- Project8.accdb
other Questions(10)
- book reivew
- "I used to be indecisive. Now I’m not so sure" Please respond to the following:
- SCI 151 The Science of Stars
- For the function g(x) = -2x^2 + 15x, what is the slope of the secant line from x = 1 to x = 7?
- MGT 437 WEEK 3 ORGANIZATIONAL STRUCTURES PAPER (A+++++ SOLUTION)
- 2hrs
- ARTS 100 Week 1 Individual Assignment Performing and Visual Arts Paper
- PROJ 586 Project Management Systems Week 2 Course Project Discussions and Quiz
- Decussion question4
- Report for a case