Assignment: Microsoft Access
Create a query that shows the following information: you should have 8 queries and 2 tables in your access database.
• How many and which boats can seat more than 9 people
o Identify boat id, boat type
• How many and which boats can sleep more than 5 people
o Identify boat id boat type and ........
• Which boats are older than 15 years
o Identify fields to display
• How many provide the cheapest boat to rent per day?
o Identify boat id boat type and cost.
• How many provide the most expense boats to rent per day?
o Identify boat id boat type and cost
• Which is the biggest boat?
• Which is the smallest boat?
• Which is the oldest boat?
Format your assignment according to the following formatting requirements:
o The answer should be typed, using Times New Roman font (size 12), double spaced, with one-inch margins on all sides.
o The response also includes a cover page containing the title of the assignment, the student's name, the course title, and the date. The cover page is not included in the required page length.
o Also include a reference page. The Citations and references must follow APA format. The reference page is not included in the required page length.