How JustAnswer Works:
  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.
Ask Susan Athena Your Own Question
Susan Athena
Susan Athena, Professional w/Adv. Degree
Category: Homework
Satisfied Customers: 4332
Experience:  10+ yrs teaching & tutoring. AP essay grader. 2 masters degrees. English, IT, business.
12809769
Type Your Homework Question Here...
Susan Athena is online now
A new question is answered every 9 seconds

Start Access, and then open the Firm Pays database located

This answer was rated:

Start Access, and then open the Firm Pays 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 Firm Pays database that fulfills the following parameters:
• Displays the Amt Paid, Firm#, Date Paid, and Payment#
• Selects firm number 1119 and Date Paid 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 Firm Pays 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.
Hi. Thanks for your question.

You'll need to provide the database for me to assist you. You can post it to mediafire.com and put the sharing URL here.

Kind regards,
Susan
Customer: replied 5 years ago.
Hi Susan, I posted what you requested to mediafire and here is the link. If I did it wrong let me know. Thanks
http://www.mediafire.com/?qelb36bskvjh6nr
THIS ANSWER IS LOCKED!

You need to spend $3 to view this post. Add Funds to your account and buy credits.
Susan Athena and other Homework Specialists are ready to help you

Related Homework Questions