NVCC Excel Database Exercises Project

Description

Follow through the video lectures and replicate the database exercises demonstrated in the videos.I have attach the link to the video
https://youtu.be/pxZNfZzaNZs

2 attachments

Slide 1 of 2

attachment_1

attachment_1
attachment_2

attachment_2

Unformatted Attachment Preview

ProdID
P110
P111
P112
P113
P114
P115
P116
P117
P118
P119
P120
P121
P122
P123
P124
P125
P126
P127
P128
P129
P130
P131
P132
P133
P134
P135
P136
P137
P138
P139
P140
P141
P142
P143
P144
P145
P146
P147
P148
P149
P150
P151
P152
P153
P154
ProductName
Chai
Syrup
Cajun Seasoning
Olive Oil
Boysenberry Spread
Dried Pears
Curry Sauce
Walnuts
Fruit Cocktail
Chocolate Biscuits Mix
Marmalade
Scones
Beer
Crab Meat
Clam Chowder
Coffee
Chocolate
Dried Apples
Long Grain Rice
Gnocchi
Ravioli
Hot Pepper Sauce
Tomato Sauce
Mozzarella
Almonds
Mustard
Dried Plums
Green Tea
Granola
Potato Chips
Brownie Mix
Cake Mix
Tea
Pears
Peaches
Pineapple
Cherry Pie Filling
Green Beans
Corn
Peas
Tuna Fish
Smoked Salmon
Hot Cereal
Vegetable Soup
Chicken Soup
UnitCost
ListPrice
QtyPerUnit
13,50
18,00 10 boxes x 20 bags
7,50
10,00 12 – 550 ml bottles
16,50
22,00 48 – 6 oz jars
16,01
21,35 36 boxes
18,75
25,00 12 – 8 oz jars
22,50
30,00 12 – 1 lb pkgs.
30,00
40,00 12 – 12 oz jars
17,44
23,25 40 – 100 g pkgs.
29,25
39,00 15.25 OZ
6,90
9,20 10 boxes x 12 pieces
60,75
81,00 30 gift boxes
7,50
10,00 24 pkgs. x 4 pieces
10,50
14,00 24 – 12 oz bottles
13,80
18,40 24 – 4 oz tins
7,24
9,65 12 – 12 oz cans
34,50
46,00 16 – 500 g tins
9,56
12,75 10 pkgs
39,75
53,00 50 – 300 g pkgs.
5,25
7,00 16 – 2 kg boxes
28,50
38,00 24 – 250 g pkgs.
14,63
19,50 24 – 250 g pkgs.
15,79
21,05 32 – 8 oz bottles
12,75
17,00 24 – 8 oz jars
26,10
34,80 24 – 200 g pkgs.
7,50
10,00 5 kg pkg.
9,75
13,00 12 boxes
3,00
3,50 1 lb bag
2,00
2,99 20 bags per box
2,00
4,00
0,50
1,80
9,00
12,49 3 boxes
10,50
15,99 4 boxes
2,00
4,00 100 count per box
1,00
1,30 15.25 OZ
1,00
1,50 15.25 OZ
1,00
1,80 15.25 OZ
1,00
2,00 15.25 OZ
1,00
1,20 14.5 OZ
1,00
1,20 14.5 OZ
1,00
1,50 14.5 OZ
0,50
2,00 5 oz
2,00
4,00 5 oz
3,00
5,00 14.5 OZ
1,00
1,89 14.5 OZ
1,00
1,95 14.5 OZ
MinimumReorderQty ReorderLevel
SupID
80
10
S001
25
25
S002
10
10
S003
10
10
S004
25
25
S005
10
10
S001
10
10
S002
10
10
S003
10
10
S004
5
5
S005
10
10
S001
5
5
S002
15
15
S003
30
30
S004
10
10
S005
25
25
S001
25
25
S002
10
10
S003
25
25
S004
30
30
S005
20
20
S001
10
10
S002
20
20
S003
10
10
S004
5
5
S005
15
15
S001
25
50
S002
25
100
S003
0
20
S004
0
30
S005
5
10
S001
5
10
S002
0
20
S003
0
10
S004
0
10
S005
0
10
S001
0
10
S002
0
10
S003
15
10
S004
0
10
S005
0
30
S001
0
30
S002
0
50
S003
0
100
S004
0
100
S005

Purchase answer to see full
attachment

Explanation & Answer:

1 Project

User generated content is uploaded by users for the purposes of learning and should be used following our honor code & terms of service.



^{Have a similar assignment? "Place an order for your assignment and have exceptional work written by our team of experts, guaranteeing you A results."}

Our Service Charter

1. Professional & Expert Writers: Essay Noon only hires the best. Our writers are specially selected and recruited, after which they undergo further training to perfect their skills for specialization purposes. Moreover, our writers are holders of masters and Ph.D. degrees. They have impressive academic records, besides being native English speakers.

2. Top Quality Papers: Our customers are always guaranteed of papers that exceed their expectations. All our writers have +5 years of experience. This implies that all papers are written by individuals who are experts in their fields. In addition, the quality team reviews all the papers before sending them to the customers.

3. Plagiarism-Free Papers: All papers provided by Essay Noon are written from scratch. Appropriate referencing and citation of key information are followed. Plagiarism checkers are used by the Quality assurance team and our editors just to double-check that there are no instances of plagiarism.

4. Timely Delivery: Time wasted is equivalent to a failed dedication and commitment. Essay Noon are known for the timely delivery of any pending customer orders. Customers are well informed of the progress of their papers to ensure they keep track of what the writer is providing before the final draft is sent for grading.

5. Affordable Prices: Our prices are fairly structured to fit in all groups. Any customer willing to place their assignments with us can do so at very affordable prices. In addition, our customers enjoy regular discounts and bonuses.

6. 24/7 Customer Support: At Essay Noon, we have put in place a team of experts who answer all customer inquiries promptly. The best part is the ever-availability of the team. Customers can make inquiries anytime.