This is not a difficult assignment it is simply classwork I will not have time to [login to view URL] is important that all of the questions are answered completely however.
Using Access, and then open the FirmPays database located in the attached le4 folder of the Ebony zip file. Open the query named " June 2". View the query in SQL, and answer the following questions in a word document:
1. Which tables are used in the query?
2. Which fields are displayed in the query results
3. What type of join is used between the tables
4. What selection criteria are used?
Then write a query in SQL in the FirmPays database that fulfills the following parameters, it is very important that there is no deviation from these parameters:
Displays the AmtPaid, Firm#, DatePaid, and Payment#
* Selects firm number 1115 and DatePaid between 6-1 and 6-10
* Results should be ordered by payment date
## Deliverables
This needs to be completed and saved as one file, answers for the questions must be done in word, or office.
SQL Statement should be done in Access.
## Platform
Platform for the SQL statement is Microsoft Access.