Monday, June 8, 2020

Microsoft Access Assignment Essay - 10450 Words

Microsoft Access Assignment (Essay Sample) Content: Studentà ¢Ã¢â€š ¬s NameProfessorà ¢Ã¢â€š ¬s NameCourse CodeDateMicrosoft Access AssignmentQuestion 1I created relationships between all the related fields in the six tables.Question 2The information obtained from the query is as follows:Products Query ProductName CompanyName Quantity Discount ShippedDate Sir Rodney's Scones Specialty Biscuits, Ltd. 40 15.00% 1/16/2013 Sir Rodney's Scones Specialty Biscuits, Ltd. 40 25.00% 1/19/2013 Nord-Ost Matjeshering Nord-Ost-Fisch Handelsgesellschaft mbH 28 25.00% 1/19/2013 PÃÆ' ¢tÃÆ' chinois Ma Maison 60 25.00% 1/19/2013 Gnocchi di nonna Alice Pasta Buttini s.r.l. 30 20.00% 1/23/2013 PÃÆ' ¢tÃÆ' chinois Ma Maison 30 15.00% 1/27/2013 Chef Anton's Cajun Seasoning New Orleans Cajun Delights 30 25.00% 1/28/2013 Geitost Norske Meierier 40 25.00% 1/28/2013 Question ThreeThe information obtained from the query is as follows:Second Query Company Name Contact Name ProductName UnitPrice ProductCost OrderDate Freight TradiÃÆ'ÃÆ'à ‚ £o Hipermercados Anabela Domingues Uncle Bob's Organic Dried Pears $30.00 $22.50 4/28/2012 $76.10 TradiÃÆ'ÃÆ' £o Hipermercados Anabela Domingues Northwoods Cranberry Sauce $40.00 $28.75 4/28/2012 $76.10 TradiÃÆ'ÃÆ' £o Hipermercados Anabela Domingues Mishi Kobe Niku $97.00 $65.00 4/28/2012 $76.10 TradiÃÆ'ÃÆ' £o Hipermercados Anabela Domingues Ikura $31.00 $30.00 4/28/2012 $76.10 TradiÃÆ'ÃÆ' £o Hipermercados Anabela Domingues Queso Manchego La Pastora $38.00 $22.75 4/28/2012 $76.10 TradiÃÆ'ÃÆ' £o Hipermercados Anabela Domingues Alice Mutton $39.00 $20.70 4/28/2012 $76.10 TradiÃÆ'ÃÆ' £o Hipermercados Anabela Domingues Carnarvon Tigers $62.50 $48.75 4/28/2012 $76.10 TradiÃÆ'ÃÆ' £o Hipermercados Anabela Domingues Sir Rodney's Marmalade $81.00 $58.80 4/28/2012 $76.10 TradiÃÆ'ÃÆ' £o Hipermercados Anabela Domingues GumbÃÆ'r GummibÃÆ'rchen $31.23 $22.80 4/28/2012 $76.10 TradiÃÆ'ÃÆ' £o Hipermercados Anabela Domingues Schoggi Schokolade $43.90 $22.89 4/2 8/2012 $76.10 TradiÃÆ'ÃÆ' £o Hipermercados Anabela Domingues RÃÆ'ssle Sauerkraut $45.60 $32.50 4/28/2012 $76.10 TradiÃÆ'ÃÆ' £o Hipermercados Anabela Domingues ThÃÆ' ¼ringer Rostbratwurst $123.79 $82.50 4/28/2012 $76.10 TradiÃÆ'ÃÆ' £o Hipermercados Anabela Domingues Nord-Ost Matjeshering $25.89 $12.20 4/28/2012 $76.10 TradiÃÆ'ÃÆ' £o Hipermercados Anabela Domingues Mascarpone Fabioli $32.00 $14.40 4/28/2012 $76.10 TradiÃÆ'ÃÆ' £o Hipermercados Anabela Domingues Gravad lax $26.00 $25.51 4/28/2012 $76.10 TradiÃÆ'ÃÆ' £o Hipermercados Anabela Domingues CÃÆ' ´te de Blaye $263.50 $263.01 4/28/2012 $76.10 TradiÃÆ'ÃÆ' £o Hipermercados Anabela Domingues Ipoh Coffee $46.00 $45.51 4/28/2012 $76.10 TradiÃÆ'ÃÆ' £o Hipermercados Anabela Domingues Manjimup Dried Apples $53.00 $52.51 4/28/2012 $76.10 TradiÃÆ'ÃÆ' £o Hipermercados Anabela Domingues Perth Pasties $32.80 $32.31 4/28/2012 $76.10 TradiÃÆ'ÃÆ' £o Hipermercados Anabela Domingues Gnocchi di nonna A lice $38.00 $37.51 4/28/2012 $76.10 TradiÃÆ'ÃÆ' £o Hipermercados Anabela Domingues Raclette Courdavault $55.00 $54.51 4/28/2012 $76.10 TradiÃÆ'ÃÆ' £o Hipermercados Anabela Domingues Camembert Pierrot $34.00 $33.51 4/28/2012 $76.10 TradiÃÆ'ÃÆ' £o Hipermercados Anabela Domingues Sirop d'ÃÆ'rable $28.50 $28.01 4/28/2012 $76.10 TradiÃÆ'ÃÆ' £o Hipermercados Anabela Domingues Tarte au sucre $49.30 $48.81 4/28/2012 $76.10 TradiÃÆ'ÃÆ' £o Hipermercados Anabela Domingues Vegie-spread $43.90 $43.41 4/28/2012 $76.10 TradiÃÆ'ÃÆ' £o Hipermercados Anabela Domingues Wimmers gute SemmelknÃÆ'del $33.25 $32.76 4/28/2012 $76.10 TradiÃÆ'ÃÆ' £o Hipermercados Anabela Domingues Gudbrandsdalsost $36.00 $35.51 4/28/2012 $76.10 TradiÃÆ'ÃÆ' £o Hipermercados Anabela Domingues Mozzarella di Giovanni $34.80 $34.31 4/28/2012 $76.10 Victuailles en stock Mary Saveley Uncle Bob's Organic Dried Pears $30.00 $22.50 5/1/2012 $53.05 Victuailles en stock Mary Saveley Northwoods Cranberry Sauce $40.00 $28.75 5/1/2012 $53.05 Victuailles en stock Mary Saveley Mishi Kobe Niku $97.00 $65.00 5/1/2012 $53.05 Victuailles en stock Mary Saveley Ikura $31.00 $30.00 5/1/2012 $53.05 Victuailles en stock Mary Saveley Queso Manchego La Pastora $38.00 $22.75 5/1/2012 $53.05 Victuailles en stock Mary Saveley Alice Mutton $39.00 $20.70 5/1/2012 $53.05 Victuailles en stock Mary Saveley Carnarvon Tigers $62.50 $48.75 5/1/2012 $53.05 Victuailles en stock Mary Saveley Sir Rodney's Marmalade $81.00 $58.80 5/1/2012 $53.05 Victuailles en stock Mary Saveley GumbÃÆ'r GummibÃÆ'rchen $31.23 $22.80 5/1/2012 $53.05 Victuailles en stock Mary Saveley Schoggi Schokolade $43.90 $22.89 5/1/2012 $53.05 Victuailles en stock Mary Saveley RÃÆ'ssle Sauerkraut $45.60 $32.50 5/1/2012 $53.05 Victuailles en stock Mary Saveley ThÃÆ' ¼ringer Rostbratwurst $123.79 $82.50 5/1/2012 $53.05 Victuailles en stock Mary Saveley Nord-Ost Matjeshering $25.89 $12.20 5/1/2012 $53.05 Victuailles en stock Mary Saveley Ma scarpone Fabioli $32.00 $14.40 5/1/2012 $53.05 Victuailles en stock Mary Saveley Gravad lax $26.00 $25.51 5/1/2012 $53.05 Victuailles en stock Mary Saveley CÃÆ' ´te de Blaye $263.50 $263.01 5/1/2012 $53.05 Victuailles en stock Mary Saveley Ipoh Coffee $46.00 $45.51 5/1/2012 $53.05 Victuailles en stock Mary Saveley Manjimup Dried Apples $53.00 $52.51 5/1/2012 $53.05 Victuailles en stock Mary Saveley Perth Pasties $32.80 $32.31 5/1/2012 $53.05 Victuailles en stock Mary Saveley Gnocchi di nonna Alice $38.00 $37.51 5/1/2012 $53.05 Victuailles en stock Mary Saveley Raclette Courdavault $55.00 $54.51 5/1/2012 $53.05 Victuailles en stock Mary Saveley Camembert Pierrot $34.00 $33.51 5/1/2012 $53.05 Victuailles en stock Mary Saveley Sirop d'ÃÆ'rable $28.50 $28.01 5/1/2012 $53.05 Victuailles en stock Mary Saveley Tarte au sucre $49.30 $48.81 5/1/2012 $53.05 Victuailles en stock Mary Saveley Vegie-spread $43.90 $43.41 5/1/2012 $53.05 Victuailles en stock Mary Saveley Wimmers gute Semmelknà ƒÆ'del $33.25 $32.76 5/1/2012 $53.05 Victuailles en stock Mary Saveley Gudbrandsdalsost $36.00 $35.51 5/1/2012 $53.05 Victuailles en stock Mary Saveley Mozzarella di Giovanni $34.80 $34.31 5/1/2012 $53.05 SuprÃÆ' ªmes dÃÆ'lices Pascale Cartrain Uncle Bob's Organic Dried Pears $30.00 $22.50 5/2/2012 $97.09 SuprÃÆ' ªmes dÃÆ'©...

No comments:

Post a Comment

Note: Only a member of this blog may post a comment.