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