Microsoft Access Exercise

profileiwatbo
MagnificentMeals-03.accdb
Home>Computer Science homework help>Microsoft Access Exercise
OrderID-FK MenuID-FK 3-ServingQty 6-ServingQty
MenuID MealName Description MealType 3-ServingCost 6-ServingCost ServingSize Calories TotalFat Sodium Cholesterol TotalCarbs Protein DateAddedToMenu
1 Savory Grilled Chicken with Sesame Honey Butter All natural chicken breasts are marinated in a blend of sweet sesame, garlic and ginger. Finished with a sesame honey butter sauce. Main Course ¤ 13.62 ¤ 25.95 1 breast 240 12 420 70 11 22 1/1/18
2 Cheese Stuffed Turkey Burger on a Pretzel Bun A flavorful twist on a classic burger. Juicy turkey mixed with a flavorful spice assortment. Stuffed with Mozzarella or goat cheese. Basil pesto mayo completes the tastebud sensation. Main Course ¤ 17.96 ¤ 34.21 1 burger with bun 700 39 995 120 51 34 1/1/18
3 Southwest Port Carnita Wraps Hearty wraps stuffed with slow cooked pork, tomatoes, salsa, white rice and cheddar cheese. Main Course ¤ 14.47 ¤ 30.39 1 wrap 390 10 1460 50 52 23 1/1/18
4 Chipotle Maple Corn Fresh corn kernals seasoned with a sweet maple sauce that carries a surprising chipotle kick. Side Dish ¤ 4.00 ¤ 7.00 1/2 cup 130 4 180 10 24 2 1/15/18
5 Lemon Garlic Chicken Garden fresh rub made of garlic, lemon, herbs and parsley provides just the right seasoning for our all natural chicken breasts. Main Course ¤ 14.66 ¤ 28.03 1 breast 180 8 320 55 3 23 1/15/18
6 Roasted Heirloom Potatoes Mixed white, red and purple potatoes are perfectly seasoned and roasted to a delightful crunch. Side Dish ¤ 4.25 ¤ 7.50 3/4 cup 140 6 370 0 19 2 2/1/18
7 Seafood Cioppino Shrimp, tender white fish and sea bass form the foundation of this hearty stew. Slow cooked to perfection with a tantalizing tomato broth seasoned with garlic and fresh herbs. Soup ¤ 19.81 ¤ 37.75 1 1/2 cups 200 7 1150 99 13 20 2/1/18
8 Chocolate Decadence Cake Rich chocolate fudge pudding filled between two layers of moist chocolate cake. A ganache frosting completes this indulgent dessert. Dessert ¤ 12.50 ¤ 21.00 1 slice 680 39 360 155 81 9 2/1/18
9 Peanut Butter Cupcake Dark chocolate cake bursting with a chocolate-peanut butter center. Fluffy vanilla icing is topped with a peanut butter cup. Dessert ¤ 7.80 ¤ 12.75 1 cupcake 310 18 260 15 34 4 2/15/18
10 Almond Green Beans Fresh green beans topped with seasoned butter and toasted almonds. Side Dish ¤ 3.59 ¤ 6.25 2/3 cup 90 6 320 10 6 2 2/15/18
11 Oatmeal Raisin Cookies Soft, chewy oatmeal and raisin cookies are flavored with just the right amount of brown sugar and cinnamon. Dessert ¤ 5.84 ¤ 10.00 2 cookies 150 66 182 29 25 2 5/1/18
OrderID OrderDate CustomerID EmployeeID DeliveryDateTime
10100 6/1/18 1000 B15 6/5/18
10101 6/1/18 1010 B15 6/3/18
10102 6/1/18 1015 A22 6/4/18
10103 6/2/18 1200 B15 6/6/18
10104 6/2/18 1050 A22 6/3/18
10105 6/3/18 1075 A22 6/4/18
10106 6/3/18 1135 A22 6/4/18
10107 6/4/18 1010 B15 6/5/18
10108 6/4/18 1180 B15 6/7/18
10109 6/4/18 1180 B15 6/8/18
10110 6/4/18 1210 B15 6/10/18
10111 6/4/18 1015 B15 6/6/18
SELECT DISTINCTROW * FROM Orders;
SELECT DISTINCTROW * FROM Meals;