Please describe the steps in a specific manner to accomplish each task. This is done on Access.
Assignment Tasks Working with Reports Build a report showing a customer email list. Show the last name, first name, email address, and customerID (in that sequence). Order the records by lastname, then by firstname. Be sure that the report is only one page wide and that it will print on fewer than 100 standard pages. Save the report and name it "Customer List" (without the quotes). Your completed report should appear similar to the following: (17.5 points] Customer Tuesday, August 27, 2013 8:58:21 AM customer Last Name First Name email Asror May 11579 Abatelli Carol 10696 Abcouwer Toon 11306 Abiola Alex 10047 Abrams Gertrude 10622 Abuosba Khalil mynahbird3664@yahoo.com carolabatell14325@yahoo.com cat200@gmail.com guineapig7084@netzero.com mountaingoat6324@att.net hamster8504@blackcrabsculpting.com puppy3936@gmail.com denaacosta141@gmail.com frog1444@hotmail.com hiltonadair3409@yahoo.com fawn4436@adinet.com.uy 10954 Acevedo Cody 10896 Dena Acosta 12091 Thurman Acosta 10953 Adair Hilton 10121 Billy Adams 12111 Adams 12220 finch3434@gmail.com Carl 11 Adams Robert Adams shana Addas 11369 pony8964@yahoo.com shanaadam56029@gmail.com Shareladdas6141@aol.com parakeet354@susanmcooper.com aardvark 10ozimon.info Shamel 11166 Adipat Boonlit 12051 Adkins Erin Assignment Tasks KA Working with Reports Build a report listing all products and the customers who have purchased them. You ma need to build a query to organize the data to support this report. For each product, sho only the product name. Show the customers, first name, and last name for each customer. Also show the time the product was ordered and the quantity ordered at that time. Order the products alphabetically by product name, then by lastname and firstname. Set the page orientation of the report to landscape-this will give you a bit more room to fit the fields required for this report. Save your report and name it "Purchases by Product" (without the quotes). When your report is complete, it should resemble the following. [19.5 points] Purchases by Product Monthl y with sowe 2012-14 12/ 0 4 12/140121415 10 1/22/2011 1533 122120 2011 2/1/2013 005 2/1/2018 11/ /111700 42/2012 4/3/2013 2016 1/21/2011 2012 12072011104 2013 1225 2010 2016 th be 13 W . WD T 22 Working with Reports Using the "Products Sold by Quarter" query, build a report that organizes the sale of products into years and quarters. For each year in which sales have occurred, show the quarter in which the sales occurred. For each quarter shown, list all products sold during that quarter, the total quantity of products sold and the total revenue attributed to that product. Organize the products alphabetically by name. In the footer for each quarter group and for each year group and for the entire report, display the total number of products sold and the total revenue from those products. Name the report "Products Sold by Quarter" (without the quotes). When complete, your report should resemble the following: (19.5 points] Products Sold by Quarter DEDIN Quicistove Total for 2 $1.705 Quick Stove Replaceme Quick Stove Qucistov Cucistove can QuickStove Can Shipping Replacement Feels Total for Quick Steven G otove can shoping Stove Working with Reports Using the "oneOrder" query, build a report to display the information for a single order. Your report should appear similar to the one shown below. Name the report "Invoice" (without the quotes). [36 points] 4 QuickStove Invoice Order Number: 3345 Order Placed: 6/14/2013 2:49 Ship To: Sold To: Marie Larson 71901 Towish Dr. Corona, CA 92883 Marie Larson 71901 Towish Dr. Corona, CA 92883 Amount Product Quantity Price Klean Kanteen Wide 40 OZ $25.16 Stainless Steel Cooking Pot $17.99 Cordura D-Ring Bag $14.39 Firebox Upgrade Kit $17.99 Folding Firebox Campfire Stove $53.99 Order Total: Shipped on: 6/20/2013 FedEx (61297641981120001627) $26.16 $18.99 $15.39 $18.99 $54.99 $134.52 dex.html#desktop urch. MyEducator - IST... Cengage Awesome Movies... Bb Take Test: Quiz 8.... cha Assignment Tasks Context for Exporting Data Tasks Imagine that Howard has asked you to help him exporting some data from Access so he can import in into another sofware package for further analysis. This set of tasks as a total of 7.5 points, Exporting Data Export the data from the query named "Products Sold by Quarter" as a tab delimited text file. Include the column names in the export file. Use no text qualifier. Name the file "ProductsByQuarter.txt" (without the quotes) and be sure it is located in the same folder as the Access data file you are using file to complete this assignment. [7.5 points] 1 Assignment Tasks Working with Reports Build a report showing a customer email list. Show the last name, first name, email address, and customerID (in that sequence). Order the records by lastname, then by firstname. Be sure that the report is only one page wide and that it will print on fewer than 100 standard pages. Save the report and name it "Customer List" (without the quotes). Your completed report should appear similar to the following: (17.5 points] Customer Tuesday, August 27, 2013 8:58:21 AM customer Last Name First Name email Asror May 11579 Abatelli Carol 10696 Abcouwer Toon 11306 Abiola Alex 10047 Abrams Gertrude 10622 Abuosba Khalil mynahbird3664@yahoo.com carolabatell14325@yahoo.com cat200@gmail.com guineapig7084@netzero.com mountaingoat6324@att.net hamster8504@blackcrabsculpting.com puppy3936@gmail.com denaacosta141@gmail.com frog1444@hotmail.com hiltonadair3409@yahoo.com fawn4436@adinet.com.uy 10954 Acevedo Cody 10896 Dena Acosta 12091 Thurman Acosta 10953 Adair Hilton 10121 Billy Adams 12111 Adams 12220 finch3434@gmail.com Carl 11 Adams Robert Adams shana Addas 11369 pony8964@yahoo.com shanaadam56029@gmail.com Shareladdas6141@aol.com parakeet354@susanmcooper.com aardvark 10ozimon.info Shamel 11166 Adipat Boonlit 12051 Adkins Erin Assignment Tasks KA Working with Reports Build a report listing all products and the customers who have purchased them. You ma need to build a query to organize the data to support this report. For each product, sho only the product name. Show the customers, first name, and last name for each customer. Also show the time the product was ordered and the quantity ordered at that time. Order the products alphabetically by product name, then by lastname and firstname. Set the page orientation of the report to landscape-this will give you a bit more room to fit the fields required for this report. Save your report and name it "Purchases by Product" (without the quotes). When your report is complete, it should resemble the following. [19.5 points] Purchases by Product Monthl y with sowe 2012-14 12/ 0 4 12/140121415 10 1/22/2011 1533 122120 2011 2/1/2013 005 2/1/2018 11/ /111700 42/2012 4/3/2013 2016 1/21/2011 2012 12072011104 2013 1225 2010 2016 th be 13 W . WD T 22 Working with Reports Using the "Products Sold by Quarter" query, build a report that organizes the sale of products into years and quarters. For each year in which sales have occurred, show the quarter in which the sales occurred. For each quarter shown, list all products sold during that quarter, the total quantity of products sold and the total revenue attributed to that product. Organize the products alphabetically by name. In the footer for each quarter group and for each year group and for the entire report, display the total number of products sold and the total revenue from those products. Name the report "Products Sold by Quarter" (without the quotes). When complete, your report should resemble the following: (19.5 points] Products Sold by Quarter DEDIN Quicistove Total for 2 $1.705 Quick Stove Replaceme Quick Stove Qucistov Cucistove can QuickStove Can Shipping Replacement Feels Total for Quick Steven G otove can shoping Stove Working with Reports Using the "oneOrder" query, build a report to display the information for a single order. Your report should appear similar to the one shown below. Name the report "Invoice" (without the quotes). [36 points] 4 QuickStove Invoice Order Number: 3345 Order Placed: 6/14/2013 2:49 Ship To: Sold To: Marie Larson 71901 Towish Dr. Corona, CA 92883 Marie Larson 71901 Towish Dr. Corona, CA 92883 Amount Product Quantity Price Klean Kanteen Wide 40 OZ $25.16 Stainless Steel Cooking Pot $17.99 Cordura D-Ring Bag $14.39 Firebox Upgrade Kit $17.99 Folding Firebox Campfire Stove $53.99 Order Total: Shipped on: 6/20/2013 FedEx (61297641981120001627) $26.16 $18.99 $15.39 $18.99 $54.99 $134.52 dex.html#desktop urch. MyEducator - IST... Cengage Awesome Movies... Bb Take Test: Quiz 8.... cha Assignment Tasks Context for Exporting Data Tasks Imagine that Howard has asked you to help him exporting some data from Access so he can import in into another sofware package for further analysis. This set of tasks as a total of 7.5 points, Exporting Data Export the data from the query named "Products Sold by Quarter" as a tab delimited text file. Include the column names in the export file. Use no text qualifier. Name the file "ProductsByQuarter.txt" (without the quotes) and be sure it is located in the same folder as the Access data file you are using file to complete this assignment. [7.5 points] 1
