Microsoft access | Computer Science homework help

I need help to add some  queries to finish my project 

 

Part 2

Create a query that shows the following information: you should have 8 queries and 2 tables in your access database. 

8 queries needed

  1. How many and which boats can seat more than 9 people
    1. Identify boat id, boat type
  2. How many and which boats can sleep more than 5 people
    1. Identify boat id boat type and ……..
  3. Which boats are older than 15 years
    1. Identify fields to display
  4. How many provide the cheapest boat to rent per day
    1. Identify boat id boat type and cost
  5. how many provide the most expense boats to rent per day
    1. Identify boat id boat type and cost
  6. Which is the biggest boat?
  7. Which is the smallest boat?
  8. Which is the oldest boat?

Need your ASSIGNMENT done? Use our paper writing service to score better and meet your deadline.


Click Here to Make an Order Click Here to Hire a Writer