[meteor_slideshow slideshow=”arp1″]
Start Access, and then open the FirmPays database located here. Open the query named “Large Payments.” View the query in SQL Format, and answer the following questions:
Which tables are used in the query?
Which fields are displayed in the query results?
What type of join, if any, is used between the tables?
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 1119 and DatePaid between 6-1 and 6-10
Orders results by payment date
Assignment Guidelines:
Start Microsoft Access and open the FirmPays.mdb database.
Open the query called “Large Payments.”
View the query in SQL Format, and in a Word document, answer the 4 questions outlined in the assignment description.
Create a new query in the FirmPays database, and write the SQL so that it fulfills the parameters listed in the assignment description.
Save a copy of the Access file named U4A1LastName.accdb.
Your submitted assignment (125 points) must include the following contained in a .zip file:
A Word document with your answers to the questions in the assignment description.
A copy of your Access .accdb file that adheres to the assignment guidelines.
[meteor_slideshow slideshow=”arp2″]
A-Research-Paper.com is committed to deliver a custom paper/essay which is 100% original and deliver it within the deadline. Place your custom order with us and experience the different; You are guaranteed; value for your money and a premium paper which meets your expectations, 24/7 customer support and communication with your writer. Order Now
Use the order calculator below and get started! Contact our live support team for any assistance or inquiry.
[order_calculator]