Crop Database This database is designed to store information on vegetable seeds for a local garden center. Two tables are to be created. 1. Open Access and create a new database called Crop Database_yourname 2. Create the first table called Crop Varieties using the information below Field Name Variety Name Plant Code Harvest Time Data Type Text Text Text Text Field Sizes 20 20 4 10 3. Set the primary key for the Plant Code field 4. Close the table 5. Create the second table within the same database using the information below. Name it Crop Prices. Field Name Plant Code Page Ref Amount Sold Price Data Type Text Number Number Currency Field Sizes 4 Long Integer Long Integer 2 decimal places 6. Set Primary Key for Plant Code 7. Close the table Relationships 8. Create a relationship between the 2 tables by Plant Code. Forms 9. Create a form based on the Crop Varieties and Crop Prices tables using the Form Wizard a. Insert the following fields: i. Plant Code, Varieties, Name, Harvest Time, Page Ref, Amount Sold, and Price. b. Choose Columnar Style c. Change the theme to one of your choosing d. Name the form Crops Form e. Add buttons to the form that will show the previous record, show the next record, and add a new record. Input Data 10. Using the form, enter the following data: Plant Code 3088 3097 3092 3333 3357 3389 3393 3390 3681 3677 3706 3100 3009 3007 3062 Variety Dwarf French Beans Dwarf French Beans Dwarf French Beans Cabbage Cabbage Carrots Carrots Carrots Lettuce Lettuce Lettuce Lettuce Peas Peas Peas Name Annabel The Prince Masterpiece Spring Hero Casair Cardinal Rocket Campestar Tom Thumb Lakeland Valdor Ice Berg Meteor Little Marvel Onward Harvest Time Summer Summer Summer Spring Winter Spring Spring Autumn Summer Summer Winter Summer Autumn Spring Summer Page Ref 62 63 64 65 68 69 70 71 72 72 74 78 77 77 79 Amount Sold 100 250 200 160 130 255 300 425 120 80 360 350 250 300 120 2. Open both tables to confirm that the information added in the form has been entered. a. Sort both tables by Plant Code in ascending order. Price 0.85 1.15 1.02 1.22 1.29 1.39 0.98 0.75 0.52 0.79 0.66 0.89 0.92 1.02 0.89
© Copyright 2024