Music Album Database (Part 3: Reports)

You will be creating 4 DIFFERENT reports using your Music Album Database. Below are the requirements for each report.

Report 1

• Create a report that will include ALL fields EXCEPT picture. Sort by Artist in ascending order. Go to Format > Border, so that there is a line between each record.

Report 2

• Create a report that will be grouped by Record Label and Sorted by Record Label. Choose any additional fields that you would like to add.

Report 3

• Create a report that will filter either Artist or prices. Find a price that works if the first one does not.

Report 4

• Create a report that will include Artist and the two prices. Create a field summary that will find the Sum, Average, Minimum, and Maximum for the prices.

The reports must include the proper header with your name and block in the left, title of database in the middle, and date in the right.

Each report is worth 10 points.

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.

Movies Database (Part 2 - Forms)

For part 2, you will be designing 2 forms following the directions below. Please refer to the requirements below for specific instructions:

Form 1:

1. Create a form that includes all fields EXCEPT Gross income.

2. DO NOT add a subform

3. Arrange the form using the "Columnar - labels on top" option

4. Choose "Form is to display all data"

5. Choose any color you like for the style, and select "Flat or 3D look" as the field border option.

6. Name the form "Movie Form 1", then select Modify the form

7. Insert a header with your name by going to Insert > Header; Default

8. Insert a picture of the movie poster for each movie. Go to Google images to search for a picture of a filmstrip. Save this picture in your MP1 folder and insert into the form. Once you have found the picture go to Insert > Picture > From File and insert the picture into the form. Resize it and place it in the center of the form to the right of the information.

9. Then, using the tools, design the form however you would like.

Print and submit.

Form 2:

1. Create a form that includes all fields EXCEPT Director, Lead Actor, and Lead Actress.

2. DO NOT add a subform

3. Arrange the form using "Columnar - labels on left" option

4. Choose "Form to display all data"

5. Choose any color you like for the style and select "3D" as the field border option

6. Name the form "Movie Form 2", then select Modify the form

7. Insert a header with your name

8. Insert a picture of a dollar sign using Google images.

9. Design the form any way that you would like.

Print and submit.

Each form is worth 10 points.

Movies Database (Part 1: Table)

The Movies database table must include the following fields:

Movie title

Director

Lead Actor

Lead Actress

Year Released

Genre
Runtime

Total Gross Income

• The table must be sorted in chronogical order by Year Released
• Increase the row height to .6
• When you are finished designing the table you should have 8 fields (columns) and 20 records (rows).
• You are not able to print the table design, so be sure and show it to me so that I can grade it.

This table of the project is worth 20 points.