Microsoft Access Labs

profileWaqas Ahmed
nvntory.xls
Home>Computer Science homework help>Microsoft Access Labs

Sheet1

CODE TYPE DESCRIPTION COST PRICE ON HAND
1010 chair Lazy Boy Recliner 150 210 2
1020 lamp Brass, Table 50 70 10
1030 sofa Deluxe 700 980 1
1040 table Nightstand 75 105 20
1050 desk Rolltop 200 280 5
1060 bed King, Wood Finish 300 420 2
1070 dresser Standup, 5 drawer 300 420 3
2010 chair Straight Back 45 63 25
2020 lamp Chandelier 90 126 5
2030 sofa Love Seat 120 168 4
2040 table Dining Room, Deluxe 500 700 8
2050 desk with Glass Cabinet 150 210 0
2060 bed Queen, Wood Finish 250 350 5
2070 dresser Waist High, Double 250 350 3
3010 chair Rocking 30 42 15
3020 lamp Brass, Stand Up 75 105 12
3030 sofa Hide-a-bed 200 280 6
3040 table Coffee, Wood Finish 100 140 7
3050 desk Professional 150 210 4
3060 bed Single, Wood Finish 225 315 20
3070 dresser Waist High, Single 175 245 9
4010 chair Living Room 175 245 11
4020 lamp Table 25 35 30
4030 sofa Large Corner Unit 300 420 2
4040 table End, for Corner Unit 150 210 2
4050 desk Corner 250 350 3
4060 bed Trundle 120 168 3
4070 dresser Corner 300 420 1
5010 chair White Enamel 60 84 9
5020 lamp White Porcelain 80 112 9
5030 sofa White Love Seat 180 252 2
5040 table White Enamel 90 126 7
5050 desk White Enamel 150 210 6
5060 bed King, White Enamel 275 385 3
5070 dresser White Enamel 125 175 5
6010 chair Computer 50 70 22
6020 lamp Desk, Flourescent 40 56 40
6030 sofa Small Corner Unit 180 252 0
6040 table Computer 125 175 13
6050 desk Computer 150 210 8
6060 bed Bunk 120 168 6
6070 dresser Computer 100 140 15
7010 chair Kitchen 30 42 30
7020 lamp Tiffany 120 168 5
7030 sofa Bay Window 150 210 2
7040 table Kitchen 140 196 10
7050 desk Kitchen 75 105 6
7060 bed Fold-away 75 105 5
7070 dresser Colonial 160 224 3

Sheet2

Sheet3