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.