Microsoft Access Database Project

Due: Monday, November 12

The objective of this project is for you to demonstrate your proficiency in setting up a simple database table with an entry form, an interesting set of queries, and a nicely formatted report. You may work in teams of no more than two on this project.

Create a database for your CD collection called "CD Collection". (If you do not have a CD collection, make up some CDs.) Call the file yourlastnameCDs.mdb. Include the following components:

a table entitled "CD Data" defining these basic fields -- Style (Rock, Blues, Rap, Christian, Alternative, Jazz, etc.), Artist, Title, Year of Release, Number of Tracks, Total Minutes, Total Seconds -- plus any others that would be logical
a form entitled "CD Entry Form" for the easy entry of data; use the Wizard and choose any appropriate format
at least ten records entered using the form (either for CDs of yours or fictional CDs)
a query entitled "Rock/Alternative since 1995" selecting all records with:

Rock or Alternative style, and
a release date after 1995

a report entitled "Recent Rock/Alternative CDs" listing only the Artist and Album Titles of the records selected in the previous query and formatted nicely

Now go back and add some additional data to your table. Note that both the query and the report based on the query change automatically.

Notes:

Name the database file yourlastnameCDs.mdb
Extra credit consideration will be given for any useful enhancements over and above the requirements of the assignment. Specifically, I would be interested in seeing some of you design a database that you'll actually use.
For the query to be effective/interesting, you must have CDs in your database from the Rock, Alternative and at least two other styles. You must also have CDs with release dates both before and after 1995. Even if you do not own CDs which match these criteria, add some fictional ones just for this assignment.
When you make the report, use the data from the query, not the table containing all of the data.

What you should turn in:

Place the file on a CD and hand it in to me directly.