Music Database (Part 1: Tables)

You will create a database of 25 music CD's that you would purchase, if you had an unlimited amount of money. You will use multiple websites to find your information. You will create this database using Microsoft Works Database.

TABLE 1

1. Name this table Music - Table 1
2. Include the following fields in your report:
1. Artist
2. Title of Album
3. Record Company
4. List Price
5. Best Price Found
6. Genre
7. Release Date
8. Picture
3. Create your table and sort it in ascending order by the Title of Album. Print a copy to submit for a grade.

25 points for Table 1. You will receive 1 point off for each record not completed. In addition, you will receive 1 point off for each spelling error found.

TABLE 2

1. Name this table Music - Table 2.
2. Using Table 1, add a field and call it 'Preferences.' Assign each album a number according to the order in which you would purchase it. 1 should be the first purchase you would make and 25 will be the last purchase you would make.
1. Sort your database in ascending order by preference when complete.
2. Print one copy and submit.

25 points for Table 2. You will receive 1 point off for each record not completed. In addition, you will receive 1 point off for each spelling error found.