Question: 5. Open the Plants table and make the following changes. You may work in Datasheet view or Design view as appropriate. a. Set the field

 5. Open the Plants table and make the following changes. Youmay work in Datasheet view or Design view as appropriate. a. Set

5. Open the Plants table and make the following changes. You may work in Datasheet view or Design view as appropriate. a. Set the field size for the PlantID field to: 12 b. Rename the FlowerColor field to: BloomColor c. O Set the Default Value property for the BloomColor field to red. d. Add a lookup field named PreferredFertilizer to the end of the Plants table to reference the FertilizerName field in the Fertilizers table. The lookup list should be sorted alphabetically by the FertilizerName data. The primary key field should be hidden. Enforce referential integrity. e. Add an Attachment field after the PreferredFertilizer field. Add the image azaleas.jpg to the record for the Mountain azalea. f. Delete the MaxHeightFeet field. g. Save and close the table.A Halun.Harris-AC2019-ChallengeYourself-2-3-ALT (1) : Database- C:\\Users\\OWNER\\OneDrive\\Documents\\Halun.Harris-AC2019-ChallengeYourself-2-3-ALT (1).accdb (Access 2007 - 2016 file format) - Access Halun Harris X File Home Create External Data Database Tools Help Table Design Tell me what you want to do X Cut 2 1 Ascending Selection New Z Totals O S'c Replace [A Copy A J Descending Advanced Spelling Refresh Save Paste Filter Find GO TO View Format Painter Remove Sort Toggle Filter All X Delete More Select v Undo Views Clipboard Sort & Filter Lookup Wizard Text Formatting IS X All Access Objects O Finish Field Properties General Lookup Display Control List Box Row Source Type Table/Query Row Source Bound Column Column Count Column Heads No The data type determines the kind of values that Column Widths users can store in the field. Press F1 for help on data types. Allow Multiple Values No Allow Value List Edits Yes List Items Edit Form Show Only Row Source Valu No Lookup Wizard Num Lock n P 12:47 PM 92 F W

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!