Computer Science Home work!

profilekkyyrr
i01_pcpt_data1.accdb
ExpertID Firstname Lastname City
WA24-01 Whitney Holland Spokane
WA35-01 Kay Doyle Bellingham
WA51-01 Trevor Smith Seattle
WA71-01 Firstname Lastname Tacoma
CategoryID Merchandise
FSH Fishing
CMP Camping
RC Rock Climbing
WNT Winter Sports
ACT Action Sports
WTR Water Sports
TM Team Sports
RQT Racquet Sports
FNS Fitness
GLF Golf
APL Apparel
FTW Footwear
CategoryID QtrSales ExpertID
TM ¤ 87,022.00 WA24-01
FTW ¤ 43,856.00 WA24-01
CMP ¤ 118,282.00 WA35-01
ACT ¤ 104,493.00 WA35-01
FSH ¤ 45,487.00 WA24-01
APL ¤ 36,082.00 WA24-01
RC ¤ 229,164.00 WA24-01
RC ¤ 152,776.00 WA35-01
GLF ¤ 35,398.00 WA24-01
RQT ¤ 44,085.00 WA24-01
CMP ¤ 177,422.00 WA24-01
WNT ¤ 370,501.00 WA24-01
WNT ¤ 247,001.00 WA35-01
FNS ¤ 418,958.00 WA24-01
RQT ¤ 29,390.00 WA35-01
FSH ¤ 30,325.00 WA35-01
WTR ¤ 160,062.00 WA35-01
TM ¤ 58,015.00 WA35-01
ACT ¤ 156,740.00 WA24-01
WTR ¤ 240,093.00 WA24-01
FNS ¤ 279,305.00 WA35-01
GLF ¤ 23,599.00 WA35-01
APL ¤ 24,055.00 WA35-01
FTW ¤ 29,237.00 WA35-01
FSH ¤ 65,975.00 WA51-01
CMP ¤ 329,845.00 WA51-01
RC ¤ 433,328.00 WA51-01
WNT ¤ 716,002.00 WA51-01
ACT ¤ 288,479.00 WA51-01
WTR ¤ 455,185.00 WA51-01
TM ¤ 149,045.00 WA51-01
RQT ¤ 63,170.00 WA51-01
FNS ¤ 812,916.00 WA51-01
GLF ¤ 45,797.00 WA51-01
APL ¤ 47,164.00 WA51-01
FTW ¤ 62,712.00 WA51-01
FSH ¤ 40,162.00 WA71-01
CMP ¤ 84,141.00 WA71-01
RC ¤ 101,388.00 WA71-01
WNT ¤ 148,500.00 WA71-01
ACT ¤ 77,247.00 WA71-01
WTR ¤ 105,031.00 WA71-01
TM ¤ 54,007.00 WA71-01
RQT ¤ 39,695.00 WA71-01
FNS ¤ 164,653.00 WA71-01
GLF ¤ 36,799.00 WA71-01
APL ¤ 37,027.00 WA71-01
FTW ¤ 39,619.00 WA71-01
ID Firstname Lastname Title Store ID
10-60150 Maria Doralas Sales Associate CO19
10-60177 Jennifer Tham Sales Associate NM40
10-60192 Tamra Alix Sales Manager CO78
10-60195 Byron Hoese Sales Associate WA71
10-60198 Kelley Zeck Sales Associate WA71
10-60251 Nello Mallory Sales Associate CO20
10-60258 Juan Cerdaro Sales Associate NM73
10-60262 Frieda Ginsburg Sales Associate CO19
10-60285 Margaret Fitzpatrick Sales Associate OR86
10-60299 Chet Lee Sales Associate NM88
10-60359 Reva Lanter Sales Associate NM40
10-60375 Elena Montoya Sales Associate CO19
10-60392 Marcus Simmons Sales Associate OR86
10-60429 Salvador Shames Sales Associate OR86
10-60438 Julette Villanyeve Sales Associate NM40
10-60492 Ellen Gula Sales Associate OR86
10-60722 Vicki Plasek Sales Associate NM52
10-60736 Brendon Gallager Sales Manager OR86
10-60739 Mara Monell Sales Associate WA35
10-60781 Dave Demoura Sales Associate NM88
10-60782 Karen Jones Sales Associate NM88
10-60792 Casey Drees Sales Associate NM88
10-60822 Vic Fowler Sales Associate OR10
10-60825 Naomi Deford Sales Associate OR10
10-60826 Jim Wolfgang Sales Manager NM88
10-60911 Adrea Rhyn Sales Associate OR40
10-60924 Emily Rhoades Sales Associate CO78
10-60925 Jerry Chung Sales Associate OR40
10-60926 Johnie Borello Sales Associate NM88
10-60927 Jake Kettler Sales Associate OR10
10-60944 Sergio Bergan Sales Associate CO19
10-60966 Issac Boerner Sales Associate OR10
10-60971 Michael Stober Sales Associate OR10
10-60977 Skylar Weiden Sales Associate NM40
10-60985 Clifton Durfey Sales Associate WA35
10-60988 Margaret Voboril Sales Manager NM52
10-70115 Heidi Hermann Sales Associate NM40
10-70155 Sandy Elry Sales Associate WA35
10-70175 Jamie Maciejewski Sales Associate NM73
10-70176 Jeff Paolino Sales Associate WA35
10-70193 Casey Creeden Sales Associate NM40
10-70259 Alejandra Balentine Sales Associate NM73
10-70278 Angelique Edstrom Sales Associate WA35
10-70352 Anita Delgado Sales Associate CO19
10-70495 Maricela Fisler Sales Associate NM73
10-70529 Fernando Lopez Sales Associate OR40
10-70578 Helga Cowens Sales Associate CO20
10-70585 Rhea Hopkins Sales Associate NM88
10-70588 Stuart Burbage Sales Associate NM88
10-70625 Lesa Ficke Sales Associate OR40
10-70629 Doretha Glosson Sales Associate CO20
10-70699 Denice Faeth Sales Associate OR69
10-70762 Rae Gerhard Sales Associate NM88
10-70825 Marquite Amodeo Sales Associate OR69
10-70845 Judi Crowston Sales Associate OR40
10-70877 Austin Hallman Sales Associate OR40
10-70915 Araceli Saine Sales Associate OR69
10-70927 Stuart Brittan Sales Associate CO20
10-70955 Fredrick Clune Sales Manager WA35
10-70966 Olivia Perez Sales Associate NM73
SELECT DISTINCTROW * FROM Merchandise;
PARAMETERS __CategoryID Value; SELECT DISTINCTROW * FROM [Quarterly Sales] AS [Merchandise Sales Entry Form] WHERE ([__CategoryID] = CategoryID);
SELECT [Category Experts].Firstname, [Category Experts].Lastname, [Category Experts].City, [Quarterly Sales].QtrSales, Merchandise.Merchandise FROM Merchandise INNER JOIN ([Category Experts] INNER JOIN [Quarterly Sales] ON [Category Experts].ExpertID=[Quarterly Sales].ExpertID) ON Merchandise.CategoryID=[Quarterly Sales].CategoryID ORDER BY [Category Experts].Firstname, [Category Experts].Lastname, Merchandise.Merchandise;
SELECT DISTINCTROW * FROM [Category Experts];
PARAMETERS __ExpertID Value; SELECT DISTINCTROW * FROM [Quarterly Sales] AS [Category Experts Form] WHERE ([__ExpertID] = ExpertID);