redo my Database homework

User Generated

z6nn6

Computer Science

Description

Hello! 

i have homework and its already done I just want you to redo it for me.  the is the homework file HW.zip 

I neeed you just to take a screenshots and post it and this is the solutions for the HW Answers

Thank you 

Unformatted Attachment Preview

1. Use MS Excel to connect to the Ch02_InsureCo MS Access database and retrieve all of the AGENTs. Put results on its own sheet called Agent. Copy (ALT-PRTSC) and paste results. AGENT_CODE AGENT_LNAME AGENT_FNAME AGENT_INITIAL AGENT_AREACODE AGENT_PHONE 501 Alby Alex B 713 228-1249 502 Hahn Leah F 615 882-1244 503 John T 615 123-5589 Okon 2. Use MS Excel to connect to the Ch02_InsureCo MS Access database and retrieve all of the CUSTOMERs. Put results on its own sheet called Customer. Copy (ALT-PRTSC) and paste results. CUS_CO CUS_LNA CUS_FNA CUS_INITI CUS_AREAC CUS_PHO CUS_INSURE_T CUS_INSURE_ CUS_RENEW_D AGENT_CO DE ME ME AL ODE NE YPE AMT ATE DE 10010 Ramas Alfred A 615 844-2573 T1 100 4/5/2012 502 10011 Dunne Leona K 713 894-1238 T1 250 6/16/2012 501 10012 Smith Kathy W 615 894-2285 S2 150 1/29/2013 502 10013 Olowski Paul F 615 894-2180 S1 300 10/14/2012 502 10014 Orlando Myron 615 222-1672 T1 100 12/28/2013 501 10015 O'Brian Amy B 713 442-3381 T2 850 9/22/2012 503 10016 Brown James G 615 297-1228 S1 120 3/25/2013 502 10017 Williams George 615 290-2556 S1 250 7/17/2012 503 10018 Farriss Anne G 713 382-7185 T2 100 12/3/2012 501 10019 Smith Olette K 615 297-3809 S2 500 3/14/2013 503 3. Use MS Excel to connect to the Ch02_InsureCo MS Access database and retrieve all of the Customers with Agent Data (use qryCustomerAgentView) for Agent 502. Put results on its own sheet called CustomerAgentView. Copy (ALT-PRTSC) and paste results. CUS _CO DE 100 10 100 12 100 13 100 16 CUS_ LNA ME Rama s Smit h Olow ski Brow n CUS_ FNA ME Alfre d CUS_ INITI AL CUS_A REACO DE A 615 Kathy W 615 Paul Jame s F 615 G 615 CUS_ PHO NE 8442573 8942285 8942180 2971228 CUS_IN SURE_T YPE CUS_IN SURE_A MT T1 100 S2 150 S1 300 S1 120 CUS_RE CUSTOME AGENT.A NEW_D R.AGENT_ GENT_C ATE CODE ODE 4/5/201 2 502 502 1/29/20 13 502 502 10/14/2 012 502 502 3/25/20 13 502 502 AGEN T_LNA ME AGEN T_FNA ME AGEN T_INIT IAL AGENT_ AREACO DE Hahn Leah F 615 Hahn Leah F 615 Hahn Leah F 615 Hahn Leah F 615
Purchase answer to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer


Anonymous
Really helped me to better understand my coursework. Super recommended.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Related Tags