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