USA: +1(669)289-8683
USA: +1(669)289-8683

Microsoft Access Excercise 2

I have attached the exercise and database example it is associated with. 

Save Time On Research and Writing
Hire a Pro to Write You a 100% Plagiarism-Free Paper.
Get My Paper
ID Product Types
1 Cookies
2 Cakes
3 Cupcakes
4 Pies
5 Pastries
ID

tes

1

East Walker Dr.

–

Save Time On Research and Writing
Hire a Pro to Write You a 100% Plagiarism-Free Paper.
Get My Paper

5-

No

2

9 Brewer St.

NC

9-555-

3

St. George Ave.

NC

4

Raleigh No

4

sborough St.

NC

8

Raleigh No

5

NC

Raleigh No

6

NC

4

12

Yes- Weekly

7

1 Hodge Ln.

NC

0

Cary No

8

Huntington St.

NC

2

53

Raleigh

9

Newman

NC

5

Raleigh No

10

iam

s

14 Miller Ln.

NC

13

75

Durham Yes- Weekly

11

Jones

Rd.

NC 27513

Cary No

12

North West St.

NC 27606

3

Raleigh Yes- Special Offers Only

13

NC

2

Raleigh No

14

Hill

Field Ave.

NC 27609

Raleigh No

Smith

NC

No

16

North St.

NC 27609

Raleigh No

NC

Raleigh Yes- Special Offers Only

25 Venice Ct.

NC 27605

Raleigh Yes- Special Offers Only

19

NC 27609

Raleigh No

on

North Luke Ct.

NC 27609

22

Raleigh No

29

Jones

-C Chapel Ct.

NC

Durham No

ita

Williams

NC 27609

4

Raleigh No

South Pejulup Ln.

NC

3

Raleigh No

32

Heuristic Way

NC 27609

@email.com

Raleigh Yes- Special Offers Only

33

0 New Cove Rd.

NC

9

Garner No

g

NC

66

Raleigh No

Rd.

NC

Raleigh No

Glenwood Ave. Unit A

NC

Raleigh Yes- Special Offers Only

% discount

38

7

St. Apt E

NC 27605

8

Raleigh No

Cedar Ln.

NC 27609

Raleigh No

NC 27612

Raleigh Yes- Special Offers Only

5 Ross Park Dr.

NC 27609

Raleigh No

William

Glenwood Ave.

NC 27609

8

Raleigh No

43

NC 27615

Raleigh Yes- Special Offers Only

44

St.

NC 27607

Raleigh No

45

Jameson

NC 27608

4

Raleigh No

46

Hopkins

enton St.

NC 27609

Raleigh Yes- Special Offers Only

47

1 Dawson St.

NC 27609

Raleigh Yes- Special Offers Only

Oberlin Rd.

NC 27603

Raleigh Yes- Special Offers Only

9 Cameron Ave.

NC 27609

Raleigh Yes- Special Offers Only

50 Chloe

NC 27608

Raleigh Yes- Special Offers Only

51 Juanita Harris

NC 27603

Raleigh No

52 Denver Ferguson

NC 27605

Raleigh No

53

Hillsborough St.

NC

Garner Yes- Special Offers Only

54

NC 27609

Raleigh Yes- Special Offers Only

55

NC 27612

Raleigh No

56

NC 27609

Raleigh No

57

Denver

NC 27609

Raleigh No

58

David

NC 27603

Raleigh No

NC 27608

Raleigh Yes- Special Offers Only

60 Harris

NC 27608

Raleigh Yes- Special Offers Only

61

NC 27615

Raleigh No

Colin

NC 27603

Raleigh Yes- Special Offers Only

63

NC 27609

Raleigh Yes- Special Offers Only

64

NC 27603

Raleigh No

65

NC 27612

Raleigh Yes- Special Offers Only

66

NC 27612

Raleigh No

67

St.

NC 27609

Raleigh Yes- Special Offers Only

68

NC 27609

Raleigh No

NC 27607

Raleigh Yes- Special Offers Only

70

Cobb Rd.

NC 27609

Raleigh No

71

NC 27607

Raleigh No

72

NC

No

73

NC 27609

Raleigh No

74

Smith

NC 27609

5

Raleigh No

75

NC 27513

Cary No

76

n

NC 27615

Raleigh No

77

NC 27607

Raleigh No

78

NC 27609

Raleigh No

St.

NC 27615

Raleigh No

80

NC 27606

Raleigh No

81

NC 27615

Raleigh No

Brie

NC 27609

Raleigh No

83

NC 27609

Raleigh No

NC 27612

Raleigh No

85

0

son

St.

NC 27609

8

Raleigh No

86

NC 27529

Garner No

87

NC

2

Chapel Hill No

88

NC 27513

Cary No

89 Roger

NC 27609

Raleigh No

90

NC 27607

Raleigh No

91

NC 27609

Raleigh No

92

NC 27609

7

Raleigh No

NC 27603

Raleigh No

NC 27615

Raleigh No

95

NC 27607

7

Raleigh No

NC 27609

4

Raleigh No

97

NC 27607

Raleigh No

98

NC 27608

Raleigh No

99

NC 27606

Raleigh No

100

NC 27609

3

Raleigh No

101

NC 27615

Raleigh No

102

Baker St.

NC 27609

0

Raleigh No

NC 27714

Durham No

NC 27605

0

Raleigh No

105

James

NC 27513

Cary No

106

Love

NC 27609

Raleigh No

NC 27603

Raleigh No

NC 27609

2

Raleigh No

NC 27609

Raleigh No

rkolou

NC 27615

Raleigh No

NC 27609

Raleigh No

112

NC 27609

Raleigh No

113

1 Rubber Rd.

NC 27608

Raleigh No

Anna St.

NC 27607

Raleigh No

NC 27609

Raleigh No

NC 27609

Raleigh No

NC 27514

Chapel Hill No

NC 27609

Raleigh No

NC

5

Durham No

120

NC 27513

Cary No

NC 27607

Raleigh No

122

NC 27609

Raleigh No

123

NC 27605

Raleigh No

124

Juliane St.

NC 27609

Raleigh No

George

NC 27615

Raleigh No

NC 27608

Raleigh No

127 Ed

hew

‘s St.

NC 27608

Raleigh No

Will

NC 27612

Raleigh No

129

NC 27603

Raleigh No

NC 27609

Raleigh No

NC 27606

Raleigh No

NC 27609

Raleigh No

NC 27714

Durham No

NC 27609

Raleigh No

NC 27609

Raleigh No

NC 27615

Raleigh No

White

NC 27513

Cary No

Lane

NC 27607

Raleigh No

Matthew

NC 27609

Raleigh No

NC 27609

Raleigh No

Jackson

Rd.

NC 27605

Raleigh No

NC 27609

Raleigh No

NC

Raleigh No

NC 27601

Raleigh No

145

NC 27603

Raleigh No

Tu

NC 27609

5

Raleigh No

147 Magda Sremski

NC 27612

Raleigh No

NC 27607

Raleigh No

NC 27607

Raleigh No

150

NC 27514

Cary No

NC 27609

Raleigh No

152

NC 27609

Raleigh No

153

NC 27615

Raleigh No

154 Virginia

NC 27601

Raleigh No

NC 27609

Raleigh No

156

Greene

NC 27608

Raleigh No

157

NC

Raleigh No

158

Lee

NC 27609

Raleigh No

NC 27605

Raleigh No

NC 27529

Garner No

NC 27514

Chapel Hill No

NC 27608

Raleigh No

NC 27607

Raleigh No

NC 27609

Raleigh No

Jack Ford

NC 27615

Raleigh No

NC 27606

Raleigh No

John

NC 27615

Raleigh No

NC 27609

Raleigh No

NC 27609

Raleigh No

James

NC 27609

Raleigh No

NC 27608

Raleigh No

NC 27609

Raleigh No

David

NC 27609

Raleigh No

3 Solo Ln. NC 27607

Raleigh No

NC 27615

Raleigh No

NC 27608

Raleigh No

NC 27601

Raleigh No

NC 27601

Raleigh No

Melissa White

NC 27612

Raleigh No

NC 27601

Raleigh No

NC 27609 mreynolds@email.com

Raleigh No

NC 27612

Raleigh No

183 Michael

NC 27513

Raleigh No

Chen

NC 27609

Raleigh No

NC 27609

Raleigh No

NC 27601

Raleigh No

Samantha Bell

NC 27609

Raleigh No

NC 27601

Raleigh No

Kelly

NC 27616

Raleigh No

Matt

NC 27616

Raleigh No

NC 27609

Raleigh No

James

Jackson St.

NC 27616

Raleigh No

NC 27608

Raleigh No

NC

Chapel Hill No

NC 27605

Raleigh No

Jordan Weller

NC 27609

Raleigh No

NC 27701

Durham No

198 Alex

NC 27513

Cary No

NC 27714

Durham No

200

NC 27609

Durham No

201

NC 27513

Cary No

202 Juan

NC 27714

Durham No

204

NC 27603

Raleigh No

NC 27603

Raleigh No

NC

No

NC

Charlotte No

208

NC

Hillsborough No

Will

NC 27701

Raleigh No

David Barrett

NC 27609

919-555-0662 Raleigh No

First Name Last Name Street Address State Zip Code Email Phone Number City Add to Mailing List? Other

No
Tracey Beckham 7 NC 27 6 12 beck@email.com 9 19 55 23 14 Raleigh
Lucinda George 7

 8 2

 75 13 lugeo@email.com 91 45 34 Cary Yes- Weekly
Jerrod Smith 2

 11 2

 76 10 texj@email.com 919-555-4

 56
Brett Newkirk 47 Hill 27

 60 newkb@email.com 919-555-76

 53
Chloe Jones 2

3 Solo Ln. 27609 lo@email.com 919-555-

 86 58
Quinton Boyd 4 Cypress Cr. 27

 71 denqui@email.com 919-555-

 51 Durham
Alex Hinton 101 27513 dhoda@email.com 919-555-5

 46
Nisha Hall 123 27

 61 hall@email.com 919-555-

 57 Yes- Special Offers Only
Hillary Clayton 25 16 27606 mshill@email.com 919-555-9

 74
Kiara Will 90 2

 77 rogki@email.com 919-555-

 89
Katy 456

Denver yjonesk@email.com 919-555-23

 32
Beatrix Joslin 85 jozbee@email.com 919-555-

 112
Mariah Allen 12 Jupe 27605 mallen@email.com 919-555-3

 43 Nut allergy
Jennifer 2

 100 hillj@email.com 919-555-

 54 67
15 Jaleel 123 Hill Top Drive 27610 jsmi@email.com 919-555-7755 Garner
Cody Hayes 65 richhi@email.com 919-555-5434
17 Amaya Gibson 5 West St. 27612 alg@email.com 919-555-7565
18 Cynthia Love 78 topv@email.com 919-555-4655
Cindy Freeman 78-A Meadowview Ln. cindyfree@email.com 919-555-7890
20 Barbara James 29 bjaes@email.com 919-555-

 22 Diabetic- Make all w/substitute sugar
Bob 63 27714 Bob_ready2read@email.com 919-555-2

1

 21
30 Juan 123 Garden Plow Way Juanita_ready2read@email.com 919-555-4

 33
31 Sara Thomas 127 27603 Sarasara@email.com 919-555-5

 64
Larry Binder 1

 24 Larry

 87 919-555-5657
Samantha Ferguson 2

 38 27

 52 Sferguson@email.com 919-555-6576
35 Patti Chen 9 Atlantic Blvd 27608 Jamie_X@email.com 919-555-

 66
36 Greg Newton 2520

Hopkins 27615 ChengPat@email.com 919-555-4585
37 Carol Allenson 3

201 27607 GregNew@email.com 919-555-7575 The boss’s mom-

50
Zoey Altman 81 Hillsborough 102 callenson@email.com 919-555-6

 68
39 Danny Haverford 202 zalt@email.com 919-555-7778
40 Vig Aurelio 53 Pine St. daurelio@email.com 919-555-8789
41 Jeffery Bergman 124 bigvig22@email.com 919-555-46

 44
42 Bittiman 1

 122 jefejeff@email.com 919-555-6

 88
Megan Draper 311 Cook St. willbit@email.com 919-555-07

 83
Dick Whitman 105 David megansays@email.com 919-555-5042
Marjan 202 C St. Unit A callmedon@email.com 919-555-

204
Colin 321 E.

Ed margy@email.com 919-555-0544
Hakim Auden 92 colin_hopkins@email.com 919-555-0045
48 Pilar Semana 72 hauden@email.com 919-555-5404
49 Eliza Harris 98 eharris@email.com 919-555-0455
Ford 3456 Glenwood Ave. chloedit@email.com 919-555-0464
43 Prosperity Way juaniii@email.com 919-555-0475
856 Cook St. denverferg@email.com 919-555-0402
John Emory 99 27529 emoryj@email.com 919-555-0007
Ebony Farmer 872 W. Morgan St. ebonique@email.com 919-555-5040
Kim Doe 553 Wayne St. kdoe@email.com 919-555-5560
Coretta Diaz 781 Bloodsworth St. corettadee@email.com 919-555-5721
Victor 31 St. Mary’s St. vickdenver@email.com 919-555-54

 70
Hamish 21 Cameron Ct. hamman@email.com 919-555-65

 80
59 Erin Counts 763 E. West St. ecounts@email.com 919-555-5070
Collman 455 E. Edenton St. harrisc@email.com 919-555-0570
Melissa Chantay 3201 Glenwood Ave. Unit C chantayay@email.com 919-555-5750
62 Emmanual 11 Sassafras Way oemmanual@email.com 919-555-0575
Illa Carlson 563 Oberlin Rd. illac@email.com 919-555-0668
Tyrone Rodgers 453 Pine St. tyroner@email.com 919-555-0870
Roger Robinson 634 Oak Ave. rogrob@email.com 919-555-6860
Robert Jenkins 44 Hickory Rd. rjenks@email.com 919-555-6807
Joy Zachman 8

 97 Lee jzman@email.com 919-555-0858
Frances Trenton 901 Kenan Rd. grammasangels@email.com 919-555-0509
69 Latavia Rienstra 3 McIver Ct. latayy@email.com 919-555-7780
Kurtis Temple 1

 73 kurtemple@email.com 919-555-8704
Lashaunda White 211 Hinton St. la_shaun@email.com 919-555-78

 95
Lieselotte Tempie 12 Spencer Ave. 27517 lieselotte@email.com 919-555-4789 Chapel Hill
Sula Smart 56 Dey Rd. sulas@email.com 919-555-4562
Jude 929 Greenlaw Dr. judesm@email.com 919-555-4

 26
Katharine Kellerman 76 Murphy Ave. katharine_kellerman@email.com 919-555-4526
Ruiari O’

Brie 100 Aycock St. ruiaribig@email.com 919-555-4124
Tyra Kirby 8700 Stacey Rd. notthattyra@email.com 919-555-4354
Michiko Akiwana 901 Glenwood Ave. michichan@email.com 919-555-4102
79 Betty Potter 80

Greene bettyandjack@email.com 919-555-4021
Elizabeth Loges 44 Steven Rd. lizzyloges@email.com 919-555-4780
Janie Widby 3100 St. Mark’s St. janie56@email.com 919-555-1025
82 Trudy 25 Hillsborough St. trudywife@email.com 919-555-1021
Jane Sterling 331 W. Hargett St. rogersjane@email.com 919-555-1026
84 Magda Sremski 98 Tyler St. magdayum@email.com 919-555-1024
Peggy Moss 113 Jack peggycopywriter@email.com 919-555-

 147
Elisabeth Olsen 4325 W. King St. lissyolsen@email.com 919-555-1475
Robert Armisen 21 MLK Blvd. 27514 robarmisen@email.com 919-555-

 145
Don Hamm 1221 Coretta Scott Way donhamm@email.com 919-555-1458
Slattery 82 Parks St. rslat@email.com 919-555-1456
Joan Hendricks 60 Glenwood Ave Apt E

 106 joanie@email.com 919-555-1459
Pete Karthiser 98 Pale View Rd. karthiser@email.com 919-555-1453
Raphaelle Duvalier 922 Hill St. raphduvalier@email.com 919-555-

 154
93 Bruno D’Haussy 21 Bird St. brunodh@email.com 919-555-1548
94 Margot D’Illiers 532 Chronicle Way margotmdr@email.com 919-555-1542
Florent Marais 53 Ada St. florentdit@email.com 919-555-

 158
96 Erwan Haussman 918 Lonesome Dove Rd. ptiterwan@email.com 919-555-

 157
Rodrigue Bolougne 49 Mockingbird Way rody@email.com 919-555-1578
Alix Mars 9211 Dolores Rd. alixla@email.com 919-555-1589
Camille Germain 902 Haze St. camillge@email.com 919-555-1586
Capucine Desetoiles 122 MLK Blvd capustar@email.com 919-555-

 156
Colombane Lafleur 48 St. Louis Way colomblafleur@email.com 919-555-1562 Rude!
Theodore Achi 120 tachi@email.com 919-555-

 153
103 Remy Labiere 910 Mint St. remybeer@email.com 919-555-1536
104 Lebron Wade 1002 Parsley Way lebron@email.com 919-555-

 152
Dwyane 4221 Basil Ct. dwyane@email.com 919-555-1526
Joakim 449 Thyme Ln. joakimjoking@email.com 919-555-1524
107 Kevin Noah 41 Pepper Rd. kno@email.com 919-555-1523
108 Blake Bryant 536 Abbey Rd. blakeyblake@email.com 919-555-

 150
109 Kobe Griffins 789 Penny Ln. kobegrif@email.com 919-555-1018
110 Michael Tu 4 Strawberry Ct. elturk@email.com 919-555-1020
111 Hedo Jordan 637 Lucy Ln. hedohedo@email.com 919-555-0012
Dwight Parker 8 Rocky Way dparker@email.com 919-555-1002
Tony Howard 183 tonyhoward@email.com 919-555-1032
114 Kendra Rosche 129 krosche@email.com 919-555-1054
115 Jedd Fish 62 Glenwood Ave Apt A255 fish_jedd@email.com 919-555-1580
116 Julie Tilley 79 Murphy Ave. juilley@email.com 919-555-1058
117 Jeanne Daugherty 105 Aycock St. jdot@email.com 919-555-1096
118 Jake Szypulski 87 Stacey Rd. jszyp@email.com 919-555-1074
119 Eric Oglesby 91 Glenwood Ave. 27701 eoglesby@email.com 919-555-

 208
Jacek Slobodowski 7 Greene St. jacekslo@email.com 919-555-3021
121 Filip Piatek 99 Steven Rd. piatekfil@email.com 919-555-1088
Lew Riley 31 St. Mark’s St. lewisriley@email.com 919-555-8050
Maciej Pajak 21 Hillsborough St. Apt. 6 maciej@email.com 919-555-9059
Andrew Bedinger 28 andrewbed@email.com 919-555-1045
125 Wein 33 Bartholomew Ln. gwein@email.com 919-555-3302
126 Dane Raught 54 Micah Rd. rdane@email.com 919-555-0557
Bradshaw 3221 St.

Matt bredshaw@email.com 919-555-0647
128 Martel 910 Elizabeth

Lane willmartel@email.com 919-555-0356
Yann Augerot 88 Carolina Rd. augeryann@email.com 919-555-0657
130 Kellen Leigh 12 Florida St. kellenleigh@email.com 919-555-0687
131 Andrzej Wujek 424 Georgia Ct. andrzej@email.com 919-555-0450
132 Jaquon Whitty 82 Massachusetts Ave. jaqqq@email.com 919-555-0500
133 Zavion Storey 1834 Dakota St. zavistor@email.com 919-555-0578
134 Jar’Nae Bryson 2 Vermont Rd. jar.nae@email.com 919-555-0576
135 Takevia Watson 9244 Pennsylvania St. takewats@email.com 919-555-0579
136 Xy’nya Bell 23 Colorado Ct. xynia@email.com 919-555-0758
137 Kle’Aija 911 Oregon Tr. kleaija@email.com 919-555-0213
138 Hollings 7 Mississippi Ln. lhollings@email.com 919-555-0214
139 Tappen 44 Connecticut Blvd. mattapp@email.com 919-555-0324
140 Alyssa Ullman 3321 Bronwen Ct. allyulls@email.com 919-555-5778
141 Ta’Nyia 40

Virginia taniyaj@email.com 919-555-5998
142 I’mmoni Price 788 Cudie Ln. immonioni@email.com 919-555-6882
143 Laila Blue 7 New St. 27601 lblue@email.com 919-555-6100
144 Makeda Niebo 412 Dean St. niebom@email.com 919-555-6540
Xiaoxi Zheng 90 Hillsborough St. askxiaoxi@email.com 919-555-2786
146 Xiaolin 1243 W. Morgan St. tuxi@email.com 919-555-

200
544 Wayne St. gollymissmolly@email.com 919-555-4001
148 Hugh Jodey 531 Bloodsworth St. hugeodie@email.com 919-555-1001
149 Sasha Bright 4 St. Mary’s St. sbright@email.com 919-555-1400
Brigit Sigrudsdatter 55 Cameron Ct. brigitsigrudsdatter@email.com 919-555-0089
151 Vladimir Tolstoy 19 E. West St. vladtol@email.com 919-555-0033
Leo Nabokov 532 E. Edenton St. leonabo@email.com 919-555-0444
Carson Woolf 3541 Glenwood Ave. Unit C carsonwoolf@email.com 919-555-0440
McCullers 98 Sassafras Way virgymcullers@email.com 919-555-0142
155 Graham Dosty 43 Oberlin Rd. dosty@email.com 919-555-0047
Fyodor 54 Pine St. fyodoro@email.com 919-555-9000
Haruki Ido 63 Oak Ave. 27616 harukido@email.com 919-555-8000
Thornton 411 Hickory Rd. thorntonly@email.com 919-555-7000
159 Harper Wilder 843 Lee St. harperwild@email.com 919-555-6006
160 Langston Brooks 971 Kenan Rd. langstonb@email.com 919-555-5000
161 Gwendolyn Hughes 334 McIver Ct. gwendolynlambhughes@email.com 919-555-4000
162 Maya Kafka 453 Cobb Rd. mayakaf@email.com 919-555-2899
163 Franz Angelou 291 Hinton St. franzangelou@email.com 919-555-2000
164 Sawyer Brown 125 Spencer Ave. sawyerb@email.com 919-555-1000
165 568 Dey Rd. jfford@email.com 919-555-0999
166 Kate Locke 8779 Greenlaw Dr. katelocke@email.com 919-555-0998
167 Broad 7 Murphy Ave. jbroad@email.com 919-555-0997
168 Shannon Opley 97 Aycock St. shopley@email.com 919-555-0666
169 Peter Demarcy 70 Stacey Rd. demarcypete@email.com 919-555-0665
170 Walt 67 East Walker Dr. walterrjames@email.com 919-555-6640
171 Sayid Rayeen 7549 Brewer St. sayid84@email.com 919-555-0664
172 Hugo Ramierez 222 St. George Ave. hellohugo@email.com 919-555-0663
173 Barrett 430 Hill St. cataleeeeen@email.com 919-555-0662
174 Benjamin Linus evilben@email.com 919-555-0661
175 Cassandra Rousseau 443 Cypress Cr. cassierousseau@email.com 919-555-0660
176 Esther Yaron 166 Hodge Ln. estheryaron@email.com 919-555-3000
177 Anisa Naser 62 Huntington St. anaser@email.com 919-555-3001
178 Brigid Ellison 256 Newman Dr. briggyellison@email.com 919-555-3002
179 906 Miller Ln. mwhite@email.com 919-555-3003
180 Malik Reynolds 457 Denver Rd. mreynolds@email.com 919-555-3004
181 Windy Shaw 8 Chavez St. 919-555-3005
182 Christopher Peyton-Gomez 16 Jupe Dr. shawywind@email.com 919-555-3006
Lazar 8 July Ave. chrispg@email.com 919-555-3007
184 Christiana 12 Hill Top Dr. laserlazar@email.com 919-555-3008
185 Sidney Kelly 66 North St. chencris@email.com 919-555-3009
186 Chevonne Means 97 West St. sidkelly@email.com 919-555-7008
187 75 Venice Ct. chevvymeans@email.com 919-555-7009
188 Nathan Albee 76-C Meadowview Ln. samabell@email.com 919-555-7010
189 Avery 32 North Luke Ct. natealbee@email.com 919-555-7011
190 Benson 69-B Chapel Ct. kavery@email.com 919-555-7012
191 Gabriel Del Toro 92 Garden Plow Way bensonm@email.com 919-555-1023
192 Panarello 198 gabidt@email.com 919-555-7023
193 Chantal Weller 234 W. King St. panarello@email.com 919-555-7024
194 Derek MacDonald 243 MLK Blvd. 27707 youngmacdonald@email.com 919-555-7025
195 Kris Ackerman 1311 Coretta Scott Way krack@email.com 919-555-7068
196 8 Parks St. jwell@email.com 919-555-7069
197 Regina Olivera 60 Glenwood Ave Apt A121 queenregina@email.com 919-555-7070
Yuen 8 Marcus Ln. yualex@email.com 919-555-8080
199 Lia Richards 890 Garvey St. lialialia@email.com 919-555-9090
Karla Nichols 981 DuBois Ct. karlacheer92@email.com 919-555-4040
Tyrese Hanlon 31 Crispus Ct. Apt B tyreezzz@email.com 919-555-5050
Flores 122 Luna St. juanflo@email.com 919-555-6060
Tobias Inman 34 Peace St. toby@email.com 919-555-0000 Allergic to everything
205 Teyonah Lamb 321 Home Dr. tlamb@email.com 919-555-8801
206 Gregoire Pick 604 Hatsy Way 28203 gre@email.com 336-555-3132 Charlotte
207 Mallary Pont 91 Julianna Way 28201 charchar@email.com 336-555-2211
Rajeev Parthasarathy 1009 Raleigh Street 27278 rajey@email.com 919-555-0321
209 Good 38 Learnfree St. 919-555-9455
212 434 Hill St. davidbarrett@email.com
ID

ID

Price

6 35 1

0

7 9 1 ¤ 22.00
8 10 1 ¤ 22.00
9 11 1 ¤ 22.00
10 12 1 ¤ 22.00
11 13 1 ¤ 22.00
12 14 1 ¤ 22.00
13 15 1 ¤ 22.00
14 16 1 ¤ 22.00
15 17 1 ¤ 22.00
16 18 1 ¤ 22.00
17 19 1 ¤ 22.00
18 20 1 ¤ 22.00
19 21 1

0

20 22 1

0

21 23 1

0

22 24 1 ¤

0

23 25 1 ¤ 24.00
24 26 1 ¤ 24.00
25 27 1 ¤ 24.00
26 28 1 ¤ 24.00
27 29 1 ¤ 24.00
28 30 1

30 46 1

31 46 2

32 46 3

33 47 1 ¤ 1.50
34 47 2 ¤ 7.50
35 47 3 ¤ 14.00
36 58 1 ¤ 1.50
37 58 2 ¤ 7.50
38 58 3 ¤ 14.00
39 59 1 ¤ 1.50
40 59 2 ¤ 7.50
41 59 3 ¤ 14.00
42 60 1 ¤ 1.50
43 60 2 ¤ 7.50
44 60 3 ¤ 14.00
45 61 1 ¤ 1.50
46 61 2 ¤ 7.50
47 61 3 ¤ 14.00
48 62 1 ¤ 1.50
49 62 2 ¤ 7.50
50 62 3 ¤ 14.00
51 63 1 ¤ 1.50
52 63 2 ¤ 7.50
53 63 3 ¤ 14.00
54 64 1 ¤ 1.50
55 64 2 ¤ 7.50
56 64 3 ¤ 14.00
57 65 1

58 65 2

59 65 3

0

60 66 1 ¤ 2.00
61 66 2 ¤ 10.50
62 66 3 ¤ 19.00
63 67 1 ¤ 2.00
64 67 2 ¤ 10.50
65 67 3 ¤ 19.00
66 68 1 ¤ 2.00
67 68 2 ¤ 10.50
68 68 3 ¤ 19.00
69 69 1 ¤ 2.00
70 69 2 ¤ 10.50
71 69 3 ¤ 19.00
72 70 1 ¤ 2.00
73 70 2 ¤ 10.50
74 70 3 ¤ 19.00
75 31 1

76 31 2

77 31 3 ¤ 24.00
78 32 1 ¤ 2.50
79 32 2 ¤ 13.50
80 32 3 ¤ 24.00
81 33 1 ¤ 2.50
82 33 2 ¤ 13.50
83 33 3 ¤ 24.00
84 34 1 ¤ 2.50
85 34 2 ¤ 13.50
86 34 3 ¤ 24.00
87 35 1 ¤ 2.50
88 35 2 ¤ 13.50
89 35 3 ¤ 24.00
90 36 1 ¤ 2.50
91 36 2 ¤ 13.50
92 36 3 ¤ 24.00
93 37 1 ¤ 2.50
94 37 2 ¤ 13.50
95 37 3 ¤ 24.00
96 38 1 ¤ 2.50
97 38 2 ¤ 13.50
98 38 3 ¤ 24.00
99 39 1 ¤ 2.50
100 39 2 ¤ 13.50
101 39 3 ¤ 24.00
102 40 1 ¤ 2.50
103 40 2 ¤ 13.50
104 40 3 ¤ 24.00
105 41 1 ¤ 2.50
106 41 2 ¤ 13.50
107 41 3 ¤ 24.00
108 42 1 ¤ 2.50
109 42 2 ¤ 13.50
110 42 3 ¤ 24.00
111 43 1

0

112 43 2

113 43 3

114 44 1 ¤ 3.00
115 44 2 ¤ 16.00
116 44 3 ¤ 30.00
117 45 1 ¤ 3.00
118 45 2 ¤ 16.00
119 45 3 ¤ 30.00
120 89 1

0

121 90 1 ¤ 15.00
122 91 1 ¤ 16.00
123 92 1 ¤ 16.00
124 93 1 ¤ 16.00
125 94 1 ¤ 16.00
126 95 1 ¤ 16.00
127 96 1 ¤ 16.00
128 97 1 ¤ 16.00
129 98 1 ¤ 16.00
130 99 1 ¤ 16.00
131 100 1

0

132 101 1 ¤ 17.00
133 102 1 ¤ 17.00
134 103 1 ¤ 17.00
135 104 1 ¤ 17.00
136 105 1 ¤ 17.00
138 73 1 ¤ 1.50
139 73 2 ¤ 7.50
140 73 3 ¤ 14.00
141 74 1 ¤ 2.50
142 74 2 ¤ 13.50
143 74 3 ¤ 24.00
144 75 1 ¤ 3.00
145 75 2 ¤ 16.00
146 75 3 ¤ 30.00
147 76 1 ¤ 3.00
148 76 2 ¤ 16.00
149 76 3 ¤ 30.00
150 77 1 ¤ 3.00
151 77 2 ¤ 16.00
152 77 3 ¤ 30.00
153 78 1 ¤ 3.00
154 78 2 ¤ 16.00
155 78 3 ¤ 30.00
156 79 1 ¤ 3.00
157 79 2 ¤ 16.00
158 79 3 ¤ 30.00
159 80 1

160 80 2 ¤ 19.00
161 80 3

162 81 1 ¤ 3.50
163 81 2 ¤ 19.00
164 81 3 ¤ 34.00
165 82 1 ¤ 1.50
166 82 2 ¤ 7.50
167 82 3 ¤ 14.00
168 83 1

171 84 1 ¤ 3.00
172 84 2 ¤ 16.00
173 84 3 ¤ 30.00
174 85 1 ¤ 2.00
175 85 2 ¤ 10.50
176 85 3 ¤ 19.00
177 86 3 ¤ 2.00
178 86 2 ¤ 10.50
179 86 3 ¤ 19.00
180 87 1 ¤ 2.50
181 87 2 ¤ 13.50
182 87 3 ¤ 24.00
183 88 1 ¤ 3.00
184 88 2 ¤ 16.00
185 88 3 ¤ 30.00
Product ID Sales Unit
¤ 2

 2.0
¤ 2

 6.0
¤ 2

 8.0
¤ 2

 4.0
24.0
¤ 32.00
¤ 1.50
¤ 7.50
¤ 14.00
¤ 2.00
¤ 10.50
¤ 1

 9.0
¤ 2.50
¤ 13.50
¤

3.0
¤ 16.00
¤ 30.00
¤ 1

 5.0
¤ 1

7.0
¤ 3.50
¤ 34.00
¤ 4.00
ID

7 5 179 1
8 5 33 2
9 6 6 1
10 7 19 2
11 7 54 3
12 7 34 1
13 7 156 1
14 5 63 1
15 5 73 1
16 8 185 2
17 8 167 4
18 8 152 2
19 8 89 2
20 8 149 2
21 8 146 2
22 8 19 3
23 8 98 2
24 9 12 1
25 11 19 1
26 11 16 1
27 12 65 1
28 13 50 1
29 13 38 1
30 13 10 1
31 14 183 1
32 14 168 1
33 15 28 1
34 15 18 1
35 15 62 2
36 15 104 1
37 15 92 1
38 15 173 1
39 15 143 2
40 16 181 1
41 23 17 1
42 17 127 1
43 17 123 2
44 14 28 1
45 18 173 1
46 18 28 1
47 19 8 1
48 20 14 2
49 21 40 1
50 21 68 1
51 21 59 1
52 21 74 1
53 21 47 1
54 22 13 1
55 35 123 1
56 35 122 1
57 35 28 1
58 24 28 1
59 25 27 1
60 25 123 1
61 25 122 1
62 25 120 1
63 26 28 1
64 27 14 1
65 27 19 1
66 27 136 1
67 27 122 1
68 27 122 1
69 28 120 1
70 28 121 1
71 28 122 1
72 29 28 1
73 30 28 2
74 31 28 1
75 31 16 1
76 31 122 1
77 31 122 1
78 31 120 1
79 32 136 1
81 32 121 1
82 32 120 1
83 33 28 1
84 33 120 1
85 36 120 1
86 36 122 1
87 37 136 1
88 37 120 1
89 37 122 1
90 37 121 1
91 38 120 1
92 38 27 1
93 38 122 1
94 38 17 1
95 39 28 1
96 39 12 1
97 39 27 1
98 39 18 1
99 39 173 1
100 39 120 1
101 39 130 1
102 40 123 1
103 40 183 2
104 41 155 1
105 41 173 1
106 41 89 1
107 42 48 1
108 42 66 1
109 42 33 3
110 42 63 2
111 43 183 1
112 43 180 1
113 44 140 1
114 44 45 3
115 45 134 1
116 45 133 1
117 45 173 1
118 45 119 1
119 45 152 1
120 46 135 1
121 46 18 1
122 46 19 1
123 46 65 2
124 47 18 1
125 47 155 1
126 47 167 2
127 47 149 1
128 47 161 1
129 47 173 1
130 48 19 7
131 48 6 3
132 48 59 2
133 48 35 2
134 48 65 4
135 48 74 4
136 48 61 3
137 48 119 2
138 48 89 3
139 48 104 2
140 48 80 3
141 48 155 2
142 48 140 4
143 48 167 6
144 48 146 4
145 48 143 2
146 48 173 4
147 48 130 2
149 48 135 4
150 48 134 4
151 48 133 3
152 49 19 2
153 50 14 1
154 39 27 1
155 39 14 3
156 5 16 3
157 5 14 1
158 5 6 2
159 5 19 1
160 5 14 1
161 5 15 2
162 5 17 5
163 62 17 1
164 63 8 1
166 63 74 1
167 63 53 1
169 63 140 2
170 63 133 2
Order ID Menu Item ID Quantity
ID

Notes

5 44

6 136 true true

7 131 true false 12/4/13
8 145 true true

9 47 true false

10 38 true false

11 92 true true

12/15/13

12 38 true false

13 139 true true

12/16/13

14 130 true false

15 129 true true For a holiday party 12/17/13
16 124 true false 12/17/13
17 163 true false

18 96 true false

party

12/18/13

19 78 true false

12/18/13

20 153 true false 12/18/13
21 71 true true

22 176 true false

23 149 true false

24 96 true true

25 10 true true Christmas 12/23/13
26 100 true true

12/23/13

27 125 true true

12/23/13

28 104 true true

12/23/13

29 97 true true

12/23/13

30 101 true true

31 44 true true 12/24/13
32 121 true true 12/24/13
33 187 true true 12/24/13
34 92 true true 12/24/13
35 101 false false

12/24/13

36 106 true false 12/24/13
37 81 true false 12/23/13
38 1 true false 12/24/13
39 106 true true

12/24/13

40 82 true false

and

Pies by that point. Apologized and advised her to pre-order next Christmas.

12/24/13

41 111 true true

42 37 true false 12/30/13
43 57 true false 12/30/13
44 191 true false 12/30/13
45 117 true true For a NYE party

46 54 true false 12/31/13
47 146 true false 12/31/13
48 86 true true

12/31/13

49 118 true true 12/31/13
50 188 false false

51 150 false false

52 198 false false

53 194 false false 3/2/13
54 120 false false

55 119 false true

56 75 false false

57 197 false false

58 133 false false

59 72 false false 3/17/13
60 53 false false

61 208 false false

62 209 false false

63 37 true true

Customer ID Paid Pre Order Pickup Date
true false 12/4/13
For a birthday party– cake should read, “Happy Birthday, Daddy!” 12/9/13
For a reception at the J. Ikiba Gallery 12/10/13
12/14/13
12/15/13
For a holiday party
12/16/13
For a kindergarten party. Write, “Happy 6th Birthday, Matthew!” on the cake and draw a rabbit in icing next to the text.
12/17/13
12/18/13
For a

Christmas
Cake should read, “Congratulations, Yuki!”
For an office party 12/19/13
Extra icing 1/18/13
12/20/13
Decorate cake with the following names: “Edouard,” “Arnaud,” “Erwan,” “Celine,” and “Camille” 12/23/13
Add text, “Joyeaux Noël 2010”
Christmas- Write “Happy Birthday Jesus” on the

Carrot Cake
Christmas- Tie boxes up with ribbon
Christmas- write “Merry Christmas to All” on the cake.
Vary decorative details on the cakes– different colored flowers, placement of moss, etc 12/24/13
Christmas. Decorate Buche de Noel with red flowers and text, “Joyeux Noël et Bonne Année”
Apparently, he plans to eat most of this himself?! Maybe that was a joke…
Customer came in an hour before closing time and got angry that we were sold out of

Pecan Pumpkin
For a NYE party 12/30/13
12/31/13
For the Mayor’s NYE Gala– arrange on best platters and deliver. No extra charge for an order this big. Extra decoration, etc– we want this to look REALLY good.
1/4/13
3/2/13
3/3/13
3/4/13
3/12/13
3/10/13
3/11/13
3/17/13
3/15/13
3/14/13
Yes! You found me. Congratulations on building your first query! 🙂
For a St. Patrick’s Day party. Make everything we can green (green food coloring to cake and cookie dough, green filling in cream puffs) and add on green sprinkles where appropriate. 3/16/13
Product Types

Sales Unit

Cakes

8.0 1 8.0

Cakes

Single 5.0 1 5.0

Cakes

Single

1 12.0

Cakes Carrot Cake Single 8.0 1 8.0
Cakes

Single

1 18.0

Cakes

Single 2.0 1 2.0

Cakes

Single

1 1.0

Cakes

Single 1.0 1 1.0

Cakes

Single 6.0 1 6.0

Cakes

Single 2.0 1 2.0

Cakes

Single 4.0 1 4.0

Cakes

Single 4.0 1 4.0

Cakes

Single 1.0 1 1.0

Cookies

1.0 12 12.0

Cookies Butter Pecan Single 1.0 1 1.0
Cookies

Single 3.0 1 3.0

Cookies

One Dozen 1.0 12 12.0

Cookies Chocolate Banana Walnut Single 1.0 1 1.0
Cookies

1.0 6 6.0

Cookies Chocolate Chip One Dozen 2.0 12 24.0
Cookies Chocolate Chip Single 5.0 1 5.0
Cookies

One Dozen 3.0 12

Cookies

One Dozen 7.0 12

Cookies Fudge Brownie Single 3.0 1 3.0
Cookies

Half-Dozen 1.0 6 6.0

Cookies Ginger Shortbread One Dozen 5.0 12

Cookies

One Dozen 1.0 12 12.0

Cookies

Half-Dozen 1.0 6 6.0

Cookies

One Dozen 1.0 12 12.0

Cookies Snickerdoodle Single 3.0 1 3.0
Cookies

Half-Dozen 3.0 6 18.0

Cookies White Chocolate Macademia Nut One Dozen 2.0 12 24.0
Cupcakes

One Dozen 3.0 12 36.0

Cupcakes

One Dozen 6.0 12

Cupcakes Carrot Cake One Dozen 1.0 12 12.0
Cupcakes

One Dozen 3.0 12 36.0

Cupcakes

One Dozen 3.0 12 36.0

Cupcakes

One Dozen 2.0 12 24.0

Pastries

One Dozen 2.0 12 24.0

Pastries Almond Croissant Single 4.0 1 4.0
Pastries

One Dozen 1.0 12 12.0

Pastries

Half-Dozen 1.0 6 6.0

Pastries Chocolate Croissant Single 1.0 1 1.0
Pastries

One Dozen 4.0 12

Pastries

One Dozen 12.0 12

Pastries

One Dozen 5.0 12 60.0

Pastries

Single 1.0 1 1.0

Pastries

One Dozen 4.0 12 48.0

Pastries

One Dozen 6.0 12 72.0

Pastries

Tartlette

One Dozen 3.0 12 36.0

Pastries

Single 1.0 1 1.0

Pastries

One Dozen 1.0 12 12.0

Pastries

One Dozen 3.0 12 36.0

Pastries

One Dozen

12

Pies

Single 5.0 1 5.0

Pies

Single 3.0 1 3.0

Pies

Single 5.0 1 5.0

Pies

Single 1.0 1 1.0

Pies

Single 5.0 1 5.0

Pies Key Lime Single 4.0 1 4.0
Pies

Single 3.0 1 3.0

Pies Pecan Single 10.0 1 10.0
Pies Pumpkin Single 9.0 1 9.0
Pies

Single 3.0 1 3.0

Product Name # of Sales Unit Sold Value of Sales Unit Actual # Sold
Black Forest Single
Black Walnut
Buche de Noel (Christmas Cake)- Winter 12.0
Cheesecake 18.0
Coconut
Cookies n’ Cream 1.0
French Vanilla
Fudge Chocolate
German Chocolate
Gingerbread – Winter
Italian Rum
Red Velvet
Butter Pecan One Dozen
Butterscotch
Chocolate Banana Walnut
Chocolate Chip Half-Dozen
Cranberry Walnut 36.0
Fudge Brownie 84.0
Ginger Shortbread
60.0
Oatmeal Raisin
Peanut Butter
Snickerdoodle
White Chocolate Macademia Nut
Candy Cane- Winter
Caramel Mocha Latte 72.0
Chocolate Amaretto
French french vanilla
Pineapple Coconut
Almond Croissant
Brownies
Chocolate Croissant
Chocolate Mousse Cup 48.0
Chocolate Strawberries 144.0
Cream Puffs
Crème Brulee
Éclair
Fruit Tartlette
Key Lime
Mango Mousse Cup
Mini Cheesecake, Plain
Rasberry Chocolate Tartlette
Tiramisu 10.0 120.0
Apple
Apple Crumb
Chocolate Chess
Coconut Cream
French Silk
Peanut Butter Chocolate
Sweet Potato
ID

Product Name

8 1 Fudge Chocolate

9 2

10 2 French Vanilla

11 2

12 2 Cookies n’ Cream

13 2

14 2 German Chocolate

15 2 Red Velvet

16 2 Carrot Cake

17 2 Coconut

18 2 Black Walnut

19 2 Black Forest

20 2 Italian Rum

21 2 Cheesecake

22 2

23 2

24 2

– Summer

25 2

26 2

27 2

28 2

29 2 Gingerbread – Winter

30 2 Buche de Noel (Christmas Cake)- Winter

31 3

32 3 French french vanilla

33 3 Cookies n’ Cream

34 3

35 3 Caramel Mocha Latte

36 3 Carrot Cake

37 3 Red Velvet

38 3 Pineapple Coconut

39 3

40 3 Chocolate Amaretto

41 3

42 3

43 3

44 3

45 3 Candy Cane- Winter

46 1

47 1 Chocolate Chip

58 1 Oatmeal Raisin

59 1 Peanut Butter

60 1

61 1 Snickerdoodle

62 1 Butter Pecan

63 1

64 1 Butterscotch

65 1 Cranberry Walnut

66 1 White Chocolate Macademia Nut

67 1 Fudge Brownie

68 1 Chocolate Banana Walnut

69 1

70 1 Ginger Shortbread

71 5

72 5

73 5 Cream Puffs

74 5 Éclair

75 5 Fruit Tartlette

76 5

77 5 Rasberry Chocolate Tartlette

78 5 Chocolate Mousse Cup

79 5 Mango Mousse Cup

80 5 Mini Cheesecake, Plain

81 5

82 5 Chocolate Strawberries

83 5 Crème Brulee

84 5 Tiramisu

85 5

86 5 Brownies

87 5 Chocolate Croissant

88 5 Almond Croissant

89 4 Pumpkin

90 4 Sweet Potato

91 4 Pecan

92 4 Apple

93 4

94 4

95 4 Blueberry

96 4 Coconut Cream

97 4

98 4 Strawberry Cream

99 4 Peanut Butter Chocolate

100 4

101 4

102 4 Key Lime

103 4 Chocolate Chess

104 4 French Silk

105 4 Apple Crumb

Category ID Description
So rich and heavy with chocolate, you’ll need someone to help you carry it home. No, really.
Fudge Marble The cake that dares ask the question: what if marble were made of three types of chocolate? The answer… delicious.
Oo la la! Some people might say this cake has a certain je ne sais quoi… but we “sais quoi”– lots of vanilla.
Strawberry Swirl A dizzying swirl of strawberries and crème. Hold on tight!
Like dipping oreos and milk, but a cake, and not at all soggy.
Lemon A simple classic– sweet and sour.
“Chocolate” in German is “schokolade.” You don’t have to be able to say that to enjoy this cake.
Your grandma’s favorite cake, topped with rich buttercream icing.
Orange and spicy. Ask your doctor if you can count it as a serving of vegetables.
Ever tried cracking a coconut? It’s hard! Better stick with our moist Coconut Cake– all you need is your fork.
Nutty, dark, and delicious. You’ll fall in love with this delectable cake.
This is a Black Forest you’ll want to get lost in. Rich, moist, and not at all spooky.
Try as we might, it’s impossible to get drunk from our Italian Rum cake. So go ahead and eat the whole thing.
Moist, rich and dreamily creamy. Every biteful is sinfully delicious.
Cheesecake, strawberry Our NY-style classic, but now you can count it as a fruit serving.
Easter Creme Cake- Spring Like a Chocolate Crème Egg, except a three layer cake. Topped with icing bunnies and marshmallow chicks.
Lemon

Blueberry Summer sunshine, ripe blueberries and sugary lemonade. Takes you back to the good ol’ days.
Triple Berry Shortcake – Summer Strawberries, raspberries, and blueberries. May turn your lips and teeth purple, but probably worth it.
Hummingbird – Summer Made out of actual hummingbirds. No, not really. But this pineapple and banana cake may attract a few.
Pumpkin Spice – Autumn Spicy and sweet– the best thing about Autumn. Bring it to Thanksgiving, or kick off the holiday season by eating the whole thing yourself.
Apple Spice – Autumn Much easier to eat than bobbing for apples, but the caramel icing will still leave you sticky.
A bite of this cake will give you a great deal more pleasure than biting the limbs off a gingerbread man!
A French classic. Its name means “Yule Log.” We weren’t sure why you’d want to eat a log either, until we tasted this one.
Strawberry Cream Our strawberriest cupcake. We threw some cream flavor in there, too.
The French don’t have a word for “cupcake.” We know, that’s sad. This classic French Vanilla is what they’d crave if they had any idea what they were missing.
Rich chocolate cookies! Creamy, creamy cream! It’s a lot to pack in one cupcake, but we did it somehow.
Lemon Drop Lemon cake, covered with lemony icing, and a little lemon drop. We can even serve it on a little yellow plate, if you want.
Love coffee, but looking for a cakier cup to start your morning? This sweet confection is your best bet.
One whole carrot in each cupcake. Lots of spices, too. Topped with cream cheese icing.
Red velvet: the fabric magicians use for their capes. It’s also your new favorite cupcake. Topped with buttercream icing.
Tropical and bright. The only cupcake you need when you’re stuck on a Desert Island.
Orange Creamsicle Like Orange Creamsicles but don’t like cold? Finally, a solution. This cupcake won’t melt, either.
Chocolate and almonds– delizioso!
Peanut Butter Cup We wanted a peanut butter cup that was truly cup-sized. Also, we wanted it to be a cake. This cupcake meets both those standards.
White Chocolate Raspberry Pink and white just may be our favorite colors. Moist raspberry cake and rich white chocolate frosting.
S’mores – Summer The perfect cupcake for a summer evening. Please don’t drop it in the fire.
Pumpkin Spice- Autumn Pumpkin and autumn spices, topped with cream cheese frosting. Hog these for yourselves while the kids carve the real pumpkin.
Sweet peppermint with a light buttercream icing. Too good to hang on the tree.
Sugar Soft, moist and simply delightful.
Overloaded with chocolate chips, and a little bit of cookie too.
A new take on the afterschool classic. Lightly toasted oatmeal and artisanal raisins.
Made using only the finest peanut butter. Really.
Cranberry Orange Some flavors just work. Don’t try to figure it out.
1/3 snicker, 1/3 doodle, and the other third sugar, cinnamon, and butter.
Rich, crumbly, and nutty. Did we mention buttery?
Lemon Sugar The sweet side of tart. You can’t eat just one.
Like a piece of candy, but a cookie. Also, tastier.
Maine cranberries, and walnuts from a walnut tree. Yum.
Ooo-la-la and addictive. Take our word for it.
Thick, rich, and just chewy enough. Your mouth may get stuck shut, but you probably won’t mind.
The taste of banana bread and chocolate all in one delicious cookie.
White Chocolate Pumpkin Pecan White chocolate pumpkin? Exactly what it sounds like. Go with it.
A classic with a hint of spice. Melt-in-your mouth delicious.
Cannoli, Plain An Italian classic. Rich and creamy vanilla filling with a flakey pastry shell.
Cannoli, Chocolate Chip Our Italian favorite, now with chocolate chips. There is literally nothing not to love about this.
Like a cloud made of dough and cream. Oh, and filled with vanilla.
“Éclair” means “lightning” in French. I know, we don’t get it either. Don’t think about it– just enjoy this cream-filled pastry.
A mini-pie filled with seasonal fruit and glazed with sugar. Why aren’t you eating one yet?
Key Lime Tartlette A snack sized version of our Key Lime pie. We’re sorry if this ruins your diet.
A teeny-tiny Raspberry Chocolate Tarte. You can eat one, but you can eat more than one, too.
A cup of our delicate chocolate mousse. Topped with a sprig of mint. Also available in french vanilla.
A creamy, delicious, tropical delight.
A single serving version of our classic cheesecake. But we won’t judge if you eat more than one.
Mini Cheesecake, Strawberry A single serving version of our classic cheesecake, topped with a strawberry glaze and a single strawberry.
Perfectly ripe strawberries dipped in fine chocolate. Go ahead and indulge.
The French classic , served fresh. Order-in only.
Coffee-soaked cake, marscarpone, liquor, and cocoa. We needn’t say more.
Lemon Bar A layer of tart lemon on top of a sweet bar cookie. Perfect for tea time.
An American classic. Every brownie is an “edge” brownie.
Pain au chocolat. A croissant wrapped around a sweet piece of chocolate.
How can you make a buttery croissant even richer? Easy! Fill it with almond paste, and top it with sugar and roasted almonds.
Classic pumpkin pie with graham cracker crust. Our special recipe uses a dash of bourbon for extra flavor.
A southern classic you won’t be able to keep your fingers off of.
A classic, updated to be a little healthier. Don’t worry, there’s no lack of flavor in this corn-syrup-free favorite.
As American as… never mind. Made from local apples, and coated with our special sugar glaze.
Peach Thick sliced peaches in a buttery crust. Tastes like a Georgia summer day.
Cherry Large, ripe cherries and a delicate crust. Perfect with a dollop of whipped cream.
This pie will turn your lips purple, but we guarentee you won’t mind. Sweet and tart.
The classic pie-in-the-face pie, but we think throwing it would be a waste. Sweet and creamy.
Banana Cream No longer will you have to choose between banana pudding and pie: this pie has it all. A new take on a Southern classic. Serve warm.
Sort of like a milkshake, but with a crust. Dreamily satisfying.
Like a peanut butter cup with a crust. Yum!
Blackberry A summer favorite available year-round. You can just imagine it sitting on a windowsill.
Lemon Meringue A delicate and delightful classic.
Tart and rich. Made with real key limes. A tropical vacation in pie form.
Chocolate lovers have met their match. Checkmate.
The title might be French, but this creamy chocolate pie topped with a layer of cool, sweet whipped cream is pure yin/yang.
Our apple pie with special crumb-cake topping. You’ll eat every crumb, we promise.
ID Product Name

1 Single 1
2 Half-Dozen 6
3 One Dozen 12
SalesUnit Val

SELECT [Customers].[ID], [Customers].[Last Name], [Customers].[First Name]
FROM Customers;
SELECT Customers.ID, Customers.[Last Name], Customers.[First Name], Customers.[Phone Number], *
FROM Customers
ORDER BY Customers.[Last Name], Customers.[First Name], Customers.[Phone Number];
PARAMETERS __ID Value;
SELECT DISTINCTROW *
FROM [Order Items Query] AS Orders
WHERE ([__ID] = [Order ID]);
SELECT DISTINCTROW *
FROM Customers;
SELECT DISTINCTROW *
FROM [Orders Table];
SELECT [Categories].[Product Types], [Products Table].[Product Name] AS [Products Table_Product Name], [Products Table].[Description], [Sales Unit].[Product Name] AS [Sales Unit_Product Name], [Menu Items].[Price], [Categories].[ID] AS Categories_ID, [Products Table].[ID] AS [Products Table_ID]
FROM [Sales Unit] INNER JOIN ((Categories INNER JOIN [Products Table] ON [Categories].[ID] =[Products Table].[Category ID]) INNER JOIN [Menu Items] ON [Products Table].[ID] =[Menu Items].[Product ID]) ON [Sales Unit].[ID] =[Menu Items].[Sales Unit ID];
SELECT [Orders Query].*
FROM [Orders Query]
WHERE (([Pickup Date] Not In (#1/4/2011#,#1/18/2011#,#12/16/2011#,#12/17/2011#)))
ORDER BY [Orders Query].[Last Name], [Orders Query].[Zip Code] DESC;
SELECT Categories.[Product Types], [Products Table].[Product Name], [Sales Unit].[Product Name], Sum([Order Items].Quantity) AS SumOfQuantity
FROM Categories RIGHT JOIN ([Sales Unit] RIGHT JOIN ([Products Table] RIGHT JOIN ([Menu Items] RIGHT JOIN [Order Items] ON [Menu Items].ID = [Order Items].[Menu Item ID]) ON [Products Table].ID = [Menu Items].[Product ID]) ON [Sales Unit].ID = [Menu Items].[Sales Unit ID]) ON Categories.ID = [Products Table].[Category ID]
GROUP BY Categories.[Product Types], [Products Table].[Product Name], [Sales Unit].[Product Name]
HAVING (((Categories.[Product Types])=”Cakes” Or (Categories.[Product Types])=”Pies”));
SELECT Categories.[Product Types], [Products Table].[Product Name], [Sales Unit].[Product Name], Sum([Order Items].Quantity) AS SumOfQuantity
FROM Categories RIGHT JOIN ([Sales Unit] RIGHT JOIN ([Products Table] RIGHT JOIN ([Menu Items] RIGHT JOIN [Order Items] ON [Menu Items].ID = [Order Items].[Menu Item ID]) ON [Products Table].ID = [Menu Items].[Product ID]) ON [Sales Unit].ID = [Menu Items].[Sales Unit ID]) ON Categories.ID = [Products Table].[Category ID]
GROUP BY Categories.[Product Types], [Products Table].[Product Name], [Sales Unit].[Product Name]
HAVING (((Categories.[Product Types])=”Cookies”))
ORDER BY Sum([Order Items].Quantity) DESC;
SELECT Customers.[First Name], Customers.[Last Name], Count([Orders Table].[Pickup Date]) AS [CountOfPickup Date]
FROM Customers RIGHT JOIN [Orders Table] ON Customers.ID = [Orders Table].[Customer ID]
GROUP BY Customers.[First Name], Customers.[Last Name];
SELECT Customers.[First Name], Customers.[Last Name], Customers.[Street Address], Customers.City, Customers.State, Customers.[Zip Code]
FROM Customers
WHERE (((Customers.City)=”Raleigh”)) OR (((Customers.[Zip Code])=”27513″));
SELECT Customers.[First Name], Customers.[Last Name], Customers.[Street Address], Customers.City, Customers.State, Customers.[Zip Code], [Orders Table].ID, Customers.[Phone Number]
FROM Customers RIGHT JOIN [Orders Table] ON Customers.ID = [Orders Table].[Customer ID]
WHERE (((Customers.City) Not In (“Raleigh”)) AND ((Customers.[Phone Number]) Like (“919*”)));
SELECT [Orders Query].[Pickup Date], [Orders Query].[First Name], [Orders Query].[Last Name], [Orders Query].[Phone Number], [Orders Query].Paid
FROM [Orders Query]
WHERE ((([Orders Query].[Pickup Date]) Between #12/1/2010# And #12/31/2010#))
ORDER BY [Orders Query].[Pickup Date];
SELECT Customers.[First Name], Customers.[Last Name], Customers.[Street Address], Customers.[City], Customers.[State], Customers.[Zip Code], Customers.[Email], Customers.[Phone Number]
FROM Customers
WHERE (((Customers.[First Name]) In (SELECT [First Name] FROM [Customers] As Tmp GROUP BY [First Name],[Last Name] HAVING Count(*)>1 And [Last Name] = [Customers].[Last Name])))
ORDER BY Customers.[First Name], Customers.[Last Name];
SELECT Categories.[Product Types], [Products Table].[Product Name], [Sales Unit].[Product Name], [Order Items].Quantity
FROM [Sales Unit] RIGHT JOIN (Categories RIGHT JOIN (([Products Table] RIGHT JOIN [Menu Items] ON [Products Table].[ID] = [Menu Items].[Product ID]) RIGHT JOIN [Order Items] ON [Menu Items].[ID] = [Order Items].[Menu Item ID]) ON Categories.ID = [Products Table].[Category ID]) ON [Sales Unit].ID = [Menu Items].[Sales Unit ID];
SELECT [Menu Items].ID, (Categories.[Product Types] & ” – ” & [Products Table].[Product Name] & ” – $” & [Menu Items].Price & “/” & [Sales Unit].[Product Name]) AS Item
FROM [Sales Unit] INNER JOIN ((Categories INNER JOIN [Products Table] ON Categories.ID=[Products Table].[Category ID]) INNER JOIN [Menu Items] ON [Products Table].ID=[Menu Items].[Product ID]) ON [Sales Unit].[ID] = [Menu Items].[Sales Unit ID];
SELECT [Order Items].[Order ID], Categories.[Product Types] AS Category, [Products Table].[Product Name] AS Product, [Order Items].Quantity, [Sales Unit].[Product Name] AS [“Unit”], [Menu Items].Price, ([Order Items].[Quantity]*[Menu Items].[Price]) AS Subtotal
FROM ((Categories INNER JOIN [Products Table] ON Categories.ID=[Products Table].[Category ID]) INNER JOIN ([Sales Unit] INNER JOIN [Menu Items] ON [Sales Unit].[ID] = [Menu Items].[Sales Unit ID]) ON [Products Table].ID=[Menu Items].[Product ID]) INNER JOIN [Order Items] ON [Menu Items].[ID] = [Order Items].[Menu Item ID];
SELECT Customers.[Last Name], Customers.[First Name], Customers.[Phone Number], [Orders Table].Paid, [Orders Table].[Pickup Date], Customers.[Zip Code]
FROM Customers RIGHT JOIN [Orders Table] ON Customers.ID = [Orders Table].[Customer ID];
SELECT Customers.[Last Name], Customers.[First Name], Customers.[Phone Number], [Orders Table].Paid, [Orders Table].[Pickup Date], Customers.[Zip Code]
FROM Customers RIGHT JOIN [Orders Table] ON Customers.ID = [Orders Table].[Customer ID]
WHERE ((([Orders Table].[Pickup Date]) Between [Enter the start date:] And [Enter the ending date:]));
SELECT [Products Table].ID, Categories.[Product Types] & ” – ” & [Products Table].[Product Name] & ” – ” & [Products Table].Description AS Product
FROM [Products Table] LEFT JOIN Categories ON Categories.ID=[Products Table].[Category ID];
SELECT DISTINCTROW *
FROM [Orders Table];

Exercise 2

1. Create an Access database based on this Entity Relationship Diagram. Populate each table with at least five records (use records, rather than typing random characters into each field).

2. Create table relationships as shown in the ERD above.

3. Create a query that will display the

Appointment

date, the patient information the bill status and the amount. (You may or may not need to use all four tables.)

a. Run the query and display the results. Make a screen shot of the result, and include in your screen shot the lower right-hand corner of your screen which shows the system time and date.

b. Remove the relationship connections.

c. Run the query again.

d. What happens? Write a 1 – 2 paragraph discussion on the results, and explain the advantage of a relational database.

Write your answer to Question 3d, and upload it, along with your Access .accdb file.

Appointment

Bill

DoctorPatient

Appointment Date

PK

Appointment Time

Appointment duaration

Bill Number

PK

Bill date

Bill Amount

Doctor Id

PK

Doctor First Name

Doctor Last name

Patient Id

PK

Patient First Name

Patient Last Name

Appointment Reason

Doctor Id

FK

Patient Id
FK
Bill Number
FK

Bill status

Are you stuck with your online class?
Get help from our team of writers!
Order Today