VC 5
Asking Questions of Business Data
Querying an Access Database
Note: VC5 is UNGRADED, and you are not required
to turn anything in or create the queries and reports. However, you are encouraged to read the
case and even create the queries and reports to help prepare you for quizzes
and VC6.
Background
Now that your transaction data is contained in an Access database
(VC 4), you can utilize one of the real benefits of a relational database
system like Access: you can ask
complex questions about the data and get answers.
Assignment
Using a database management system (DBMS) (Access again),
you are to build an application system to support the information needs of
the EDS Marketing Department. The transaction processing system you
created in VC 4 provides the basis for the OLAP system you will create
in this assignment.
I.
As part of your last assignment, you created three
tables: A product table that contains information about the company’s
products, a customer table that contains customer information, and an order
table that keeps track of all orders. Now you need to use the data in these
tables and query the database to get answers to specific questions. Answer
the following ad hoc questions, and show your answers in Report format:
·
In alphabetical order, list the name and
address for all customers in Minnesota (MN).
·
List the order date and name of all customers
who purchased a Rider snowboard.
·
Provide the total sales amount for all
snowboards sold over the Internet.
·
Provide the total sales amount for all
snowboards sold over the phone.
·
Provide the total sales amount for all
snowboards sold through sales representatives.
·
How many customers purchased a Rider snowboard
over the Internet?
·
List the customers name and card type for all
customers who purchased a snowboard using a Misery Card or Vista
credit/debit card.
II.
Make up 3 additional questions on your own whose
answers might be useful to EDS. Make
sure at least one report uses data from several tables. Show your answers in Report format.
|