Computer and Information Sciences
ITEC 315
Database Connectivity: Excel to Access
For this exercise you will submita Word document and the Excel document.
Use the database Ch02_InsureCo (you will need to download and save to a location on your computer).
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.
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.
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.
WORKSHEET Towson University Computer and Information Sciences ITEC 315 Database Connectivity: Excel to Access For this exercise you will submit a Word document and the Excel document. Use the database Ch02_InsureCo (you will need to download and save to a location on your computer). 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. 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. 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.
Already registered? Login
Not Account? Sign up
Enter your email address to reset your password
Back to Login? Click here