Working with MS Access

profilep_patel359
Ch01Ex02-1.xlsx

Items

Item_No Item_Type CommRate SellingPrice DateConsigned Customer_ID
D34 Dress 0.25 $21.00 12/10/2010 W234
S43 Casual Shoes 0.15 $6.50 12/10/2010 W234
S44 Casual Shoes 0.15 $6.50 12/10/2010 W234
B367 Blouse 0.25 $7.50 01/06/2011 W234
SK235 Skirt 0.20 $16.00 01/06/2011 W234
SK236 Skirt 0.20 $16.00 01/06/2011 W234
DS256 Dress Shoes 0.30 $14.50 01/06/2011 W234
SW1987 Sweater 0.20 $8.00 01/06/2011 W234
SW1988 Sweater 0.20 $9.00 01/06/2011 W234
SW1989 Sweater 0.20 $8.00 01/06/2011 W234
DS266 Dress Shoes 0.30 $14.50 01/06/2011 W234
D36 Dress 0.25 $21.00 9/23/2010 B032
SU32 Suit 0.30 $36.00 9/23/2010 B032
H104 Hat 0.15 $7.25 9/23/2010 B032
H105 Hat 0.15 $7.25 9/23/2010 B032
B324 Blouse 0.25 $7.50 9/23/2010 B032
SW232 Sweater 0.20 $8.00 9/23/2010 B032
DS155 Dress Shoes 0.30 $21.00 9/23/2010 B032
SK189 Skirt 0.20 $16.00 9/23/2010 B032
SW1676 Sweater 0.20 $8.00 10/24/2010 B032
S41 Casual Shoes 0.15 $6.50 10/24/2010 B032
SU27 Suit 0.30 $36.00 10/24/2010 B032
S36 Casual Shoes 0.15 $6.50 6/23/2010 S029
S38 Casual Shoes 0.15 $6.50 6/23/2010 S029
H98 Hat 0.15 $7.25 6/23/2010 S029
H94 Hat 0.15 $7.25 6/23/2010 S029
S40 Casual Shoes 0.15 $6.50 6/23/2010 S029
SW209 Sweater 0.20 $8.00 6/23/2010 S029
D23 Dress 0.25 $21.00 6/23/2010 S029
D22 Dress 0.25 $21.00 6/23/2010 S029
SK217 Skirt 0.20 $16.00 4/1/2010 S029
SU18 Suit 0.30 $36.00 4/1/2010 S029
SW210 Sweater 0.20 $8.00 2/23/2010 S029
H23 Hat 0.15 $7.25 2/23/2010 S029