Help Please! You Will Need To Let Me Know How To Share The F

Help Pleaseyou Will Need To Let Me Know How To Share the File That

Start Microsoft Access, open the FirmPays.mdb database, and locate the query named "Large Payments." View the query in SQL Format. Determine and document the following: which tables are used in the query; which fields are displayed in the results; what type of join, if any, is used between the tables; and what selection criteria are applied.

Next, create a new query within the same database that displays the AmtPaid, Firm#, DatePaid, and Payment# fields. The query should filter for firm number 1119 and DatePaid values between June 1 and June 10. The results should be ordered by the DatePaid field. Save the modified database as U4A1LastName.accdb.

Paper For Above instruction

This assignment involves analyzing an existing database query and creating a new one to meet specific criteria within Microsoft Access. The initial step requires reviewing the existing "Large Payments" query in the FirmPays.mdb database. The student must identify the tables involved, which fields are displayed in the output, the type of join used between the tables, and any filtering criteria applied. This analytical task helps to understand how the data is being retrieved and the query structure used within the database.

Subsequently, the task is to develop a new SQL query that fulfills particular requirements. The new query must extract the fields AmtPaid, Firm#, DatePaid, and Payment#, for a specific firm (number 1119), and restrict results to payments made between June 1 and June 10. The results should be ordered chronologically by the DatePaid field. This step tests the ability to write and execute SQL commands within Access, applying filters, selecting specific fields, and controlling the order of output.

Finally, the modified database should be saved under a new name, U4A1LastName.accdb, ensuring the original database remains intact. This process demonstrates proficiency in database management, query design, and application of filtering and ordering in SQL within Microsoft Access, skills essential for effective database analysis and reporting.

References

  • Baesens, B. (2014). Data Science in Action. MATLAB Central. https://www.mathworks.com/company/newsroom/lessons/intro-to-data-science.html
  • Harrington, J. L. (2016). Relational Database Design and Implementation. Morgan Kaufmann.
  • Hipp, D. R. (2018). Database Systems: Design, Implementation, & Management. Cengage Learning.
  • Rob, P., & Coronel, C. (2007). Database Systems: Design, Implementation, & Management. Cengage Learning.
  • Simons, A. (2020). SQL in a Nutshell: A Desktop Quick Reference. O'Reilly Media.
  • Sharma, R. (2021). Practical SQL: A Beginner's Guide to Querying Data. O'Reilly Media.
  • Valacich, J., & Loewenstein, Y. (2014). Modern Database Management. Pearson.
  • Witten, I. H., Frank, E., & Hall, M. A. (2011). Data Mining: Practical Machine Learning Tools and Techniques. Morgan Kaufmann.
  • Zucker, R., & Sundermeyer, K. (2015). Learning SQL. O'Reilly Media.

Related Assignments