College Database

Create a new database and name it 'College Database.' Going to http://www.google.com/ or http://www.yahoo.com/, research and retrieve the following information for your database. Complete a total of 10 colleges and/or universities. Field names and data types are as follows:

1. School Name (text)
2. Web Address (text)
3. City (text)
4. State (text)
5. Mascot (text)
6. Mascot Picture (general)
7. Tuition price (currency)
8. Athletic Conference (text)

Part 1: Create a new database and research the above fields. Create the list view, making sure to make all the necessary changes in the page setup, add a header with your name in the left, College Database in the center, and date in the right. Also, increase the size of your rows to 20 or 30.

Part 2: Design a form that includes all the information in the database. Include text labels to better organize the form and try to fit 1 record per page. The text labels should be College Information (includes school name, website, city, and state); Cost (includes tuition); Athletic Information (mascot nam and athletic conference) and Mascot (picture of mascot) BE SURE TO REMOVE THE FIELD NAME FOR PICTURE! *Remember: the text labels should be larger than the rest of your text! (Make the changes in page setup).

Part 3: Create 3 reports using the database. Report 1 must be sorted by School name in ascending order. Average the Tuition price field. Report 2 must include a filter for Tuition Price. Report 3 must be sorted and grouped by either State or Conference. Include a sum and average for tuition. DO A PRINT SCREEN FOR EACH OF THE REPORTS BEFORE PRINTING THEM OUT! Be sure to label them accordingly.

This database is worth a total of 80 POINTS. List view = 25; Form view = 25; Reports = 10 points each.

Save in your MP3 folder as College Database

Ebay Database

Using the fifteen "Wishlist" items that you researched last class, create a database that organizes this information.

Step 1 - List View (30 points)

1. Create a list with these fields (Category, Item Description, Seller, Location, Price, Picture).
2. Save the list as "Ebay Database".
3. When you are finished entering the fields, you should begin entering your information, using Ebay for the research. You should have 15 records when you are finished. 
4. Modify the table with your own font, colors, borders, etc. (Select your entire list view, go to Format > Field, and change the areas that you wish.)
5. Change the record height of your list view. Go to Format > Record Height and change it to 20
6. Go to File > Page Setup and click on the Source, Size, and Orientation tab. Make the orientation landscape. Then go to the Other Options tab and click Print gridlines and Print record and field labels.
7. Go to View > Headers and Footers. Put your name in the left header, Ebay Database in the center, and the date in the right header.
8. Print to either of the color printers when finished. Put in on the front table.

Step 2 - Reports  (10 points each)

1. Create a report that includes all fields EXCEPT Picture. Sort by PRICE in DESCENDING order.

• Create a border around your records. To do this, select the entire report view. Go to Format > Border.  Under Border Location, click on all the boxes on the left and all of the boxes on the bottom. (This will put lines around your entire print out).
• Go to File > Page Setup and make the same changes that you did in number 6 above.
• Before printing, check our your print preview. If the text in your header is coming out really big, change the size of your font to anything other than 12. Hit the print screen key and paste it into Word. Make sure to print screen all pages!!

2. Choose any fields that you would like to add. Create a report that will be SORTED AND GROUPED by CATEGORY. Print screen and print!!

3. Choose any fields that you would like to add. Create a report that will FILTER Prices that are > or < a price that works for you. Print screen and print!!

4. Create a report that will include all fields except PICTURE. Sort by Seller in ascending order. Create a field summary that will find the Sum, Average, Minimum, and Maximum for the price field (be sure to select this on the left hand side under Summary BEFORE clicking the summary boxes). Print screen and print!!

Step 3 - Form (30 points)

Create a form that includes ALL FIELDS.

• Create three different labels. Go to Insert > Label. 1) Category/Item Description 2) Product/Price 3) Seller Information. See example for set up.
• Click on the picture field. Go to Format > Show Field Names. This will take out the field name for the picture.
• Design the form with colors, borders, backgrounds, and change the fonts if you wish.
• Go to File > Page Setup. Set the orientation on Landscape. Then go to other options, and under Details, click on Print Field lines and make sure the the Page Breaks Between Records box is UNCHECKED.

Resave EVERYTHING as Ebay Database

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.