USA: +1(669)289-8683 
Sign in
I have attached the access file that is requred to complete this current assignment. Also attached is a screen shot of the pages that give step by step instructions on how to complete the assignment.
This is the what the teacher had typed :
Follow the “Instructions” steps after the “Problem” definition. Submit the database file (*.accdb) for this completed project.
Please let me know if there is any missing information that you need or any questions you need from me.
Thank you so much!!
| Item Number | Description | on hand | cost | selling price | vendor code | ||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3 | 6 | Air deflector | 8 | ¤ | 5 | 4 | ¤ 5. | 9 | AS | ||||||||||||
| 36 | 7 | Energy Booklet | 2 | ¤ 2.70 | ¤ 2.99 | JM | |||||||||||||||
| 4553 | Energy Savings Kit | 7.0 | ¤ 42.75 | ¤ 43.25 | |||||||||||||||||
| 4573 | Faucet Aerator | 20.0 | ¤ 0.89 | ¤ 0.99 | SD | ||||||||||||||||
| 4583 | Flourescent Light Bulb | 1 | ¤ 4.50 | ¤ 4.75 | |||||||||||||||||
| 5923 | Low Flow Shoer Head | 11 | ¤ 8.75 | ¤ 8.99 | |||||||||||||||||
| 6185 | Luminescent Night Light | 12 | ¤ 3.75 | ||||||||||||||||||
| 6234 | Programmable Thermostat | 3.0 | ¤ 34.25 | ¤ 36.99 | |||||||||||||||||
| 6345 | Rain Guage | 16.0 | ¤ 2.89 | ¤ 3. | 15 | ||||||||||||||||
| 7123 | Retractable Clothesline | 10 | ¤ | 13 | ¤ 13.99 | ||||||||||||||||
| 7934 | Shower Timer | 15.0 | ¤ 2.45 | ||||||||||||||||||
| 8136 | Smoke Detector | ¤ 6.10 | ¤ 6.50 | ||||||||||||||||||
| 8344 | Toilet Tank Water Saver | ¤ 3.35 | ¤ 3.50 | ||||||||||||||||||
| 8590 | Water Conservation Kit | ¤ 13.45 | |||||||||||||||||||
| 9450 | Windows Insulator Kit | ¤ 4.95 | ¤ 5.25 |
| ID | Vendor Name | Telephone number | |||||||
|---|---|---|---|---|---|---|---|---|---|
| Asterman Industries | 808-555-7641 | ||||||||
| JMZ Technologies | 517-555-3853 | ||||||||
| Scryps Distributors | 610-555-8741 | ||||||||
| 14 | |||||||||
SELECT DISTINCTROW *
FROM [Item Table];
SELECT [Item Table].[Item Number], [Item Table].Description, [Item Table].cost, [Item Table].[selling price], [Item Table].[vendor code]
FROM [Item Table];
SELECT [Item Table].[Item Number], [Item Table].Description, [Item Table].cost, [Item Table].[selling price], [Item Table].[vendor code]
FROM [Item Table]
WHERE ((([Item Table].[vendor code])=”SD”));
Excel Project 2 pages
Walburg Energy Alternatives.accdb
Item Number Description on hand cost selling price vendor code
3663 Air deflector 8.0 ¤ 5.45 ¤ 5.99 AS
3673 Energy Booklet 25.0 ¤ 2.70 ¤ 2.99 JM
4553 Energy Savings Kit 7.0 ¤ 42.75 ¤ 43.25 AS
4573 Faucet Aerator 20.0 ¤ 0.89 ¤ 0.99 SD
4583 Flourescent Light Bulb 18.0 ¤ 4.50 ¤ 4.75 JM
5923 Low Flow Shoer Head 11.0 ¤ 8.75 ¤ 8.99 SD
6185 Luminescent Night Light 12.0 ¤ 3.75 ¤ 4.50 JM
6234 Programmable Thermostat 3.0 ¤ 34.25 ¤ 36.99 AS
6345 Rain Guage 16.0 ¤ 2.89 ¤ 3.15 SD
7123 Retractable Clothesline 10.0 ¤ 13.25 ¤ 13.99 JM
7934 Shower Timer 15.0 ¤ 2.45 ¤ 2.99 SD
8136 Smoke Detector 10.0 ¤ 6.10 ¤ 6.50 AS
8344 Toilet Tank Water Saver 18.0 ¤ 3.35 ¤ 3.50 SD
8590 Water Conservation Kit 8.0 ¤ 13.45 ¤ 13.99 JM
9450 Windows Insulator Kit 10.0 ¤ 4.95 ¤ 5.25 AS
ID vendor code Vendor Name Telephone number
1 AS Asterman Industries 808-555-7641
2 JM JMZ Technologies 517-555-3853
3 AS Asterman Industries 808-555-7641
4 SD Scryps Distributors 610-555-8741
5 JM JMZ Technologies 517-555-3853
6 SD Scryps Distributors 610-555-8741
7 JM JMZ Technologies 517-555-3853
8 AS Asterman Industries 808-555-7641
9 SD Scryps Distributors 610-555-8741
10 JM JMZ Technologies 517-555-3853
11 SD Scryps Distributors 610-555-8741
12 AS Asterman Industries 808-555-7641
13 SD Scryps Distributors 610-555-8741
14 JM JMZ Technologies 517-555-3853
15 AS Asterman Industries 808-555-7641
SELECT DISTINCTROW *
FROM [Item Table];
SELECT [Item Table].[Item Number], [Item Table].Description, [Item Table].cost, [Item Table].[selling price], [Item Table].[vendor code]
FROM [Item Table];
SELECT [Item Table].[Item Number], [Item Table].Description, [Item Table].cost, [Item Table].[selling price], [Item Table].[vendor code]
FROM [Item Table]
WHERE ((([Item Table].[vendor code])=”SD”));
