Grader - Instructions Access 2019 Project Exp19_Access_Ch01

Grader - Instructions Access 2019 Project Exp19_Access_Ch01_CapAssessment

In this project, you will open a database containing the inventory of a coffee shop, create a new table in which to store sales representatives (reps) information, and then add the sales rep records. You add a new product using a form and print a report. You apply a filter by selection and sort a query, and then you apply a filter by form to a table. You save both filters.

Steps to Perform:

  1. Start Access. Open the downloaded Access file named Exp19_Access_Ch01_CapAssessment_Latte_Delights_Inventory.accdb. Add records to the Sales Reps table, allowing Access to assign the SalesRepID.
  2. Close the table. Open the Customers form in Form view, find the record for Baker Auto Supply, modify the Address1 to 4508 N.W. 7 Avenue, then save and close the form.
  3. Open the Products form, add the product Coffee-Arabica Premium with the specified details, save, and close the form.
  4. Open the Products report, verify it contains the new product, view in Print Preview, change layout to Landscape, save, and close.
  5. Sort the Customers table by Customer Name ascending, save and close.
  6. Sort the Revenue Stats query by City ascending, apply Filter by Selection to show only Pellum's stats, save and close.
  7. Use Filter by Form on the Products table to find premium brands introduced after 2017, preview, then close and save.
  8. Close all objects, then close the database and exit Access. Submit the database as instructed.
  9. Sample Paper For Above instruction
  10. Grader Instructions Access 2019 Project Exp19 Access Ch01 CapAssessment
  11. Introduction
  12. Managing a coffee shop efficiently requires accurate inventory records, effective a...
  13. Creating and Populating the Sales Reps Table
  14. The initial step in this project involved opening the existing database and adding records to the Sales Reps table. Using Access's automated assignment feature for SalesRepID, three new sales representatives—Karean Eissler, Namrata Rai, and Katryn Pellum—were entered. This process reinforced the importance of structured data entry, which ensures data integrity and facilitates future reporting functions (Harrington, 2016).
  15. Updating Customer and Product Information
  16. Next, the focus shifted to updating existing customer data and adding new product records. By modifying Baker Auto Supply's address through the Customer form, the exercise demonstrated practical skills in form-based data editing and the importance of maintaining current customer information. Subsequently, inputting the new product Coffee-Arabica Premium into the Products form illustrated the process of expanding product inventory and the use of forms for data entry, which minimizes errors (Cline, 2018).
  17. Report Generation and Layout Customization
  18. The report review step highlighted how reports serve as vital tools for visualizing data. Verifying the inclusion of the new product in the Products report ensured data accuracy. Changing the report layout to landscape facilitated better presentation, especially when printing or reviewing detailed information, emphasizing the importance of customization in report formatting (Roberts & Morosin, 2017).
  19. Sorting and Filtering Data for Analysis
  20. Sorting the Customers table by Customer Name was a straightforward manner to organize data alphabetically, enhancing readability. The application of Filter by Selection on the Revenue Stats query to isolate Pellum's statistics exemplified how targeted data analysis is performed within Access. Conducting a Filter by Form on the Products table to identify premium brands introduced after 2017 demonstrated dynamic filtering, crucial for focused data analysis and decision making (Evans, 2019).
  21. Conclusion
  22. This exercise underscored the fundamental database management techniques in Microsoft Access, including data entry, report customization, and data filtering. These skills are essential for effectively managing business data, enabling informed decision-making and operational efficiency. Mastery of these functions forms the backbone of proficient database administration and analysis.
  23. References
  • Harrington, J. L. (2016). Relational database design and implementation. Morgan Kaufmann.
  • Cline, M. (2018). Practical Microsoft Access 2013. Pearson.
  • Roberts, M., & Morosin, C. (2017). Using reports effectively in Access. Journal of Data Management, 19(2), 45-52.
  • Evans, R. (2019). Data filtering techniques in Access. Tech Publishing.

Related Assignments