I need some help with my homework that I'm running behind with; I've been working too much! I have an Access database that I've comleted, but I need someone to help me run some simple SQL queries on it.
## Deliverables
1)Create a query called Billing to allow San Diego to list the Lease and Boat information for each customer. The query should provide the information listed below (NOTE: Please see attached zip file for pictures of finished queries). 2)For all Equipment list the LeaseID, LeaseDate, LengthOf Lease, and if there is a customer assigned to Note: Not every lease will have a customer. Create a query name Lease_Report that uses an outer join to provide this data (NOTE: Please see attached zip file for pictures of finished queries). 3)Query: San Diego wants to know all the scheduled maintenance that was assigned to a boat. Order by BoatID (NOTE: Please see attached zip file for pictures of finished queries). 4)Query: For scheduling purposes San Diego want to list all employees that are scheduled to work on a Lease (NOTE: Please see attached zip file for pictures of finished queries). 5)Query: San Diego is finishing up the end of the year auditing so they want you to Create a Query that will list all of the BoatId, BoatYear, BoatSize, Color and LeaseID, LeaseDate, and LengthOfLease. Order by LeaseID (NOTE: Please see attached zip file for pictures of finished queries). 6)Report: San Diego wants to have a printout of the query produced in # 5 use the same fields to create a report. Sort by LeaseID. ------------------------------------------------------ 1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Complete ownership and distribution copyrights to all work purchased.
## Platform
Windows 9x, NT