CSc 050
Assignment 5 - Databases Part II
Due Mon, Oct. 17, 2005


In this assignment, you will add to the database you created last week by making it more user-friendly. You will create reports from your queries and tables that will look more professional than the results you worked with last week. You will also create a special form called a switchboard that can be used to easily run often-needed queries.

Part 1: Fix your design (if needed) (2 pts.)
If you lost points on the design of your tables for Part I of this assignment, be sure to correct those design flaws before turning this assignment in. If you don't correct them, you will lose points for those design flaws again. If you haven't gotten your assignment back yet, you can still continue on with the rest of this assignment and then fix things later.

Part 2:Create reports (10 pts.)
Create three reports with Access. The first should be a listing of all customers and customer-related information from your database. The second should be a report generated from query #8 on the last assigment: the one that lists purchases about a pre-specified artist. Because this query is parametrized, the report will be too. That is, this one report will generate different results depending on which artist the user inputs.

The third report is one of your choosing. It can be based on a table, on an existing query, or on a new query you write. This third report should have at least one relevant graphic on it. Be sure to title this (and any) report appropriately to make it easy for the reader to know what information is being displayed.

Part 3: Create a switchboard (5 pts.)
Create a switchboard that will list the three reports you made in the previous section and run them at the touch of a button. Customize the layout of the switchboard form to your own tastes. Feel free to include graphics and additional text.

HTML: Publishing (3 pts.)

Publish your web page onto the antipasto web server as demonstrated in class. Include all pictures, text, and hyperlinks. Write down the URL of your web page on your Access assignment before turning it in.

What to turn in

Turn in an electronic copy of your database on Blackboard. Be sure to name it with YOUR NAME. Print out your three database reports and turn them in on paper. Don't forget to write down the URL of your web page!

Administrative statement

Homeworks are individual projects. I encourage you to talk to others about the general nature of the homework and ideas about how to pursue it. However, the technical work, the writing, and the inspiration behind these must be substantially your own. If any person besides you contributes in any way to the project, you must credit their work on your homework. Similarly, if you include information that you have gleaned from other published sources, you must cite them as references. Looking at, and/or copying, other people's homework or written work is inappropriate and will be considered cheating.
Back to Homework Index