Latest Questions & Answers

Q: Create a System DSN ODBC connection called Ch02_SaleCo using the

Create a System DSN ODBC connection called Ch02_SaleCo using the Administrative Tools section of the Windows Control Panel.

Q: Use MS Excel to connect to the Ch02_InsureCo MS Access

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.

Q: Use MS Excel to connect to the Ch02_InsureCo MS Access

Use MS Excel to connect to the Ch02_InsureCo MS Access database using ODBC, and retrieve all of the CUSTOMERs.

Q: Create a sample XML document and DTD for the exchange of student

Create a sample XML document and DTD for the exchange of student transcript data. Use your college transcript as a sample.

Q: Create a sample XML document and DTD for the exchange of order

Create a sample XML document and DTD for the exchange of order data.

Q: Write a query to count the number of invoices. FIGURE

Write a query to count the number of invoices. FIGURE P7.26 THE CH07_SALECO DATABASE

Q: Use MS Excel to connect to the Ch02_InsureCo MS Access

Use MS Excel to connect to the Ch02_InsureCo MS Access database using ODBC, and retrieve all of the AGENTs.

Q: Using the data provided in the Ch13_SaleCo_DW database

Using the data provided in the Ch13_SaleCo_DW database, solve the following problem. What is the SQL command to list the number of product sales (number of rows) and total sales by month, with subtota...

Q: Using the data provided in the Ch13_SaleCo_DW database

Using the data provided in the Ch13_SaleCo_DW database, solve the following problem. What is the SQL command to list the total sales by month and product category, with subtotals by month and a grand...

Q: Using the data provided in the Ch13_SaleCo_DW database

Using the data provided in the Ch13_SaleCo_DW database, solve the following problem. What is the SQL command to list the total sales by region and customer, with subtotals by region and a grand total...