Home Work Help
$30-5000 USD
Betalt ved levering
My instructor is tough and 1 minor mistake can cost you 2 letter grades. I have completed this project and want an MS Access pro to do the same so I can compare mine to theirs for errors.
Start Access, and then open the FirmPays database located in the le4 folder of the LEFILES'ZIP File (Attached). Open the query named " June 2". View the query in SQL, and answer the following questions:
1.
2. Which tables are used in the query?
3. Which fields are displayed in the query results
4. What type of join is used between the tables
5. What selection criteria are used?
Then write a query in SQL in the FirmPays database that fulfills the following 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
Should be pretty simple.
## Deliverables
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2)
## Platform
Windows
Projekt ID: #3271630