Fertilizers Fertilizer Name Nutrient Ratio Price Form Map

Fertilizersfertid Fertilizername Nutrientratio Price Formmap1 Monoammo

Fertilizers FertID FertilizerName NutrientRatio Price Form MAP1 Monoammoniu $25.00 Granule NSO1 Nitrogen Soluti 28-0-0 $12.00 Liquid PCU1 Polymer Coate 44-0-0 $35.00 Slow-Release Total $72.00 SO LUTIO N SAM PLE Plants PlantID CommonName ScientificName FlowerColor DatePlanted MaxHeightFeet PurchasePrice PreferredFertilizer G AGPU5 Gerardia Agalinis purpurea Purple 10-Apr-10 6 $4.50 Monoammonium phos G(0) ALFA2 White colicroot Aletris farinosa White 03-May-11 3.5 $7.50 Polymer Coated Urea G(0) AMTA2 Eastern bluestar Amsonia tabernaemont Blue 02-May-06 3 $7.50 Nitrogen Solution G(0) ANBE Wind-flower Anemone berlandieri Purple 12-Apr-10 1 $4.00 G(0) AQCA Eastern red colum Aquilegia canadensis Red 30-Mar-07 2 $8.25 G(0) ASTU Butterflyweed Asclepias tuberosa Orange 14-Apr-09 2 $11.50 G(0) BAAL White wild indigo Baptisia alba White 16-Apr-01 4 $6.25 G(0) BAAU Blue wild indigo Baptisia australis Blue 16-Apr-12 4 $6.25 G(0) COER Widow's tears Commelina erecta Blue 06-May-12 3 $4.95 G(0) COGL2 Coastal tickseed Coreopsis gladiata Yellow 30-Apr-10 5 $3.15 G(0) COLA5 Lanceleaf tickseed Coreopsis lanceolata Yellow 13-May-10 2.5 $5.25 G(0) CONU5 Georgia tickseed Coreopsis nudata Pink 30-Apr-09 5 $3.15 G(0) GAPU Firewheel Gaillardia pulchella Red 01-Apr-09 2 $5.50 G(0) GEMA Spotted geranium Geranium maculatum Purple 16-May-09 3 $4.50 G(1) HEDE4 Beach sunflower Helianthus debilis Yellow 20-Apr-10 6 $3.50 G(0) IPRU2 Standing cypress Ipomopsis rubra Red 23-Apr-10 4 $6.50 G(0) KOVI Seashore mallow Kosteletzkya virginica White 22-Apr-13 5 $8.25 G(0) LOCA2 Cardinal flower Lobelia cardinalis Red 19-Apr-13 6 $9.50 G(0) LUPE3 Wild lupine Lupinus perennis Blue 28-Apr-13 2 $5.85 G(0) MOFI Wild bergamot Monarda fistulosa Pink 01-May-13 5 $3.50 G(0) MOPU Horsemint Monarda punctata White 27-Apr-10 3 $4.90 G(0) PECO4 Wild foxglove Penstemon cobaea White 15-May-10 2 $2.90 G(0) PHNI Trailing phlox Phlox nivalis Pink 31-Mar-03 1.5 $2.50 G(0) RHAL4 Savannah meadow Rhexia alifanus Pink 05-Apr-09 2 $1.90 G(0) RHCA7 Wild azalea Rhododendron canescen White 11-Apr-10 8 $10.50 G(0) RHVI Handsome Harry Rhexia virginica Pink 10-Apr-11 3 $6.80 G(0) RUHI2 Black-eyed Susan Rudbeckia hirta Yellow 22-Apr-10 2 $3.15 G(0) SACO5 Scarlet sage Salvia coccinea Red 05-May-11 3 $8.20 G(0) YUFI Adam's needle Yucca filamentosa White 09-May-12 6 $10.90 G(0) SO LUTIO N SAM PLE n-AC2013-ChallengeYourself-2-3-resources/geranium.jpg A Skills Approach: Access 2013 Chapter 2: Working with Tables 1 | Page challenge yourself 2.3 Last Updated 4/3/15 challenge yourself 2.3 In this project you will continue working with the greenhouse database from Chapter 1, Challenge Yourself 1.3. Make sure to extract the file(s) after downloading the resources zipped folder. Visit the SIMnet instant help for step- by-step instruction. 1. Open the start file AC2013-ChallengeYourself-2-3. 2. If necessary, enable active content by clicking the Enable Content button in the Message Bar. 3. The file will be renamed automatically to include your name. Change the project file name if directed to do so by your instructor, and save it. 4. Create a new table in Datasheet view using the following data. Allow Access to create the AutoNumber ID field for now. e. Name the table: Fertilizers 5. Change the Data Type of the Price field to use the Currency format. 6. Delete the ID field that Access created and add a new primary key field. Switch back and forth between Datasheet view and Design view as necessary, saving the table when prompted to do so by Access. Step 1 Download start file a. A b. B c. C d. d A Skills Approach: Access 2013 Chapter 2: Working with Tables 2 | Page challenge yourself 2.3 Last Updated 4/3/15 a. Delete the ID field. b. Insert a new field at the beginning of the table. Name the field: FertID c. Set the Data Type to Short Text. d. Enter the following three values (in the appropriate record) under the FertID field: MAP1, PCU1, NSO1 e. Make the FertID field the Primary Key. 7. Add a new lookup field. You can use Datasheet view or Design view, whichever you prefer. a. Name the new field: Form b. The lookup field should display the following four values: Granule, Liquid, Slow-Release, Organic c. Limit data entry to the values in the list. d. Test this field by choosing any form for the three plants. Save the changes to the table. 8. Add a Total row in Datasheet view that sums up all the fertilizer prices. 9. Save and close the Fertilizers table. 10. Open the Plants table and make the following changes: a. Add a lookup field named PreferredFertilizer to the Plants table to reference the FertilizerName field in the Fertilizers table. The lookup list should be sorted alphabetically by the FertilizerName data. It is not necessary to limit values to the list. b. Test this field by choosing any fertilizer for the first three plants. c. Resize all the columns in the table to best fit the data. d. Add an Attachment field. Add the image geranium.jpg to the record for the spotted geranium. e. Change the Format property of the DatePlanted field to Medium Date. f. Set the Default Value property for the FlowerColor field to white and add a Description for this field that reads: Main color only. Do not enter multiple colors. g. Save and close the table. 11. Review the table relationships and make the following changes. a. Show all the tables in the Relationships window. b. Create a one-to-many relationship between the PlantID field in the Plants table and the PlantID field in the MaintenanceLog table. Enforce referential integrity. c. Modify the relationship between the FertID field in the Fertilizers table and the PreferredFertilizer field in the Plants table to enforce referential integrity. d. Close the Relationships window, saving the layout changes. 12. Save and close the database. Exit Access. 13. Upload and save your project file. 14. Submit project for grading. Step 2 Upload & Save Step 3 Grade my Project Download Resources