AE$1-2$

The database in the Microsoft Access file Ch$01$Ex$02\_$U$12$e$.$accdb contains the

same records of employee activity on special projects as in AE$1-1.$ Before

proceeding, open that database and view the records in the Employee Hours

table.

a$.$ Eight queries have been created that process this data in different ways.

Using the criteria of accuracy, relevancy, and sufficiency, select the single

query that is most appropriate for the information requirements in AE$1-$

$1,$ parts a$-$f$.$ If no query meets the need, explain why.

b$.$ What conclusions can you make from this exercise?

c$.$ Comparing your experiences on these two projects, what are the

advantages and disadvantages of spreadsheets and databases?

$13567101112141516171819202113$ Duong, Linda$410131617181920$Denver Chicago$21$Af Employee NameEmployee NameAshley, Jane$11$Davidson Kaye$12$Ching, Kam HoongCollins,GiovanniCorning,Sandra$13$Scott, Rex$14$Corovic.Jose$15$Lane, BrandonWei, Guang$16$Dixon,Eleanore$17$Lee,Brandon$11$ Angel, Kathy$1812$ Quigly, JamesBosa, VictorDrew, RichardAdams, James$14$ Jordan, MatthewLunden,HaleyUTran,Diem Thi$15$ Bernard, StevenAEmployee NameDixon, James TGoston, SayehSpenser, WilliamRay, AnthonyRyan, MarkRikki, NicoleScott, BryanWarrem, JasonLa Pierre,Annaf$*$ Employee NamePham,Mary$10$ Daniel, JamesEmployee NameCasimiro, AmandaMcGovern, AdrianMenstell,Lori LeeJefferies DavidNurul,NicoleGarrett, JamesAustin, JamesRedmond, ElizabethDeptMktDenver Chicago RenoAcctOpsOpsMktMktAcctAcctBAcctOpsOpsMktMktRenoAcctAcctOpsMktDeptMktMktAcct$|$AcctAcctOpsOpsOpsOpsOpsBMktSalesDeptOpsAcctMktMktMktOpsSalesMktSalesCPlantDenverDenverDenverDenverDenverDenverDenverDenverDenverDenverDenverDenverDenverDenverDenverDenverDenverBCPlantProjectMarket AnalysisQuota ComputationSourcing ReviewChicago Sourcing ReviewChicago Production PlanningChicago Production PlanningChicago Production PlanningAcct Chicago Production PlanningAcct Chicago Quota ComputationChicago Quota ComputationChicago Sourcing ReviewProduction PlanningMarket AnalysisSourcing ReviewSourcing ReviewProduction PlanningProduction PlanningProduction PlanningSourcing ReviewDQuota ComputationProduction PlanningQuota ComputationSourcing ReviewProduction PlanningQuota ComputationTotal HoursChicago Quota ComputationChicago Quota ComputationChicago Sourcing ReviewCPlantRenoChicago Quota ComputationChicago Quota ComputationRenoRenoRenoRenoProjectRenoRenoRenoRenoDTotal HoursProjectDSourcing ReviewSourcing ReviewSourcing ReviewProduction PlanningProduction PlanningProduction PlanningQuota ComputationSourcing ReviewQuota ComputationTotal HoursHoursWorkedEHoursWorked$2712151818171622291951129$E$257$EHoursWorked$17232119201127274220717229122122101521352130201751931327$GHGGChicagoProduction Planning