{"id":19160,"date":"2021-11-29T03:34:03","date_gmt":"2021-11-29T03:34:03","guid":{"rendered":"https:\/\/assignmenttutors.net\/blog\/exp19_access_ch01_capassessment-latte-delights-inventory-1-0-2\/"},"modified":"2021-11-29T03:34:03","modified_gmt":"2021-11-29T03:34:03","slug":"exp19_access_ch01_capassessment-latte-delights-inventory-1-0-2","status":"publish","type":"post","link":"https:\/\/assignmenttutors.net\/blog\/exp19_access_ch01_capassessment-latte-delights-inventory-1-0-2\/","title":{"rendered":"Exp19_access_ch01_capassessment &#8211; latte delights inventory 1.0 |"},"content":{"rendered":"<div>\n<p>\u00a0\u00a0<strong>Project Description:<\/strong><\/p>\n<p>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.<\/p>\n<p>\u00a0\u00a0\u00a0\u00a0\u00a0<\/p>\n<p>Open \u00a0\u00a0the Customers form in Form view. Use Search to locate the record for <strong>Baker Auto \u00a0\u00a0Supply<\/strong>. Modify \u00a0\u00a0the record so that the Address1 field displays <strong>4508 N.W. 7 Avenue<\/strong>. Save and close the form.<\/p>\n<p>\u00a0<\/p>\n<p>Open the Products form in Form \u00a0\u00a0view. Add a new product (Access will automatically add the Product ID): <strong>Coffee-Arabica \u00a0\u00a0Premium<\/strong>. The \u00a0\u00a0Description is <strong>24\/Case, Pre-Ground 1.75 Oz Bags<\/strong>, the Cost is $<strong>13<\/strong> (just type 13, no $), the \u00a0\u00a0Markup Percent is <strong>100%<\/strong>, the Brand is <strong>Premium<\/strong>, and the Year Introduced is <strong>2017<\/strong>. Save the new record and close the form.<\/p>\n<p>\u00a0<\/p>\n<p>Open the Products report and \u00a0\u00a0check that the report contains the new product P0026, Coffee-Arabica Premium. \u00a0\u00a0View the layout of the report in Print Preview and then change the page \u00a0\u00a0layout to Landscape. Save the report and close Print Preview.<\/p>\n<p>\u00a0<\/p>\n<p>Open the Customers table. Sort \u00a0\u00a0the table by Customer Name in ascending order. Save the changes and close the \u00a0\u00a0table.<\/p>\n<p>\u00a0<\/p>\n<p>Open the Revenue Stats query and \u00a0\u00a0sort the City field in ascending order. Apply Filter by Selection so that \u00a0\u00a0only stats for the last name <em>Pellum<\/em> \u00a0\u00a0display. Save and close the filtered query.<\/p>\n<p>\u00a0<\/p>\n<p>Open the Products table. Use \u00a0\u00a0Filter by Form to create a filter that will identify all premium brands in \u00a0\u00a0the Brand field that were introduced after <strong>2017<\/strong>. Apply the filter and preview the filtered table. \u00a0\u00a0Close the table and save the changes.<\/p>\n<p>\u00a0<\/p>\n<p>Close all database objects. \u00a0\u00a0Close the database and then exit Access. Submit the database as directed.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>\u00a0\u00a0Project Description: 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 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[31],"tags":[],"class_list":["post-19160","post","type-post","status-publish","format-standard","hentry","category-homework-help"],"_links":{"self":[{"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/posts\/19160","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/comments?post=19160"}],"version-history":[{"count":0,"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/posts\/19160\/revisions"}],"wp:attachment":[{"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/media?parent=19160"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/categories?post=19160"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/tags?post=19160"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}