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.