Learning Goal: I’m working on a databases question and need guidance to help me learn.
Database Connectivity and Web Technologies
Questions:
- Use MS Excel to connect to the Ch02_InsureCo MS Access database using ODBC, and retrieve all of the AGENTs.
(Example: ch15_problem1_Jones.xls)
- Use MS Excel to connect to the Ch02_InsureCo MS Access database using ODBC, and retrieve all of the CUSTOMERs.
(Example: ch15_problem1_Jones.xls)
- Use MS Excel to connect to the Ch02_InsureCo MS Access database using ODBC, and retrieve the customers whose AGENT_CODE is equal to 503.
(Example: ch15_problem1_Jones.xls)
- Create a System DSN ODBC connection called Ch02_SaleCo using the Administrative Tools section of the Windows Control Panel.
(Example: ch15_problem1_Jones.xls)
- Use MS Excel to list all of the invoice lines for Invoice 103 using the Ch02_SaleCo System DSN.
(Example: ch15_problem1_Jones.xls)
- Create a System DSN ODBC connection called Ch02_Tinycollege using the Administrative Tools section of the Windows Control Panel.
(Example: ch15_problem1_Jones.xls)
- Use MS Excel to list all classes taught in room KLR200 using the Ch02_TinyCollege System DSN.
(Example: ch15_problem1_Jones.xls)
- Create a sample XML document and DTD for the exchange of customer data. Use Section 15-3a as your guide.
(Example: ch15_problem1_Jones.doc)
- Create a sample XML document and DTD for the exchange of product and pricing data. Use Section 15-3a as your guide.
(Example: ch15_problem1_Jones.doc)
- Create a sample XML document and DTD for the exchange of order data. Use Section 15-3a as your guide.
(Example: ch15_problem1_Jones.doc) - Create a sample XML document and DTD for the exchange of student transcript data. Use your college transcript as a sample. Use Section 15-3a as your guide.
(Example: ch15_problem1_Jones.doc)
![](https://nursingpaperwriting.com/wp-content/uploads/2020/03/bottom-post.png)