Microsoft Access assignment help

excel_project_2_pages.zip

Home >Information Systems homework help >Microsoft Access assignment help

Excel Project 2 pages.doc

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"));