WEEK 1

profileqkiii123
ch01ex02_solution1.accdb
Home>Business & Finance homework help>Management homework help>WEEK 1
Consignor ID Consignor Address Phone
B032 Judith Brown 234 Locust 454-4545
S029 Emily Owens 3200 Hwy 167 345-9809
W234 Shirley Crawford 2445 Cooper 555-3454
Item No Item Type Commission Rate Selling Price Date Consigned Consignor ID
B324 Blouse 0.25 ¤ 7.50 9/23/2010 B032
B367 Blouse 0.25 ¤ 7.50 01/06/2011 W234
D22 Dress 0.25 ¤ 21.00 6/23/2010 S029
D23 Dress 0.25 ¤ 21.00 6/23/2010 S029
D34 Dress 0.25 ¤ 21.00 40522 W234
D36 Dress 0.25 ¤ 21.00 9/23/2010 B032
DS155 Dress Shoes 0.3 ¤ 21.00 9/23/2010 B032
DS256 Dress Shoes 0.3 ¤ 14.50 01/06/2011 W234
DS266 Dress Shoes 0.3 ¤ 14.50 01/06/2011 W234
H104 Hat 0.15 ¤ 7.25 9/23/2010 B032
H105 Hat 0.15 ¤ 7.25 9/23/2010 B032
H23 Hat 0.15 ¤ 7.25 40232 S029
H94 Hat 0.15 ¤ 7.25 6/23/2010 S029
H98 Hat 0.15 ¤ 7.25 6/23/2010 S029
S36 Casual Shoes 0.15 ¤ 6.50 6/23/2010 S029
S38 Casual Shoes 0.15 ¤ 6.50 6/23/2010 S029
S40 Casual Shoes 0.15 ¤ 6.50 6/23/2010 S029
S41 Casual Shoes 0.15 ¤ 6.50 10/24/2010 B032
S43 Casual Shoes 0.15 ¤ 6.50 40522 W234
S44 Casual Shoes 0.15 ¤ 6.50 40522 W234
SK189 Skirt 0.2 ¤ 16.00 9/23/2010 B032
SK217 Skirt 0.2 ¤ 16.00 40269 S029
SK235 Skirt 0.2 ¤ 16.00 01/06/2011 W234
SK236 Skirt 0.2 ¤ 16.00 01/06/2011 W234
SU18 Suit 0.3 ¤ 36.00 40269 S029
SU27 Suit 0.3 ¤ 36.00 10/24/2010 B032
SU32 Suit 0.3 ¤ 36.00 9/23/2010 B032
SW1676 Sweater 0.2 ¤ 8.00 10/24/2010 B032
SW1987 Sweater 0.2 ¤ 8.00 01/06/2011 W234
SW1988 Sweater 0.2 ¤ 9.00 01/06/2011 W234
SW1989 Sweater 0.2 ¤ 8.00 01/06/2011 W234
SW209 Sweater 0.2 ¤ 8.00 6/23/2010 S029
SW210 Sweater 0.2 ¤ 8.00 40232 S029
SW232 Sweater 0.2 ¤ 8.00 9/23/2010 B032
SELECT Consignors.Consignor, Count(Items.[Item No]) AS [CountOfItem No], Sum(Items.[Selling Price]) AS [SumOfSelling Price], Sum(Items![Selling Price]*Items![Commission Rate]) AS Expr1 FROM Consignors INNER JOIN Items ON Consignors.[Consignor ID] = Items.[Consignor ID] GROUP BY Consignors.Consignor ORDER BY Consignors.Consignor;
SELECT Items.[Item Type], Count(Items.[Item No]) AS CountOfItem_No, Sum(Items.[Selling Price]) AS SumOfSellingPrice, Sum(Items![Selling Price]*(1-Items![Commission Rate])) AS Expr1, Sum(Items![Selling Price]*Items![Commission Rate]) AS Expr2 FROM Items GROUP BY Items.[Item Type];